Keyboard Shortcuts for Moving within an Excel 2003 Worksheet

You’re moving cell-by-cell through an Excel 2003 worksheet, thinking "I wish there was a shortcut." Your wish is granted! Excel 2003 keyboard shortcuts make quick work of your spreadsheet.



















































PressTo
An arrow keyMove cell pointer one cell in direction of arrow key
Ctrl+arrow keyMove to the edge of the current data region (data range bounded
by empty cells or worksheet borders) in the direction of arrow
key
HomeMove to the beginning of current row
Ctrl+HomeMove to cell pointer to first cell (A1)
Ctrl+End-Move cell pointer to last cell in the active area (cell in
last occupied column and row)
Page DownMove cell pointer down one screen
Page UpMove cell pointer up one screen
Alt+Page DownMove cell pointer one screen to the right
Alt+Page UpMove cell pointer one screen to the left
TabMove the cell pointer to next unlocked cell in a protected
worksheet
Shift+TabMove the cell pointer to previous unlocked cell in a protected
worksheet



dummies

Source:http://www.dummies.com/how-to/content/keyboard-shortcuts-for-moving-within-an-excel-2003.html

No comments:

Post a Comment