Hermit's Free Library Keyboard Shortcuts
Hermit's Free Library Keyboard Shortcuts
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+ |
= |
