<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=539359806247306&ev=PageView&noscript=1"/>

Download Excel Sheet

and 

Apply following Shortcuts

 Lets study these one by one

Shortcut Description
Ctrl BBold
Ctrl UUnderline
Ctrl IItalics
Ctrl ZUndo
Ctrl YRedo
Ctrl CCopy
Ctrl VPaste
Ctrl XCut
Ctrl Alt VPaste Special
Ctrl FFind
Ctrl HReplace
F2To edit or see formula
F4Repeat Last Action
Ctrl Page UpGo To Previous Sheet
Ctrl Page DownGo To Next Sheet
Shift F11Insert new sheet
Ctrl [To Go To A Link
Ctrl ]To Go Back To A Link Same Sheet
Ctrl g+enterTo Go Back To A Link Different Sheet
Ctrl DDrag Down Without Copy
Ctrl AAll
Ctrl NNew File
Ctrl OOpen
Ctrl SpaceSelect Column
Ctrl Space+ Ctrl Shift + Insert Column
Shift SpaceSelect 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 TabToggle between files
Windows DMaximize Minimize
Hide RowSelect row -> Ctrl 9
Hide ColumnSelect Column -> Ctrl 0
Unhide RowSelect row -> Ctrl + Shift + 9
Unhide ColumnSelect Column -> Ctrl + Shift + 0

 

Download Excel shortcuts PDF

 
  1. Accounts Tax
  2. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 6 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com.
Jail