Function
|
Key
|
---|---|
Open | [Ctrl] + [O] |
Exit | [Alt] + [F4] |
Move to the beginning of the worksheet | [Ctrl] + [Home] |
Move to next sheet | [Ctrl] + [Page Down] |
Move to previous sheet | [Ctrl] + [Page Up] |
Convert to a percentage | [Ctrl] + [Shift] + [%] |
Apply outline to active cell | [Ctrl] + [Shift] + [&] |
Applies the Date format. | [Ctrl]+[Shift]+[#] |
Formats the current cells as Currency. | [Ctrl]+[Shift]+[$] |
Applies the General format. | [Ctrl]+[Shift]+[~] |
Edit the active cell | [F2] |
Paste a name into a formula | [F3] |
Repeat the last action | [F4] |
Display the Go To dialog box | [F5] |
Moves to the next pane in a split worksheet. | [F6] |
Check spelling of current cell | [F7] |
Calculate all sheets in all open workbooks | [F9] |
Activate the menu bar | [F10] |
Create a chart | [F11] |
Complete a cell entry and move right | [Tab] |
Display the Macro dialog box | [Alt] + [F8] |
Move one screen right | [Alt] + [Page down] |
Move one screen left | [Alt] + [Page Up] |
Insert a new sheet | [Alt] + [Shift] + [F1] |
Inserts the AutoSum function. | [Alt]+[=] |
Opens the VBA Editor or switches to it if it’s already open. | [Alt]+[F11] |
Alternate value/formula view | [Ctrl] + [`] |
Display the Format Cells dialog box | [Ctrl] + [1] |
Press once to position cursor to extreme right of the worksheet. | [Ctrl] + [Right Arrow] |
Press once to position cursor to extreme down of the worksheet. | [Ctrl] + [Down Arrow] |
Move to the last cell on the worksheet | [Ctrl] + [End] |
Select all filled cells around active cell | [Ctrl] + [Shift] + [*] |
Select the current column | [Ctrl] + [Space] |
Inserts the current date. | [Ctrl]+[;] |
Opens the Define Name dialog box. | [Ctrl]+[F3] |
Moves to the next workbook window. | [Ctrl]+[F6] |
Automatically creates Named Ranges from the headers for the selected table of data | [Ctrl]+[Shift]+[F3] |
Moves back to the last workbook window. | [Ctrl]+[Shift]+[F6] |
Move one screen down | [Page down] |
Move one screen up | [Page Up] |
Complete a cell entry and move up | [Shift] + [Enter] |
Edit a cell comment | [Shift] + [F2] |
Repeat Find | [Shift] + [F4] |
Display the Find dialog box | [Shift] + [F5] |
Select the current row | [Shift] + [Space] |
Complete a cell entry and move left | [Shift] + [Tab] |
Displays the shortcut menu that applies to where the cursor is located. | [Shift]+[F10] |
Inserts an equal sign (=) and opens the Paste Function dialog box to help you pick a formula. | [Shift]+[F3] |
Moves to the previous pane. | [Shift]+[F6] |