Saturday, March 25, 2017

Excel keyboard shortcuts

To do this Press
Close a spreadsheet Ctrl+W
Open a spreadsheet Ctrl+O
Go to the Home tab Alt+H
Save a spreadsheet Ctrl+S
Copy Ctrl+C
Paste Ctrl+V
Undo Ctrl+Z
Remove cell contents Delete key
Choose a fill color Alt+H, H
Cut Ctrl+X
Go to Insert tab Alt+N
Bold Ctrl+B
Center align cell contents Alt+H, A, then C
Go to Page Layout tab Alt+P
Go to Data tab Alt+A
Go to View tab Alt+W
Open context menu Shift+F10, or
 
Context key
Add borders Alt+H, B
Delete column Alt+H,D, then C
Go to Formula tab Alt+M
Hide the selected rows Ctrl+9
Hide the selected columns Ctrl+0