| Select cells | |
|---|---|
Ctrl + Space bar |
Select column |
Shift + Space bar |
Select row |
Ctrl + A |
Select range (once) |
| Select all cells (twice) | |
Ctrl + Arrow button |
Select cell at the end |
Ctrl + Shift + Arrow button |
Select a cell in the direction |
| Auto Fill | |
|---|---|
Ctrl + R |
Auto Fill to the right |
Ctrl + D |
Auto Fill down |
| Rows and columns | |
|---|---|
Ctrl + + |
Insert row/column |
Ctrl + - |
Remove row/column |
Ctrl + 0 |
Hide columns |
Ctrl + 9 |
Hide rows |
| Date and time | |
|---|---|
Ctrl + Shift + , |
Current date |
Ctrl + Shift + . |
Current time |
| Save | |
|---|---|
Ctrl + S |
Save |
F12 |
Save as |
| Other | |
|---|---|
F4 |
Repeat last formatting action |
F4, if in function input box |
$-Options (press several times) |
Ctrl + 1 |
Format cells |
Ctrl + F3 |
Name Manager |