Navigate cells
- Right..........Tab
- Start of worksheet..........Ctrl +
Home
- End of worksheet ..........Ctrl +
End
- Start of row..........Home
- Up/down one screen..........Page Up/ Down
Standard actions
- Activate menus..........F10
- Save..........Ctrl + S
- Print..........Ctrl + P
- New workbook..........Ctrl +
N
- Open..........Ctrl + O
- Copy..........Ctrl + C
- Cut..........Ctrl + X
- Paste..........Enter
Copy data
- Fill down..........Ctrl + D
- Fill right..........Ctrl + R
- Copy formula above..........Ctrl +
'
- Copy value above..........Ctrl +
"
Format Numbers
- General..........Ctrl + Shift
+ ~
- Currency..........Ctrl + Shift
+ $
- Percentage..........Ctrl + Shift
+ %
- Date (d, m, y)..........Ctrl +
Shift + #
|
|
Select
- Column..........Ctrl + space
- Row..........Shift + space
- Entire worksheet..........Ctrl +
A
Work in a range
- Select current range..........Ctrl +
*
- Move to range border..........Ctrl +
arrow
- Move down..........Enter
- Move up..........Shift + Enter
- Move right..........Tab
- Move left..........Shift + Tab
- Switch focus to worksheet from
range selector in dialog box....F6
Edit worksheet
- Edit cell..........F2
- Insert..........Ctrl + +
- Delete..........Ctrl +
-
Complete actions
- Repeat last action..........F4
- Today’s date..........Ctrl + ;
- Chart selected data..........F11
Apply Formatting
- Format cells..........Ctrl +
1
- Remove borders..........Ctrl + Shift + _
|
