Excel Shortcut Keys: Working with Spreadsheet Files

Excel 97/2000 Shortcut Keys

[Keys for working with spreadsheet files] [Keys for moving and scrolling on a worksheet] [Keys for moving between worksheet panes, worksheets, and workbooks] [Keys for entering data] [Keys for formatting data] [Keys for editing data] [Keys for selecting data, cells, chart items, or objects] [Keys for printing and previewing a spreadsheet file] [Keys for working with names] [Keys for working with databases, lists, and PivotTables] [Keys for outlining data]

Keys for working with spreadsheet files

To	Press
Create a new spreadsheet file	CTRL-N
Open a spreadsheet file	CTRL-O
Close a spreadsheet file	CTRL-W
Save a spreadsheet file	CTRL-S
Quit Excel	ALT-F4

To	Press
Cancel an action	ESC
Undo an action	CTRL-Z
Redo an action	F4 or CTRL-Y

To	Press
Alternate between displaying cell values and displaying cell formulas	CTRL-` (SINGLE LEFT QUOTATION MARK)
Calculate the active worksheet	SHIFT-F9
Calculate all sheets in all open workbooks	F9

Go Back to the Top of the Page

Send mail with questions or comments about this web site to our webmaster.
Last modified: April 04, 2004

This site was created and is managed with Microsoft FrontPage