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

MORE INFORMATION

The following table lists each command, what it applies to, and the keystroke for the command:

Command	Applies to	US
Delete text to the end of the line	Cells, Text boxes	CONTROL+DELETE
Scroll to display the active cell	Worksheet	CONTROL+DELETE
Move to the last page when zoomed out (in Print Preview)	Print Preview	CONTROL+DOWN ARROW
Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1	Worksheet	CONTROL+END
Maximize or restore the workbook window	Workbook window	CONTROL+F10
Insert a Microsoft Excel 4.0 macro sheet	Worksheet	CONTROL+F11
Open command	Excel	CONTROL+F12
Define a name	Cell, Range, Object	CONTROL+F3
Close the window	Workbook, Window	CONTROL+F4
Restore the window size	Workbook, Window	CONTROL+F5
Move to the next workbook or window	Workbook, Window	CONTROL+F6
Move the window	Workbook, Window	CONTROL+F7
Resize the window	Workbook, Window	CONTROL+F8
Move to the beginning of the worksheet	Worksheet	CONTROL+HOME
Insert cells	Worksheet	CONTROL+I
Delete selected cells	Cell, Range	CONTROL+K
Define name	Worksheet	CONTROL+L
Move to the first page when zoomed out (in Print Preview)	Print Preview	CONTROL+LEFT ARROW
Move to the left between nonadjacent selections	Discontiguous range	CONTROL+OPTION+LEFT ARROW
Start a new line in the same cell	Cell	CONTROL+OPTION+RETURN
Move to the right between nonadjacent selections	Discontiguous range	CONTROL+OPTION+RIGHT ARROW
Switch to the next tab in a dialog box	Dialog boxes	CONTROL+PAGE DOWN
Move to the next sheet in the workbook	Workbook	CONTROL+PAGE DOWN
Move to the new record	Data form	CONTROL+PAGE DOWN
Switch to the previous tab in a dialog box	Dialog boxes	CONTROL+PAGE UP
Move to the previous sheet in the workbook	Workbook	CONTROL+PAGE UP
Move to the first record	Data form	CONTROL+PAGE UP
Fill Right	Range	CONTROL+R
Fill the selected cells with the current entry	Range	CONTROL+RETURN
Move to the last page when zoomed out (in Print Preview)	Print Preview	CONTROL+RIGHT ARROW
Copy the value from the cell above the active cell into the cell or the formula bar	Cell, Formula bar	CONTROL+SHIFT+' (Apostrophe)
Apply the Number format with two decimal places, 1,000 separator, and - for negative values	Cell, Range	CONTROL+SHIFT+!
Apply the Date format with the day, month, and year	Cell, Range	CONTROL+SHIFT+#
Apply the Currency format with two decimal places (negative numbers appear in parentheses)	Cell, Range	CONTROL+SHIFT+$
Apply the Percentage format with no decimal places	Cell, Range	CONTROL+SHIFT+%
Unhide selected rows	Rows	CONTROL+SHIFT+(
Unhide selected columns	Columns	CONTROL+SHIFT+)
Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)	Cell	CONTROL+SHIFT+* (Asterisk)
Enter the time	Cell, Range	CONTROL+SHIFT+: (Colon)
Apply the Time format with the hour and minute, and indicate A.M. or P.M.	Cell, Range	CONTROL+SHIFT+2
Apply the Exponential number format with two decimal places	Cell, Range	CONTROL+SHIFT+^
Select all cells that are directly or indirectly referred to by formulas in the selection	Cell	CONTROL+SHIFT+{
Select cells whose contents are different from the comparison cell in each column (for each column, the comparison cell is in the same row as the active cell)	Range	CONTROL+SHIFT+|
Select all cells with formulas that refer directly or indirectly to the active cell	Worksheet	CONTROL+SHIFT+}
Apply the General number format	Cell, Range	CONTROL+SHIFT+~
Insert blank cells	Worksheet	CONTROL+SHIFT+PLUS SIGN (+)
Insert the argument names and parentheses for a function, after you type a valid function name in a formula	Formula	CONTROL+SHIFT+A
Extend the selection to the last nonblank cell in the same column or row as the active cell	Cell	CONTROL+SHIFT+ARROW KEY
Extend the selection to the last nonblank cell in the same column or row as the active cell	Cell	CONTROL+SHIFT+DOWN ARROW
Extend the selection to the last cell used on the worksheet (lower-right corner)	Cell	CONTROL+SHIFT+END
Print command	Excel	CONTROL+SHIFT+F12
Create names from row and column labels	Workbook	CONTROL+SHIFT+F3
Move to the previous workbook or window	Workbook, Window	CONTROL+SHIFT+F6
Extend the selection to the beginning of the worksheet	Cell	CONTROL+SHIFT+HOME
Extend the selection to the last nonblank cell in the same column or row as the active cell	Cell, Range	CONTROL+SHIFT+LEFT ARROW
Enter a formula as an array formula	Range	CONTROL+SHIFT+RETURN
Extend the selection to the last nonblank cell in the same column or row as the active cell	Cell, Range	CONTROL+SHIFT+RIGHT ARROW
With an object selected, select all objects on a sheet	Object	CONTROL+SHIFT+SPACEBAR
Switch to the previous tab in a dialog box	Dialog boxes	CONTROL+SHIFT+TAB
Move to the previous workbook or window	Workbook, Window	CONTROL+SHIFT+TAB
Extend the selection to the last nonblank cell in the same column or row as the active cell	Cell	CONTROL+SHIFT+UP ARROW
Select the entire column	Cell	CONTROL+SPACEBAR
Switch to the next tab in a dialog box	Dialog boxes	CONTROL+TAB
Move to the next workbook or window	Workbook, Window	CONTROL+TAB
Edit the active cell	Cell	CONTROL+U
Move to the first page when zoomed out (in Print Preview)	Print Preview	CONTROL+UP ARROW
Delete the character to the right of the insertion point, or delete the selection	Cells, Object	DEL
Delete the character to the left of the insertion point, or delete the selection	Cells, Object	DELETE
Clear the contents of the selection	Cells, Object	DELETE

NOTE: Your keyboard may have two DELETE keys. Larger keyboards have a DEL key between the main keyboard and the number pad that clears the selected cells. The DELETE key on the main keyboard only clears the active cell.