Appendix C – Keyboard Commands – Intermediate Excel 2016

Appendix C

Keyboard Commands

Workbook Specifications and Limits

General Commands Keys
Open Workbook Ctrl + O
Create a New Workbook Ctrl + N
Save a Workbook Ctrl + S
Preview and Print Ctrl + P
Close a Workbook Ctrl + W
Help F1
Spelling Check F7
Calculate Worksheet F9
Create absolute, normal, mixed reference F4
Editing Commands Keys
Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + V
Undo Ctrl + Z
Redo Ctrl + Y
Find Ctrl + F
Replace Ctrl + H
Select All Ctrl + A
Edit the Active Cell F2
Clear Active Cell Contents Delete
Formatting Commands Keys
Bold Ctrl + B
Underline Ctrl + U
Italic Ctrl + I
Open Format Cells Ctrl + Shift + F