Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




YouTubersLoveExcel#30: Keyboard Shortcut Tricks.


Learn keyboard shortcuts for Row & Column Tricks: Hide, Delete, Insert, Select.

1) Keyboard shortcut for Inserting a Column is: Alt + I + C
2) Keyboard shortcut for Inserting a Roe is: Alt + I + R
3) Keyboard shortcut for deleting a Row is: Alt + E + D + R + Enter (or Shift + Spacebar + Ctrl + -)
4) Keyboard shortcut for deleting a Column is: Alt + E + D + C + Enter (or Ctrl + Spacebar + -)
5) Keyboard shortcut for hiding a Column is Ctrl + 0
6) Keyboard shortcut for hiding a Row is Ctrl + 9
7) To Unhide rows or columns, select columns or rows on either side of hidden rows/columns, then right-click, Unhide. To unhide column A, highlight column B, then hold Shift and tap Left arrow, then right-click, Unhide.

Hot Keys





Got a Question? Ask it Here in the Forum.