How to Hide or Unhide Columns and Rows in Excel

Have a data-heavy Excel spreadsheet and want to hide the rows and columns? Follow these tips to hide and unhide your data.

If you’re dealing with a data-heavy spreadsheet, sometimes it’s helpful to hide or unhide rows and columns to better see the information you need to analyze, rather than deleting the row. Fortunately, Microsoft Excel makes it easy to do this.

How to Hide Columns and Rows in Excel

Start by selecting the column(s) or row(s) you want to hide. You can do this a few different ways.

  • Select multiple adjacent columns or rows: Click the first column or row, hold the Shift key, and click the last column or row.
  • Select multiple non-adjacent columns or rows: Click the first column or row, hold the Control key (Command on Mac), and click the remaining columns or rows in turn.
  • Use the name box: Type a cell label in the name box to the left of the formula field. For example, if you want to hide the second row, for type B2. (For more, check out our tutorial to the Excel name box.)
READ MORE  Office Lens app for Windows Phone released: scan objects to OneNote

Once you make your selection(s), follow one of these methods to hide the columns or rows.

  • Right-click the selected column or row you want to hide and choose Hide. (This method will not work if you’ve typed in the column or row identifier.)
  • Use the shortcut Ctrl + 9 to hide rows and Ctrl + 0 to hide columns.
  • Click the Home tab and in the Cells group, click Format > Hide and Unhide and pick either Hide Rows or Hide Columns.

excel hide rows

The column or row will be hidden and you’ll see a thin double line indicating where the hidden column or row resides.

READ MORE  Connect Samsung mobile phone to PC or Mac

excel hidden rows

How to Unhide Columns or Rows in Excel

There are a few ways to select and unhide columns or rows:

  • Right-click the thin double line indicating a hidden row or column and select Unhide.
  • Select the two surrounding columns or rows. On the Home tab in the Cells group, click Format > Hide and Unhide and choose either Unhide Rows or Unhide Columns.
  • To unhide all columns or all rows in your spreadsheet, select all using the keyboard shortcut Control + A (Command + A on Mac), right-click, and pick Unhide.

READ MORE  Microsoft's Office 2016 for Mac preview ready for download

Keep in mind that while you can hide or unhide either multiple columns or multiple rows at the same time, you can’t hide or unhide both columns and rows simultaneously.

Hide More Than Rows and Columns in Excel

Columns and rows aren’t the only items you can hide and unhide in Excel. You can also hide elements like text, comments, and cells to keep your spreadsheet nice and tidy.

      Select your currency
      Register New Account