|
Featured Tutorial
Featured Macro
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
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