|
|
MORE EXCEL KEYBOARD SHORTCUTS
- Activate a cell and the formula bar (F2)
- Activate and clear the formula bar when a cell is selected, or delete the preceding character in the formula bar (BACKSPACE)
- Activate the Auto Complete list (Alt + Down Arrow)
- Alternate between displaying cell values and displaying cell formulas
(Ctrl + `(single left quotation mark))
- (Alternate between hiding objects, displaying objects, and displaying placeholders for objects (Ctrl + 6)
- Apply or remove an underline (Ctrl + U)
- Apply or remove bold formatting (Ctrl + B)
- Apply or remove italic formatting (Ctrl + I)
- Apply or remove strike through formatting (Ctrl + 5)
- Apply the Currency format with two decimal places (negative numbers appear in parentheses) (Ctrl + SHIFT + $)
- Apply the Date format with the day, month, and year (Ctrl + SHIFT + #)
- Apply the Exponential number format with two decimal places (Ctrl + SHIFT + ^)
- Apply the General number format (Ctrl + SHIFT + ~)
- Apply the outline border (Ctrl + SHIFT + &)
- Apply the Percentage format with no decimal places (Ctrl + SHIFT + %)
- Apply the Time format with the hour and minute, and indicate A.M. or P.M. (Ctrl + SHIFT + @)
- Apply the two-decimal-place format with commas (Ctrl + SHIFT + !)
- Calculate all sheets in all open workbooks F9 or (Ctrl + EQUAL SIGN)
- Calculate the active sheet (SHIFT + F9)
- Cancel a cell entry (ESC)
- Cancel an entry in the cell or formula bar (ESC)
- Carry out the Cells command (Format menu) (Ctrl + 1)
- Carry out the Style command (Format menu) (Alt + ' (apostrophe))
- Clear the selection of formulas and data (DELETE)
- Collapse the selection to the active cell (SHIFT + BACKSPACE)
- Complete a cell entry and move down in the selection (ENTER)
- Complete a cell entry and move to the left in the selection (SHIFT + TAB)
- Complete a cell entry and move to the right in the selection (TAB)
- Complete a cell entry and move up in the selection (SHIFT + ENTER)
- Complete a cell entry (ENTER)
- Complete a cell entry (ENTER)
- Copy a formula from the cell above the active cell into the cell or the formula bar (Ctrl + ' (apostrophe))
- Copy the selection (Ctrl + C)
- Copy the value from the cell above the active cell into the cell or the formula bar (Ctrl + SHIFT + ")
- Create names from cell text (Ctrl + SHIFT + F3)
- Cut the selection (Ctrl + X)
- Define a name (Ctrl + F3)
- Delete text to the end of the line (Ctrl + DELETE)
- Delete the character to the left of the insertion point, or delete the selection (BACKSPACE)
- Delete the character to the right of the insertion point, or delete the selection (DELETE)
- Delete the selection (Ctrl + MINUS SIGN)
- Display step 2 of the Function Wizard, after you type a valid function name in a formula (Ctrl + A)
- Edit a cell note (SHIFT + F2)
- Enter a formula as an array formula (Ctrl + SHIFT + ENTER)
- Enter the date (Ctrl + SEMICOLON)
- Enter the time (Ctrl + SHIFT + COLON)
- Extend the selection by one cell (SHIFT + Arrow key)
- Extend the selection down one screen (SHIFT + Page Down)
- Extend the selection to the beginning of the row (SHIFT + HOME)
- Extend the selection to the beginning of the worksheet (Ctrl + SHIFT + HOME)
- Extend the selection to the cell in the lower-right corner of the window (SHIFT + END)
- Extend the selection to the cell in the upper-left corner of the window (SHIFT + HOME)
- Extend the selection to the edge of the current data region (Ctrl + SHIFT + Arrow key)
- Extend the selection to the end of the data block in the direction of the Arrow (END, SHIFT + Arrow key)
- Extend the selection to the last cell in the current row (unavailable if you've selected the Transition Navigation Keys check box) (END, SHIFT + ENTER)
- Extend the selection to the last cell in the worksheet (lower-right corner) (Ctrl + SHIFT + END)
- Extend the selection to the last cell in the worksheet (lower-right corner) (END, SHIFT + HOME)
- Extend the selection up one screen (SHIFT + Page Up)
- Fill down (Ctrl + D)
- Fill the selected cell range with the current entry (Ctrl + ENTER)
- Fill to the right (Ctrl + R)
- Hide columns (Ctrl + 0 (zero))
- Hide rows (Ctrl + 9)
- Insert a line break (Alt + ENTER)
- Insert a tab character in a cell (Ctrl + Alt + TAB)
- Insert a tab character (Ctrl + Alt + TAB)
- Insert blank cells (Ctrl + SHIFT + PLUS SIGN)
- Insert the argument names and parentheses for a function, after you type a valid function name in a formula (Ctrl + SHIFT + A)
- Insert the AutoSum formula (Alt + EQUAL SIGN)
- Move between unlocked cells in a protected worksheet (TAB)
- Move by one block of data within a row or column (END, Arrow key)
- Move clockwise to the next corner of the selection (Ctrl + PERIOD)
- Move from bottom to top within the selection, or move to the left one cell if only one row is selected (SHIFT + ENTER)
- Move from left to right within the selection (TAB)
- Move from right to left within the selection (SHIFT + TAB)
- Move from top to bottom within the selection, or move to the right one cell if only one row is selected (ENTER)
- Move one cell in a given direction (Arrow key)
- Move one screen down (Page Down)
- Move one screen to the left (Alt + Page Up)
- Move one screen to the right (Alt + Page Down)
- Move one screen up (Page Up)
- Move to the beginning of the row (HOME)
- Move to the beginning of the worksheet (Ctrl + HOME)
- Move to the cell in the lower-right corner of the window (END)
- Move to the cell in the upper-left corner of the window (HOME)
- Move to the edge of the current data region (Ctrl + Arrow key)
- Move to the last cell in the current row (unavailable if you've selected the Transition Navigation Keys check box) (END, ENTER)
- Move to the last cell in the worksheet (in the lower-right corner) (Ctrl + END)
- Move to the last cell in the worksheet (in the lower-right corner) (END, HOME)
- Move to the left between nonadjacent selections (Ctrl + Alt + Left Arrow)
- Move to the next pane (F6)
- Move to the next sheet in the workbook (Ctrl + Page Down)
- Move to the next workbook (Ctrl + F6)
- Move to the previous pane (SHIFT + F6)
- Move to the previous sheet in the workbook (Ctrl + Page Up)
- Move to the previous workbook (Ctrl + SHIFT + F6)
- Move to the right between nonadjacent selections (Ctrl + Alt + Right Arrow)
- Paste a name into a formula (F3)
- Paste the selection (Ctrl + V)
- Remove all borders (Ctrl + SHIFT + _ )
- Repeat the last action (F4)
- Scroll the screen left or right one column (Left Arrow)
- Scroll the screen up or down one row UP ARROW)
- Select a range around the active cell (the selected range is an area enclosed by blank rows and blank columns) (Ctrl + SHIFT + *)
- Select all cells that are directly or indirectly referred to by formulas in the selection (Ctrl + SHIFT + { )
- Select all cells that contain a note (Ctrl + SHIFT + ?)
- Select all cells with formulas that refer directly or indirectly to the active cell (Ctrl + SHIFT + } )
- Select cells whose contents are different from the comparison cell in each row (for each row, the comparison cell is in the same column as the active cell ) (Ctrl + \ )
- Select cells whose contents are different from the comparison cell in each column (for each column, the comparison cell is in the same row as the active cell ) (Ctrl + SHIFT + | )
- Select only cells that are directly referred to by formulas in the selection (Ctrl + [ )
- Select only cells with formulas that refer directly to the active cell (Ctrl + ] )
- Select only visible cells in the current selection (Alt + SEMICOLON)
- Select the current region (Ctrl + SHIFT + *)
- Select the entire array that the active cell belongs to (Ctrl + /)
- Select the entire column (Ctrl + SPACEBAR)
- Select the entire row (SHIFT + SPACEBAR)
- Select the entire worksheet (Ctrl + A)
- Select the next group of items (UP ARROW)
- Select the next item within the group (Right Arrow)
- Select the previous group of items (Down Arrow)
- Select the previous item within the group (Left Arrow)
- Show or hide the Standard toolbar (Ctrl + 7)
- Start a formula (EQUAL SIGN)
- Start a new line in the same cell (Alt + ENTER)
- Turn End mode on or off (END)
- Turn Scroll Lock on or off (SCROLL LOCK)
- Undo the last action (Ctrl + Z)
- Unhide columns (Ctrl + SHIFT + ( (left parenthesis))
- Unhide rows (Ctrl + SHIFT + ) (right parenthesis))
|
This document is devoted to using the keyboard instead of the mouse to perform
tasks within applications. This list is by no means the "be all and end
all". There are many more Keyboard Shortcuts, which can be found by
looking under HELP and then under Shortcut keys or Keyboard Shortcuts, in
the respective applications.