|
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] |
