Excel / How to Hide and Unhide Rows, Columns, and Worksheets

To hide a row or column in Excel, right-click its number or letter and choose Hide. To restore one in the middle of a sheet, select the headers on both sides and choose Unhide. Use the sheet tab menu at the bottom to hide or restore a worksheet.

The paths below are for desktop Excel on Windows. Hidden cells and sheets remain in the workbook and formulas can still refer to them.

Hide and unhide rows

  1. Select the row number, then right-click and choose Hide. If you hide row 2, the numbering jumps from 1 to 3. Hold Ctrl while selecting the numbers of nonadjacent rows.
  2. To restore row 2, select the headers for rows 1 and 3 together. Right-click a selected header, choose Unhide, and confirm that row 2 is visible.

Hide and unhide columns

  1. Select the column letter and choose Hide from its right-click menu. If you hide column B, column C appears next to column A.
  2. To restore B, select columns A and C together. Right-click a selected column header and choose Unhide.

For a hidden first row or column A, type A1 in the Name Box next to the formula bar and press Enter. Go to Home → Format → Hide & Unhide and select Unhide Rows or Unhide Columns. Apply both commands if you need to restore both.

To restore all hidden rows or columns, click Select All in the top-left corner where the headers meet and apply the same commands. Use the Name Box method if you only want to restore the first row or column.

Microsoft’s guide to hiding rows and columns

Microsoft’s guide to unhiding the first row or column

Hide and unhide a worksheet

  1. Right-click the sheet tab at the bottom and choose Hide. At least one sheet must remain visible, so you cannot hide the last visible sheet.
  2. Right-click a visible sheet tab and choose Unhide. Worksheets hidden in the usual way appear in the list.
  3. Select the sheet and click OK. If your version supports multiple selections, hold Ctrl to select more than one. If it allows only one selection, repeat for each sheet.

Microsoft’s guide to hiding worksheets

When data still does not appear

If you see an applied filter icon in a column header, check the filter first. Clear its condition in that column’s filter menu to restore rows excluded by it.

Microsoft’s guide to clearing filters

If the sheet commands are unavailable, check whether the workbook structure is protected. Sheets marked VeryHidden through VBA are absent from the ordinary list. Ask the workbook owner to restore them.

To remove sensitive information from a file you plan to share, make a separate copy and remove the data. Check the remaining sheets and formulas before sending it.