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.
Press | To |
---|---|
An arrow key | Move cell pointer one cell in direction of arrow key |
Ctrl+arrow key | Move to the edge of the current data region (data range bounded by empty cells or worksheet borders) in the direction of arrow key |
Home | Move to the beginning of current row |
Ctrl+Home | Move 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 Down | Move cell pointer down one screen |
Page Up | Move cell pointer up one screen |
Alt+Page Down | Move cell pointer one screen to the right |
Alt+Page Up | Move cell pointer one screen to the left |
Tab | Move the cell pointer to next unlocked cell in a protected worksheet |
Shift+Tab | Move 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