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

To

Press

Start a formula

= (EQUAL SIGN)

Insert the AutoSum formula

ALT-= (EQUAL SIGN)

Display the Formula Palette (after you type a valid function name in a formula)

CTRL-A

Insert the argument names and parentheses for a function (after you type a valid function name in a formula)

CTRL-SHIFT-A

Paste a name into a formula

F3

Insert the current date

CTRL-; (SEMICOLON)

Insert the current time

CTRL-SHIFT-: (COLON)

Insert a hyperlink

CTRL-K

Copy a formula from the cell above the active cell into the cell or the formula bar

CTRL-' (APOSTROPHE)

Copy the value from the cell above the active cell into the cell or the formula bar

CTRL-SHIFT-" (QUOTATION MARK)

Display the AutoComplete list

ALT-DOWN ARROW

Start a new line in the same cell

ALT-ENTER

Delete the character to the left of the insertion point, or delete the selection

BACKSPACE

Complete a cell entry

ENTER

Cancel a cell entry

ESC

Enter a formula as an array formula

CTRL-SHIFT-ENTER

Complete a cell entry and move down in a selected range of cells

ENTER

Complete a cell entry and move up in a selected range of cells

SHIFT-ENTER

Complete a cell entry and move to the right in a selected range of cells

TAB

Complete a cell entry and move to the left in a selected range of cells

SHIFT-TAB

Complete a cell entry and move up, down, left, or right

UP, DOWN, LEFT, OR RIGHT ARROW

Fill down (in a selected range of cells)

CTRL-D

Fill to the right (in a selected range of cells)

CTRL-R

Fill the selected cell range with the current entry

CTRL-ENTER

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