This tutorial demonstrates how to delete hidden rows and columns in Excel.
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.
To delete the hidden rows, follow these steps:
- In the Ribbon, go to File > Info.
- In the Info window, click Check for Issues and choose Inspect Document.
- You get a warning that you have to save before checking. Just click yes to confirm.
- 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.
- You get the total number of hidden rows and columns. Click Remove All to delete them and Close the window.
As a result, Rows 5, 8, and 9, which were hidden, are now deleted from the worksheet.
Note: You can also use VBA code to delete rows and columns.