XL2001: Shortcut Keys Available in Excel 2001 for Mac (Part 1)

This is article 1 of 3 that lists the shortcut or keyboard commands for Excel 2001 for Mac.

For the additional shortcut keys, click the article numbers below to view the articles in the Microsoft Knowledge Base:

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