Important Shortcut keys of Excel

General
Create new workbook       – Ctrl+N
Open existing workbook – Ctrl+O
Save Workbook              – Ctrl+S
Close Excel                  – Alt+F4 (or) Ctrl+F4
Move to the next sheet – Ctrl+PageDown
Move to the previous sheet – Ctrl + PageUp
goto Data Tab               – Alt+A
goto View Tab            – Alt + W
goto Formula Tab       – Alt +M

 

Formatting related
Edit Cell                         – F2
Copy and Paste cells – Ctrl+C then Ctrl+V
Bold                              – Ctrl+B
Italicize font                 – Ctrl+I
Center Align cell content – Alt+H+A+C
Fill Color                      – Alt+H+H
Add border                       – Alt+H+B
Remove outline border  – Ctrl+Shift+ _
Add outline to selected cells – Ctrl+Shift+&
move to next cell              – Tab
move to previous cell   – Shift+Tab
Select all cells to the right  – Ctrl+Shift+Right Arrow
Select all cells to the left  – Ctrl+Shift+Left

You cannot copy content of this page