All Content
Timespan
​
Shortcut To Hide or Unhide Rows or Columns In Excel
Mar 3, 2023 10:47 PM

Shortcut To Hide or Unhide Rows or Columns In Excel

External YouTube Channel

easiest way to unhide rows on excel how do you quickly unhide rows and columns in excel how do you unhide rows in excel quickly youtube how to easily unhide row

Shortcut keys are a great way to quickly hide or unhide rows or columns in Excel. To quickly hide a row, select the row number(s) at the left side of your worksheet and press Ctrl + 9. To quickly unhide a hidden row, select the row number(s) at the left side of your worksheet and press Ctrl + Shift + 9.

To quickly hide a column, select the column letter(s) at the top of your worksheet and press Ctrl + 0 (zero). To quickly unhide a hidden column, select the column letter(s) at the top of your worksheet and press Ctrl + Shift+ 0 (zero).

  • easiest way to unhide rows on excel
  • how do you quickly unhide rows and columns in excel
  • how do you unhide rows in excel quickly youtube
  • how to easily unhide rows in excel
  • how to hide and unhide columns rows excel shortcut
  • how to unhide all rows in excel shortcut
  • how to unhide rows in excel shortcut
  • how to unhide rows in excel shortcut key
  • how to unhide the rows in excel keyboard shortcut
  • quick way to unhide rows in excel
  • how to quickly unhide rows in excel
  • how to unhide rows excel shortcut

Questions and Answers about Office/Excel

To unhide all rows and columns, select the whole sheet as explained above, and then press Ctrl + Shift + 9 to show hidden rows and Ctrl + Shift + 0 to show hidden columns.

Hide Rows Using Shortcut Keys The keyboard key combination for hiding rows is Ctrl+9: Click on a cell in the row you want to hide to make it the active cell. Press and hold down the Ctrl key on the keyboard. Press and release the 9 key without releasing the Ctrl key.

The shortcut for hiding columns in Excel is Ctrl + 0. For the sake of clarity, the last key is zero, not the uppercase letter "O". To hide a single column, select any cell within it, then use the shortcut. To hide multiple columns, select one or more cells in each column, and then press the key combination.

First, Press Ctrl + A + A to select the entire sheet to unhide all the hidden columns from the whole sheet. Or select only the specific columns range using Ctrl + Space and Shift + < or > arrow keys if you want to unhide columns only from that specific range of columns and not from the entire sheet.