In this Help and information tutorial, you will see how to hide and unhide rows & columns in Microsoft Excel. It may be useful to hide rows or columns you temporarily do not need, but would like to keep for later.

Note: This tutorial is for using Microsoft Excel 2016 on a Windows computer. The layout may differ slightly in other versions of Microsoft Excel.

Video Instruction

The video below illustrates how to HIDE rows in Microsoft Excel. Please keep reading to view written instructions.

The video below illustrates how to UNHIDE rows in Microsoft Excel. Please keep reading to view written instructions.

Written Instruction: Hiding a Row

The following instructions are for hiding a row in Microsoft Excel. Hiding a column would follow the same procedures, using the columns.

Step 01: Select the Rows You Want to Hide

Using your mouse, select the rows that you would like to hide by clicking the row number of the first row to hids and dragging to the final row to hide.

Step 02: Hide the Rows

A. Right click on the row number of the row you wish to hide

B. Click Hide from the menu that pops up

Step 03: Review the Spreadsheet

After clicking Hide in the previous step, the rows you selected will disappear. Notice that the row numbers of the hidden rows are not displayed. Review your spreadsheet to confirm it looks as you intended

Written Instruction: Unhiding a Column

The following instructions are for unhiding a column in Microsoft Excel. Unhiding a row would follow the same procedures, using the rows.

Step 01: Select the Columns you Want to Unhide

Using your mouse, select the columns that you would like to unhide by clicking the column letter of the first column to unhide and dragging to the final column to unhide.

Step 02: Unhide the Columns

A. right click on the column letter of the column you wish to unhide.

B. Click Unhide from the menu that pops up

Step 03: Review the Spreadsheet

After clicking Unhide in the previous step, the columns that were hidden will appear. Notice that the column letters are now continuous. Review your spreadsheet to confirm it looks as you intended