|
1st key |
2nd 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 |
