Navigate cells
- Right .......... Tab
- Start of worksheet .......... Ctrl +
Home
- End of worksheet .......... Ctrl +
End
- Start of row .......... Home
- Up/ down 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
- Entire Column .......... Ctrl +
space
- Entire Row .......... Shift +
space
- Entire worksheet .......... Ctrl +
A
Work in a range
- Select the 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 the worksheet from
range selector in dialog box....F6
Edit worksheet
- Edit a 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 + _
|
