See all How-To Articles

How to Delete Hidden Rows and Columns in Excel

This tutorial demonstrates how to delete hidden rows and columns in Excel.

 

delete hidden rows initial data

 

Delete Hidden Rows and Columns

There are several ways to delete entire rows and/or columns in Excel, but sometimes the cells you want to remove are hidden. To delete hidden rows and columns in your file, use the Document Inspector. Say you have the following data set with Rows 5, 8, and 9 hidden.

 

delete hidden rows initial data

 

To delete the hidden rows, follow these steps:

  1. In the Ribbon, go to File > Info.

 

delete hidden rows 1

 

  1. In the Info window, click Check for Issues and choose Inspect Document.

 

delete hidden rows 2

 

  1. You get a warning that you have to save before checking. Just click yes to confirm.

 

delete hidden rows 3

 

  1. In the Document Inspector window, scroll down and make sure that the Hidden Rows and Columns option is checked (by default, it’s checked). Click Inspect.

 

delete hidden rows 4

 

  1. You get the total number of hidden rows and columns. Click Remove All to delete them and Close the window.

 

delete hidden rows 5

 

As a result, Rows 5, 8, and 9, which were hidden, are now deleted from the worksheet.

 

delete hidden rows 6

 

Note: You can also use VBA code to delete rows and columns.