| Alternate between displaying cell values and displaying cell formulas |
CTRL + ` (single left quotation mark) |
| Calculate all sheets in all open workbooks |
F9 |
| Calculate the active worksheet |
SHIFT + F9 |
| Create a chart that uses the current range |
F11 or ALT + F1 |
| Display the Format Cells dialog box |
CTRL+1 |
| Display the Go To dialog box |
F5 |
| Fill the selected cell range with the current entry |
CTRL + ENTER |
| Insert the current time |
CTRL + : |
| Insert the todays date |
CTRL + ; |
| Move to the beginning of the worksheet |
CTRL + HOME |
| Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottommost used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1 |
CTRL + END |
| Copy |
CTRL + C |
| Cut |
CTRL + X |
| Paste |
CTRL + V |
| Paste a Function into a formula |
SHIFT + F3 |
| Paste |
CTRL + V |
| Print |
CTRL + P |
| Save |
CTRL + S |
| Undo |
CTRL + Z |
| Select all (when you are not entering or editing a formula) |
CTRL + A |
| Select the current column |
CTRL + SPACEBAR |
| Select the current row |
SHIFT + SPACEBAR |