Ian's Messy Desk : Ian's Messy Desk

Tuesday, November 05, 2002

A comprehensive list of Microsoft Excel shortcut keys
Keys for moving and scrolling in a worksheet or workbook:

Arrow keys: Move one cell up, down, left, or right
CTRL+arrow: key Move to the edge of the current data region
HOME: Move to the beginning of the row
CTRL+HOME: Move to the beginning of the worksheet
CTRL+END: Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
PAGE DOWN: Move down one screen
PAGE UP: Move up one screen
ALT+PAGE DOWN: Move one screen to the right
ALT+PAGE UP: Move one screen to the left
CTRL+PAGE DOWN: Move to the next sheet in the workbook
CTRL+PAGE UP: Move to the previous sheet in the workbook
CTRL+F6 or CTRL+TAB: Move to the next workbook or window
CTRL+SHIFT+F6 or CTRL+SHIFT+TAB: Move to the previous workbook or window
F6: Move to the next pane in a workbook that has been split
SHIFT+F6: Move to the previous pane in a workbook that has been split
CTRL+BACKSPACE: Scroll to display the active cell
F5: Display the Go To dialog box
SHIFT+F5: Display the Find dialog box
SHIFT+F4: Repeat the last Find action (same as Find Next)
TAB: Move between unlocked cells on a protected worksheet [OzGrid.com]

5:56:14 PM # Speak Up [] - See Also: Computer Tips

Quote
Nikita Khrushchev. "Politicians are the same all over. They promise to build a bridge even where there is no river." [Quotes of the Day]
7:22:18 AM # Speak Up []

WOTD
clarion Dictionary.com Word of the Day: clarion [Dictionary.com Word of the Day]
7:21:05 AM # Speak Up []

In Basket