Excel 2000 in a Nutshell

Appendix A. Keyboard Shortcuts

Although Excel provides an enormous number of menu and toolbar commands, sometimes it is easier to perform some commands using the keyboard shortcuts that are included with Excel.

Note

The keyboard shortcuts covered in this appendix do not cover the commands added when you select Tools → Options → Transition → Navigation Keys to emulate Lotus 1-2-3 commands.

The following tables list the keyboard shortcuts available within Excel. To make the commands easier to locate, they are grouped together by functionality; such as navigating the worksheet or formatting selected range.

Table A-1. General Program Shortcuts

Shortcut	Command
Ctrl-N	Create a new workbook.
Ctrl-O or Ctrl-F12	Open a workbook.
Ctrl-S or Shift-F12	Save a workbook (the Save As dialog opens if the workbook has not been previously saved).
F12	Open the Save As dialog to specify the name and location of the workbook.
Ctrl-W or Alt-F4	Close the active workbook. If it is the only workbook open, it also closes Excel.
F1	Open Help or Office Assistant.
Shift-F1	Display the What’s This? Question mark.
F7	Run the Spelling checker.
F10	Activate the Menu bar (use arrow keys to move along menu).
Shift-F10	Open a context menu.
F9	Calculate all worksheets in all open workbooks.
Ctrl + F9	Calculate the active worksheet.
Ctrl + F9	Minimize the workbook.
Ctrl + F10	Restore or maximize the workbook.
Ctrl P or Ctrl + Shift + F12	Open the Print dialog.

Table A-2. Worksheet Navigation ...