| F1 | Launches Help | | |
| F2 | Edits Current Cell | | |
| F5 | Go to | | |
| F7 | Launches spell check | | |
| F12 | Save file as | | |
| Ctrl + F | Displays the find dialog | | |
| Ctrl + H | Displays the replace dialog | | |
| Ctrl + Y | Redos the last undone action | | |
| Ctrl + 1 | Displays format cells dialog | | |
| Ctrl + ; | Inserts current date | | |
| Home | Goes to beginning of row | | |
| Ctrl + Home | Goes to top of worksheet (A1) | | |
| Ctrl + End | Goes to end of worksheet | | |
| Ctrl + PgDn | Goes to next worksheet | | |
| Ctrl + Spacebar | Selects entire column | | |
| Shift + Spacebar | Selects entire row | | |
| Ctrl + Shift + Leftarrow | Selects all cells to left | | |
| Ctrl + Shift + rightarrow | Selects all cells to right | | |
| Ctrl + ( | Unhides any hidden row | | |
| Ctrl + ) | Unhides any hidden column | | |
| Ctrl + & | Applies outline border to selected cells | | |
| Ctrl + _ | Removes outline border from selected cells | | |
| Ctrl + ~ | Applies the general to format | | |
| Ctrl + $ | Applies the currency format within 2 decimals | | |
| Ctrl + % | Applies the % format with no decimal places | | |
| Ctrl + ^ | Applies exponential no format with 2 decimal places | | |
| Ctrl + # | Applies date format with day, month and year | | |
| Ctrl + @ | Applies time format with hourm minute and AM/PM | | |
| Ctrl + ! | Applies number format with 2 decimal places, thousands seperator & minus sign for negative values | | |
| Ctrl + - | Displays delete dialog box to delete the selected cells | | |
| 0 | Selects current region around the active cells | | |
| Alt + = | Autosums | | |
| Alt + F8 | Macros | | |
| Ctrl + ` | Alternates betn displaying cell values & displaying formulas in worksheet | | |
| Ctrl + ' | Copies formula from cell above active cell into cell or formula bar | | |
| Ctrl + " | Copies value from cell above active cell into cell or formula bar | | |
| Ctrl + + | Displays insert dialog box to insert blank cells | | |
| Ctrl + 1 | Displays format cells dialog box | | |
| Ctrl + 2 | Applies /removes bold formatting | | |
| Ctrl + 3 or Ctrl + 1 | Applies/removes italic formatting | | |
| Ctrl + 4 or Ctrl + U | Applies/removes underlining | | |
| Ctrl + 5 | Applies/removes strikethrough | | |
| Ctrl + 6 | Alternates between hiding objects, displaying obj & displaying placeholders for objects | | |
| Ctrl + 7 | Displays/hides Std toolbar | | |
| Ctrl + 8 | Displays/hides outline symbols | | |
| Ctrl + 9 | Hides selected rows | | |
| Ctrl + 0 | Hides selected columns | | |
| Ctrl + A | Selects entire worksheet | | |
| Ctrl + C & another Ctrl + C | Displays Microsoft office clipboard | | |
| Ctrl + G or F5 | Displays insert hyperlink dialogbox for new hyperlinks | | |
| Ctrl + K | Displays insert hyperlink displays for new hyperlinks | | |
| Ctrl + L | Displays create list dialog box | | |
| Ctrl + Shift + O | Selects all cells that contains comments | | |
| Ctrl + R | Uses fill right command to copy contents & format of left most cell of selected range into cells of right | | |
| Ctrl + N | Creates new blank file | | |
| Ctrl + O | Displays open dialog box to open or find a file | | |
| Ctrl + P | Displays print dialog box | | |
| Ctrl + W | Closes selected workbook window | | |
| Ctrl + Y | Repeats last command | | |
| Ctrl + Z | Uses undo command to reverse last command or to delete last entry | | |
| Ctrl + Shift + Z | Uses undo or rado command to reverse or restore last automatic corection when autocorrect smart tags are displayed | | |
| Ctrl + F1 | Closes & reopens current task pane | | |
| Alt + F1 | Creates a chart of data in current range | | |
| Alt + Shift + F1 | Inserts new work sheet | | |
| Shift + F1 | Edits cell comment | | |
| F3 | Pastes defined name into formula | | |
| Shift + F3 | Displays insert function dialog box | | |
| F4 | Repeats last command | | |
| Ctrl + F4 | Closes selected workbook window | | |
| Ctrl + F5 | Restores window size of selected workbook window | | |
| F6 | Switches to next pane in split worksheet | | |
| Shift + F6 | Switches to previous pane in split worksheet | | |
| Ctrl + F6 | Switches to next workbook window when more than one workbook window are open | | |
| F7 | Displays spelling dialog box | | |
| Ctrl + F7 | Performs move command on workbook window when it is not maximised | | |
| F8 | Turns extend mode on or off | | |
| Shift + F8 | Enables you to add a non adjacent cell to a selection of cells by using arrow keys | | |
| Ctrl + F8 | Performs size command when a workbook window is not maximised | | |
| Alt + F8 | Displays macro dialog box to run, edit or delete macro | | |
| F9 | Calculates all worksheets in all open workbooks F9 followed by enter (or followed by Ctrl + Shift + Enter for array formula) | | |
| Calculates selected portion of formula & replaces the selected portion with calculated value | | |
| Shift + F9 | Calculates active worksheet | | |
| Ctrl + Alt + F9 | Calculates all worksheets in all open workbooks regardless of whether they have changed since the last calculation | | |
| Ctrl + Alt + Shift + F9 | Rechecks dependent formulas & then calculates all cells in all open workbooks, including cells not marked as needing to be calculated | | |
| Ctrl + F9 | Minimises workbook window to an icon | | |
| F10 | Selects menu bar or closes an open menu & submenu at the sametime | | |
| Shift + F10 | Displays shortcut menu for selected item | | |
| Alt + Shift + F10 | Displays menu or message for smart tag. If more than 1 smart tag is present, it switches to next smart tag & displays its message | | |
| Ctrl + F10 | Maximises/restores selected workbook window | | |
| F11 | Creates a chart of data in current range | | |
| Shift + F11 | Inserts a new worksheet | | |
| Alt + F11 | Opens visual basic editor in which you can create a macro by using visual basic for applications | | |
| Alt + Shift + F11 | Opens Microsoft script editor where you can add text, edit HTML tags & modify any script code | | |
| F12 | Displays the save as dialog box | | |
| | | |
| | | |
| | | |
| | | |
