Excel
Organize, manipulate, and analyze data
Frequently used shortcuts:
Save a file
Ctrl
S
Save as
F12
Go to Home tab
Alt
H
Copy
Ctrl
C
Paste
Ctrl
V
Undo
Ctrl
Z
Find
Ctrl
F
Remove cell content
Delete
Choose a fill colour
Ctrl
H
Cut selection
Ctrl
X
Go to Insert tab
Alt
N
Bold
Ctrl
B
Italics
Ctrl
I
Underline
Ctrl
U
Center alignment
Alt
H
Go to Page Layout tab
Alt
P
Go to Data tab
Alt
A
Go to View tab
Alt
W
Add borders
Alt
H
Delete column
Alt
H
Go to Formula tab
Alt
M
Hide rows
Ctrl
9
Hide columns
Ctrl
0
Insert sheet
Shift
F11
Delete sheet
Alt
E
L
Navigation:
Move cell up / down
↑
Move to the right cell
Tab
Move cell to the left
Shift
Tab
Move to beginning of a row
Home
Move to beginning of worksheet
Ctrl
Home
Move to last cell with content
Ctrl
End
Move to the left most cell
Ctrl
←
Move to the right most cell
Ctrl
→
Toggle worksheet, ribbon bar and zoom controls
F6
Switch to next worksheet
Ctrl
F6
Move screen up
PageUp
Move screen down
PageDown
Move screen left
Alt
PageUp
Move screen right
Alt
PageDown
Move worksheet tab to left
Ctrl
PageUp
Move worksheet tab to right
Ctrl
PageDown
Cell formatting:
Apply border
Ctrl
Shift
&
Format cells dialog box
Ctrl
1
Remove border
Ctrl
Shift
_
Currency format
Ctrl
Shift
$
Number format
Ctrl
Shift
~
Date format
Ctrl
Shift
#
Time format
Ctrl
Shift
@
Insert hyperlink
Ctrl
K
Strikethrough
Ctrl
5
Increase font size
Alt
H
+
F
+
G
Decrease font size
Alt
H
+
F
+
K
Format painter
Ctrl
Alt
V
Selections:
Select row
Shift
⎵
Select column
Ctrl
⎵
Select worksheet
Ctrl
A
Select adjacent cells
Shift
MouseLeft
Cancel selection
Esc
Extend selection to right
Shift
→
Extend selection to left
Shift
←
Extend selection to down
Shift
↓
Extend selection to top
Shift
PageDown
Extend selection to left screen
Alt
Shift
PageDown
Extend selection to right screen
Alt
Shift
PageUp
Extend selection to bottom
Shift
PageUp
Select cells to the left
Ctrl
Shift
Home
Select cells to the right
Ctrl
Shift
End
Workbook:
Close workbook
Ctrl
W
Open workbook
Ctrl
O
Create new workbook
Ctrl
N
Next workbook
Ctrl
Tab
Previous workbook
Ctrl
Shift
Tab
Minimise workbook
Ctrl
F9
Maximise workbook
Ctrl
F10
Insert new worksheet
Shift
F11
Next Pane
F6
Previous Pane
Shift
F6
Switch Tabs
Ctrl
PageUp
Pivot table:
Open pivot table wizard
Alt
D
P
Create pivot chart
Alt
F1
Create pivot chart on new worksheet
F11
Hide pivot table item
Ctrl
-
Group pivot table items
Alt
Shift
→
Ungroup pivot table items
Alt
Shift
←
Select pivote table
Ctrl
A
Mouse shortcuts:
Drag and copy
Ctrl
MouseLeft
Drag and cut
MouseLeft
Drag and insert
Shift
MouseLeft
Drag to worksheet
Alt
MouseLeft
Drag to duplicate worksheet
Ctrl
MouseLeft
Zoom in
Ctrl
Alt
+
Zoom out
Ctrl
Alt
-