SEARCH

How-To Geek

How to Hide and Unhide Rows and Columns in Excel 2013

00_lead_image_hide_unhide

There may be times you want to remove a row or column from a spreadsheet, but you don’t want to permanently delete it from the worksheet file. Excel has a feature that allows you to temporarily hide a row or column from view.

NOTE: Cells in hidden rows and columns can still be included in calculations in other visible cells as well as perform calculations themselves.

To hide one or more rows, select the row(s) to be hidden.

01_selecting_rows_to_hide

Right-click on one of the row headers selected and select Hide from the popup menu.

02_selecting_hide_for_rows

The selected rows are hidden, including the row headings. Notice that rows three and four in the following image are hidden as well. A thick line also initially separates the rows where there are hidden rows. When you perform other actions on the spreadsheet, this thick line will disappear. However, you can tell where the rows are hidden by the missing row headers.

03_rows_hidden

To unhide a row, you must first select the rows both above and below the hidden row(s). Then, right-click on the selected row headers and select Unhide from the popup menu.

04_selecting_unhide_for_rows

The hidden rows display again and are highlighted along with the surrounding rows.

05_rows_unhidden

You can also easily hide one or more columns. Select the column(s) you want to hide, right-click on one of the column headers, and select Hide from the popup menu.

06_selecting_hide_for_column

The selected columns are hidden along with the column headers and a thicker line displays where the columns were.

07_column_hidden

To unhide the hidden columns, just like with hidden rows, select the columns both to the right and left of the hidden columns, right-click on one of the column headers, and select Unhide from the popup menu.

08_selecting_unhide_for_columns

The hidden column(s) display again highlighted along with the columns on either side.

09_column_unhidden

This feature is handy if you want to print out only relevant rows and columns of your spreadsheet, but don’t want to delete the temporarily unneeded information.

Lori Kaufman is a freelance technical writer who likes to write geeky how-to articles to help make people's lives easier through the use of technology. She loves watching and reading mysteries and is an avid Doctor Who fan.

  • Published 07/8/13

Enter Your Email Here to Get Access for Free:

Go check your email!