Short Cut Keys

For those who love the keyboard and hate the tiresome mouse clicks, here are some keystrokes worth remembering. They'll be a great time saver to your work.

A. To Move to...
1. First cell (top left) of working region: Ctrl+Home
2. Last cell (bottom right) of working region: Ctrl+End
3. First cell in a row: Home
4. First occupied cell in a row: Ctrl+LeftArrow
5. Last occupied cell in a row: Ctrl+RightArrow
6. Next worksheet: Ctrl+PageDown
7. Previous worksheet: Ctrl+PageUp

B. To Select...
1. Current region: Ctrl+* (Ctrl+Shift+8)
2. Entire worksheet: Ctrl+A
3. A contiguous block of cells (cells to select are just next to each other)
- Select the first cell of the block
- Hold down the Shift button and select the last cell of the block
4. Non-contiguous block of cells (cells to select may not be next to each other)
- Select any cells of the block
- Hold down the Ctrl button and select the next cell
- Repeat step ii until all cells are selected
5. A contiguous block of worksheets (worksheets to select are just next to each other)
- Select the first worksheet of the block
- Hold down the Shift button and select the last worksheet of the block
6. Non-contiguous block of worksheets (worksheets to select may not be next to each other)
- Select any worksheet of the block
- Hold down the Ctrl button and select the next worksheet
- Repeat step ii until all worksheets are selected

C. Formatting...
1. Cell: Ctrl+1

D. Editing...
1. Undo last action: Ctrl+Z
2. Redo last action: Ctrl+Y
3. Fill a selected group of cells with the same value/formula: Ctrl+Enter
4. Change the same range of cells on different worksheets to the same value/formula:
- Select all the worksheets to edit (see Section B3 to B6)
- Enter the value/formula
- Press Ctrl+Enter

Stay tune for more short cut keys...