Make your own free website on Tripod.com

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

 

Internet Content Rating Association