Download Excel Sheet

and 

Apply following Shortcuts

 Lets study these one by one

Shortcut  Description
Ctrl B Bold
Ctrl U Underline
Ctrl I Italics
Ctrl Z Undo
Ctrl Y Redo
Ctrl C Copy
Ctrl V Paste
Ctrl X Cut
Ctrl Alt V Paste Special
Ctrl F Find
Ctrl H Replace
F2 To edit or see formula
F4 Repeat Last Action
Ctrl Page Up Go To Previous Sheet
Ctrl Page Down Go To Next Sheet
Shift F11 Insert new sheet
Ctrl [ To Go To A Link
Ctrl ] To Go Back To A Link Same Sheet
Ctrl g+enter To Go Back To A Link Different Sheet
Ctrl D Drag Down Without Copy
Ctrl A All
Ctrl N New File
Ctrl O Open
Ctrl Space Select Column
Ctrl Space+ Ctrl Shift +  Insert Column
Shift Space Select Row
Shift Space+ Ctrl Shift ++  Insert Row
Ctrl Space+ Ctrl - Delete Column
Shift Space+ Ctrl - Delete Row
Ctrl ; Insert Current Time
Ctrl :  Insert Current Date
Alt Tab Toggle between files
Windows D Maximize Minimize
Hide Row Select row -> Ctrl 9
Hide Column Select Column -> Ctrl 0
Unhide Row Select row -> Ctrl + Shift + 9
Unhide Column Select Column -> Ctrl + Shift + 0

 

Download Excel shortcuts PDF

 
Go Ad-free
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 14 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.