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 formatting data

To

Press

Display the Style command (Format menu)

ALT-' (APOSTROPHE)

Display the Cells command (Format menu)

CTRL-1

Apply the General number format

CTRL-SHIFT-~

Apply the Currency format with two decimal places (negative numbers appear in parentheses)

CTRL-SHIFT-$

Apply the Percentage format with no decimal places

CTRL-SHIFT-%

Apply the Exponential number format with two decimal places

CTRL-SHIFT-^

Apply the Date format with the day, month, and year

CTRL-SHIFT-#

Apply the Time format with the hour and minute, and indicate A.M. or P.M.

CTRL-SHIFT-@

Apply the Number format with two decimal places, 1000 separator, and – for negative values

CTRL-SHIFT-!

Apply the outline border

CTRL-SHIFT-&

Remove all borders

CTRL-SHIFT-_

Apply/Remove bold formatting

CTRL-B

Apply/Remove italic formatting

CTRL-I

Apply/Remove an underline

CTRL-U

Apply/Remove strikethrough formatting

CTRL-5

Hide rows

CTRL-9

Unhide rows

CTRL-SHIFT-(

Hide columns

CTRL-0 (ZERO)

Unhide columns

CTRL-SHIFT-)

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