| 1st key |
2nd key |
3rd key |
|
What it does |
| CTRL |
DELETE |
|
|
Delete to end of line |
| CTRL |
Spacebar |
|
|
Selects the current column |
| Shift |
Spacebar |
|
|
Selects the current row |
| ALT |
F1 |
|
|
Create a chart that uses the current range |
| CTRL |
: |
|
|
Insert the current time |
| CTRL |
; |
|
|
Insert today's date |
| CTRL |
` |
|
|
(single left quotation mark) Alternate between displaying cell values and displaying cell formulas |
| CTRL |
1 |
|
|
Display the Format Cells dialog box |
| CTRL |
A |
|
|
Select all (when you are not entering or editing a formula) |
| CTRL |
A |
|
|
When you enter a formula, display the Formula Palette after you type a function name |
| CTRL |
C |
|
|
Copy |
| CTRL |
END |
|
|
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 |
ENTER |
|
|
Fill the selected cell range with the current entry |
| CTRL |
HOME |
|
|
Move to the beginning of the worksheet |
| CTRL |
O |
|
|
Open |
| CTRL |
P |
|
|
Print |
| CTRL |
S |
|
|
Save |
| CTRL |
Spacebar |
|
|
Select the current column |
| CTRL |
V |
|
|
Paste |
| CTRL |
Z |
|
|
Undo |
| F11 |
|
|
|
Create a chart that uses the current range |
| F5 |
|
|
|
Display the Go To dialog box |
| F9 |
|
|
|
Calculate all sheets in all open workbooks |
| SHIFT |
F3 |
|
|
Paste a function into a formula |
| SHIFT |
F9 |
|
|
Calculate the active worksheet |
| SHIFT |
Spacebar |
|
|
Select the current row |
