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.

hidden rows columns intro

 

 

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 and 8 as well as column D hidden.

hidden rows columns hidden

 

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 (1) the Hidden Rows and Columns option is checked (by default, it’s checked) and then (2), click Inspect.

 

hidden rows columns document inspector

 

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

hidden rows columns remove

 

 

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

 

hidden rows columns result

 

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