Excel has a lot of useful shortcut keys. The more you know, the more time you can save. Here are eight shortcuts we hope you find useful:

1. To enter the current date into the active cell, press [Ctrl][;].

2. To enter the current time, press [Ctrl][Shift][;]. 

3. To enter or edit a cell comment in the active cell, press [Shift][F2].

4. To quickly copy the contents of a cell to the cell directly to the right, select the cell that will receive the copy, then press [Ctrl]R.

5. To quickly copy the contents of a cell to a cell directly below it, select the cell that will receive the copy, then press [Ctrl]D.

6. To copy the contents from a cell directly above the active cell, press [Ctrl][']. If the cell contains a formula, this shortcut makesan identical copy of that formula, rather than adjusting the cell reference relatively.

7. Pressing [Ctrl][Shift]['] also copies the contents from the cell directly above the active cell. However, if the cell contains a formula, this shortcut copies the result of the formula only rather than the formula itself. An easy way to view all formulas in a worksheet without having to select the cell containing it is to press 

8. [Ctrl][~]. Press the shortcut again to switch back to the Normal view. 

Office 97 Index

Main Index