Excel 2003 Shortcut Keys
[Keys for General Use]
[Keys for Moving and Scrolling on Worksheets] [Keys for
Moving between Worksheet Panes, Worksheets, and
Workbooks] [Keys for Entering Data] [Keys for
Selecting Data
and Cells] [Keys for Editing Data] [Keys for
Formatting Data] [Keys for Printing and Previewing Spreadsheet
Files]
[Keys for Working with Names] [Keys for
Working with Databases and Lists] [Keys for Outlining Data]
[Keys for Working with Charts] [Keys
for Working with PivotTables and PivotCharts] [Keys for
Working with Objects]
Keys for General Use
All shortcut keys are based on the U.S. keyboard layout. Keys on other layouts may not correspond exactly to the keys on a U.S. keyboard.
For keyboard shortcuts in which you press two or more keys together, the keys to press are separated by a plus sign,
like this: SHIFT+F10.
For shortcuts in which you press keys one after the other, the keys to press are separated by a comma,
like this: ALT, F, X.
Working with Spreadsheet Files
To perform this action... |
Press... |
To create a new spreadsheet file |
CTRL+N |
To open a spreadsheet file |
CTRL+O |
To close a spreadsheet file |
CTRL+W |
To save a spreadsheet file |
CTRL+S |
To quit Excel |
ALT+F4 |
Working with Workbook Windows
To perform this action... |
Press... |
To close the selected workbook window |
CTRL+F4 or CTRL+W |
To restore the window size of the selected workbook window |
CTRL+F5
|
To switch to the next pane in a worksheet
that has been split (by using the Split command on the Window menu) |
F6
|
To switch to the
previous pane in a worksheet that has been split |
SHIFT+F6
|
To switch to the
next workbook window when more than one workbook window is open |
CTRL+F6
|
To switch to the
previous workbook window |
CTRL+SHIFT+F6
|
To minimize a
workbook window to an icon |
CTRL+F9
|
To maximize or
restore the selected workbook window |
CTRL+F10
|
Working with Menus and Toolbars
To perform this
action... |
Press... |
To show or hide the
Standard toolbar |
CTRL+7
|
Working with Worksheets
To perform this
action... |
Press... |
To insert a new
worksheet |
SHIFT+F11 or ALT+SHIFT+F1 |
To move to the next
worksheet in the workbook |
CTRL+PAGE DOWN
|
To move to the
previous worksheet in the workbook |
CTRL+PAGE UP
|
To select the
current and next worksheet |
SHIFT+CTRL+PAGE
DOWN (To
cancel selection of multiple sheets, press CTRL+PAGE DOWN; or to
select a different sheet, press CTRL+PAGE UP) |
To select the current and previous worksheet |
SHIFT+CTRL+PAGE UP |
To rename the current worksheet |
ALT+O, H, R (Format menu, Sheet submenu,
Rename command) |
To move or copy the current worksheet |
ALT+E, M (Edit menu,
Move or Copy Sheet command) |
To delete the current worksheet |
ALT+E, L
(Edit menu, Delete Sheet command) |
To alternate between displaying cell values and displaying cell formulas |
CTRL+` (SINGLE LEFT QUOTATION MARK) |
To calculate the active worksheet |
SHIFT+F9 |
To calculate all sheets in all open workbooks |
F9 |
Working with Speech, E-Mail, Macros, and Other Languages
Using Speech Recognition and Text-to-Speech
To perform this action... |
Press... |
To switch between command mode and dictation mode |
CTRL
|
To stop reading when text is being read aloud |
ESC
|
Sending E-Mail Messages
To perform this action... |
Press... |
With cell A1 selected, to move to the Introduction box in the e-mail message
header |
SHIFT+TAB (In the message header, moves to
the Subject, Bcc (if displayed), Cc, To, and From (if displayed)
boxes, then to the address book for the Bcc, Cc, To, and From boxes,
and then to cell A1.) |
To send the e-mail message |
ALT+S |
To open the
Address Book |
CTRL+SHIFT+B
|
To open the
Options menu for access to the Options, Bcc Field, and From Field
commands |
ALT+O
|
To open the
Outlook Message Options dialog box (Options menu, Options command)
|
ALT+P
|
To check the
names in the To, Cc, and Bcc boxes against the Address Book
|
ALT+K
|
To open the
Address Book for the To box |
ALT+PERIOD
|
To open the
Address Book for the Cc box |
ALT+C
|
To open the
Address Book for the Bcc box if the Bcc box is displayed |
ALT+B
|
To go to the
Subject box |
ALT+J
|
To create a
message flag |
CTRL+SHIFT+G
|
To add
interactivity to the range or sheet being sent |
ALT+A
|
Note: To use keys to send e-mail messages, you must configure Microsoft Outlook as your default e-mail
program. Most of the keystrokes above do not work with Outlook Express.
Working with Macros
To perform this action... |
Press... |
To display the
Macro dialog box |
ALT+F8
|
To display the
Visual Basic Editor |
ALT+F11
|
To insert a
Microsoft Excel 4.0 macro sheet |
CTRL+F11
|
Working with Multiple National Languages
To perform
this action... |
Press... |
To switch to
right-to-left paragraph direction (the text must contain only
neutral characters) |
CTRL+RIGHT
SHIFT |
To switch to
left-to-right paragraph direction (the text must contain only
neutral characters) |
CTRL+LEFT
SHIFT |
To move the
pointer into the phonetic guides in Japanese text for which you've
displayed phonetic guides |
ALT+SHIFT+UP
ARROW |
To move the
pointer from the phonetic guides back to the parent string of
characters |
ALT+SHIFT+DOWN ARROW |
To enter a
unicode character |
NUM LOCK,
ALT+numeric pad numbers |
To convert the
hexadecimal code for a unicode character to the character, or to
convert a unicode character to its hexadecimal code |
ALT+X
(Press immediately after typing the hexadecimal code or the unicode
character) |
Miscellaneous
To perform this action... |
Press... |
To cancel an action |
ESC |
To undo an action |
CTRL+Z |
To redo an action |
F4 or CTRL+Y |
Go Back to the Top of the Page
|