|
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 |
|
Copy |
CTRL+C |
|
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
today's 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 |
|
Open |
CTRL+O |
|
Paste |
CTRL+V |
|
Paste
a function into a formula |
SHIFT+F3 |
|
Print |
CTRL+P |
|
Save |
CTRL+S |
|
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 |
|
Undo |
CTRL+Z |
|
When
you enter a formula, display the Formula Palette
after you type a function name |
CTRL+A |
Awasome
ReplyDelete