MS-Excel specialized keyboard shortcuts.
Action | Modifiers | Key |
Go to cell A1 |
Ctrl+ |
Home |
Go to last cell in worksheet |
Ctrl+ |
End |
Go to column A, current row |
|
Home |
Next worksheet |
Ctrl+ |
PgDn |
Previous worksheet |
Ctrl+ |
PgUp |
Display Help |
|
F1 |
Create default chart |
[Select data to chart] |
F11 |
Move down one screenful |
|
PgDn |
Move up one screenful |
|
PgUp |
Find dialogue box |
Ctrl+ |
F |
Goto |
|
F5 |
Select all, current page |
Ctrl+ |
A |
Select current and next worksheet |
Shift+Ctrl+ |
PgDn |
Select current and previous worksheet |
Shift+Ctrl+ |
PgUp |
Open the Format Cells dialogue box |
Ctrl+ |
1 |
Format as number |
Ctrl+Shift+ |
! |
Format as currency |
Ctrl+Shift+ |
$ |
Format as date |
Ctrl+Shift+ |
# |
Format as percentage |
Ctrl+Shift+ |
% |
Autosum a range of cells |
Alt+ |
= |