Shortcut Name Description
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
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 and Try with following file: 


  1. Excel

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 10 years. He also provides Accounts Tax GST Training in Delhi and Pune.