The following table lists each command, what it applies to, and the keystroke for the command:
| Command |
Applies to |
US |
| Start a formula |
Cell, Formula bar |
= (Equal sign) |
| Move one character up, down, left, or right |
Cells, Text boxes |
ARROW KEYS |
| Move between options in the active pop-up menu or between some options in a group of options |
Dialog boxes |
ARROW KEYS |
| Move one cell in a given direction |
Sheets |
ARROW KEYS |
| Move around the page when zoomed in (in Print Preview) |
Print Preview |
ARROW KEYS |
| Calculate all sheets in all open workbooks |
Workbooks |
COMMAND+= (Equal sign) |
| Resize cell and show the formula instead of the resulting value. If the cell does not contain a formula, show the value. |
Options, Display Formula |
COMMAND+~ (Tilde) |
| Display the Cells command (Format menu) |
Workbook |
COMMAND+1 |
| Select the entire worksheet |
Worksheet |
COMMAND+A |
| Apply or remove bold formatting |
Cells, Text Boxes, Chart objects, Chart items |
COMMAND+B |
| Copy the selection |
Cell, Range, Object |
COMMAND+C |
| Move the selected field into the Column area |
PivotTable Wizard - Layout dialog box |
COMMAND+C |
| Move the selected field into the Data area |
PivotTable Wizard - Layout dialog box |
COMMAND+D |
| Align center |
Cells, Text boxes |
COMMAND+E |
| Display the Find command (Edit menu) |
Excel |
COMMAND+F |
| Switch to the next workbook window |
Workbook window |
COMMAND+F6 |
| Display the Replace command (Edit menu) |
Excel |
COMMAND+H |
| Apply or remove italic formatting |
Cells, Text Boxes, Chart objects, Chart items |
COMMAND+I |
| Insert a hyperlink |
Cell |
COMMAND+K |
| Aligns the selection to the left |
Cells, Text boxes |
COMMAND+L |
| Display the PivotTable Field dialog box |
PivotTable Wizard - Layout dialog box |
COMMAND+L |
| Move one word to the left |
Text box |
COMMAND+LEFT ARROW |
| Indent |
Cell, Range |
COMMAND+M |
| Create a new workbook |
Excel |
COMMAND+N |
| Open an existing file |
Excel |
COMMAND+O |
| Remove all borders |
Cell, Range |
COMMAND+OPTION+- (Hyphen) |
| Apply the outline border |
Cell, Range |
COMMAND+OPTION+0 (Zero) |
| Apply/remove the bottom outline border |
Cell, Range |
COMMAND+OPTION+DOWN ARROW |
| Apply/remove the left outline border |
Cell, Range |
COMMAND+OPTION+LEFT ARROW |
| Apply/remove the right outline border |
Cell, Range |
COMMAND+OPTION+RIGHT ARROW |
| Apply/remove the top outline border |
Cell, Range |
COMMAND+OPTION+UP ARROW |
| Display the Print command (File menu) |
Workbook, Help window |
COMMAND+P |
| Move the selected field into the Page area |
PivotTable Wizard - Layout dialog box |
COMMAND+P |
| Quit |
Excel |
COMMAND+Q |
| Aligns the selection to the right |
Cells, Text boxes |
COMMAND+R |
| Move the selected field into the Row area |
PivotTable Wizard - Layout dialog box |
COMMAND+R |
| Move one word to the right |
Text box |
COMMAND+RIGHT ARROW |
| Save |
Workbook |
COMMAND+S |
| Decrease font size |
Workbook |
COMMAND+SHIFT+, |
| Increase font size |
Cells, Text boxes |
COMMAND+SHIFT+. |
| Apply or remove strikethrough formatting |
Cells, Text boxes |
COMMAND+SHIFT+- (Hyphen) |
| Add or remove outline on text |
Cell, Range |
COMMAND+SHIFT+D |
| Switch to the previous workbook window |
Workbook window |
COMMAND+SHIFT+F6 |
| Display the Style command (Format menu) |
Workbook |
COMMAND+SHIFT+L |
| Select or unselect one word to the left |
Cells, Text boxes |
COMMAND+SHIFT+LEFT ARROW |
| Unindent (remove indent) |
Cells, Text boxes |
COMMAND+SHIFT+M |
| Select all cells that contain comments |
Worksheet |
COMMAND+SHIFT+O |
| Select or unselect one word to the right |
Cells, Text boxes |
COMMAND+SHIFT+RIGHT ARROW |
| Insert the AutoSum formula |
Cell, Range |
COMMAND+SHIFT+T |
| Display the Paste Special dialog box after Copy command |
Cell, Range |
COMMAND+SHIFT+V |
| Add or remove shadow on text |
Cell, Range |
COMMAND+SHIFT+W |
| Select only visible cells in the current selection |
Range |
COMMAND+SHIFT+Z |
| Toggle cell reference relative or absolute |
Range |
COMMAND+T |
| Select a Help topic from the topics that are displayed by the Office Assistant |
Assistant Help balloon |
COMMAND+Topic number (where 1 is the first topic, 2 is the second, and so on) |
| Apply or remove underline formatting |
Cells, Text boxes |
COMMAND+U |
| Paste the selection |
Excel |
COMMAND+V |
| Close the active workbook window |
Windows and dialog boxes |
COMMAND+W |
| Cut the selection |
Cell, Range, Object |
COMMAND+X |
| Repeat the last action |
Workbook |
COMMAND+Y |
| Undo the last selection |
Excel |
COMMAND+Z |
| Copy a formula from the cell above the active cell into the cell or the formula bar |
Cell, Formula bar |
CONTROL+' (Apostrophe) |
| Delete the selection |
Cell, Range, Object |
CONTROL+- (Hyphen) |
| Alternate between displaying cell values and displaying cell formulas |
Workbook |
CONTROL+' (Single left quotation mark) |
| Move clockwise to the next corner of the selection |
Range |
CONTROL+. (Period) |
| Select the current array, which is the array that the active cell belongs to |
Array |
CONTROL+/ |
| Enter the date |
Cell, Range |
CONTROL+; (Semicolon) |
| Select only cells that are directly referred to by formulas in the selection |
Cell |
CONTROL+[ |
| 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) |
Cell |
CONTROL+\ |
| Select only cells that contain formulas that refer directly to the active cell |
Worksheet |
CONTROL+] |
| Alternate between displaying cell values and displaying cell formulas |
Workbook |
CONTROL+` (Single left quotation mark) |
| Hide selected columns |
Columns |
CONTROL+0 (Zero) |
| Alternate between hiding objects, displaying objects, and displaying placeholders for objects |
Worksheet |
CONTROL+6 |
| Show or hide the Standard toolbar |
Excel |
CONTROL+7 |
| Display or hide outline symbols |
Outline |
CONTROL+8 |
| Hide selected rows |
Rows |
CONTROL+9 |
| Display the Formula Palette after you type a valid function name in a formula |
Worksheet |
CONTROL+A |
| Move to the edge of the current data region |
Cell, Range |
CONTROL+ARROW KEY |
| Clear the selected cell's contents |
Range |
CONTROL+B |
| Fill Down |
Range |
CONTROL+D |