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

To

Press

Edit the active cell

F2

Accept edits

ENTER

Cancel edits

ESC

Navigating a cell entry

To

Press

Move one character up, down, left, or right

UP, DOWN, LEFT, OR RIGHT ARROW

Move to the beginning of the line

HOME

Move to the end of the line END

Move to the beginning of the entry

CTRL-HOME

Move to the end of the entry CTRL-END
Move one group of characters to the left or right CTRL-LEFT OR RIGHT ARROW

Editing cell entries

To

Press

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

BACKSPACE

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

DELETE

Delete text to the end of the line

CTRL-DELETE

Paste a name into a formula

F3

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

CTRL-SHIFT-A

Inserting, deleting, cutting, or copying a selection

To

Press

Cut the selection

CTRL-X

Copy the selection

CTRL-C

Paste the selection

CTRL-V

Clear the contents of the selection

DELETE

Insert blank cells

CTRL-SHIFT-+ (PLUS SIGN)

Delete selected cells

CTRL-

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