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 moving and scrolling on a worksheet

To

Press

Move one cell in a given direction

Arrow key

Move to the edge of the current data region

CTRL- Arrow key

Move between unlocked cells on a protected worksheet

TAB

Move to the beginning of the row

HOME

Move to the beginning of the worksheet

CTRL-HOME

Move to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is usually A1

CTRL-END

Move down one screen

PAGE DOWN

Move up one screen

PAGE UP

Move one screen to the right

ALT-PAGE DOWN

Move one screen to the left

ALT-PAGE UP

Go to a specific cell CTRL-G
Find a cell entry CTRL-F
Repeat the last find SHIFT-F4

Scroll to display the active cell

CTRL-BACKSPACE

 

In End mode, to

Press

Turn End mode on or off

END

Move by one block of data within a row or column

END, Arrow key

Move to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1

END, HOME

Move to the last cell to the right in the current row that is not blank (unavailable if you have selected the Transition navigation keys check box on the Transition tab [Tools menu, Options command])

END, ENTER

 

With SCROLL LOCK turned on, to

Press

Turn SCROLL LOCK on or off

SCROLL LOCK

Move to the cell in the upper-left corner of the window

HOME

Move to the cell in the lower-right corner of the window

END

Scroll one row up or down

UP ARROW or DOWN ARROW

Scroll one column left or right

LEFT ARROW or RIGHT ARROW

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