Microsoft Excel is a handy tool for sorting and analysing data. However, dealing with a lot of information in a spreadsheet can get a bit much. To make things clearer, users often hide some rows. While hiding rows can be useful, knowing how to reveal and manage them when necessary is essential. Deleting rows in Excel is straightforward, but how do you do that when the rows are hidden?
In this article, we have discussed how to delete selected hidden rows and all hidden rows in your Excel workbook.
Also read: How to add a secondary axis in Excel?
Delete selected hidden rows
If you want to delete the selected hidden rows in your Excel worksheet, start by unhiding the hidden rows that you want to delete. Once they are visible, select and delete them to clear them from your worksheet.
Check out our article to learn how to unhide rows in Excel
Also read: How to calculate the percentage change in Excel?
Delete all hidden rows
Excel has an inbuilt feature called Inspect Document, which we will use to delete all the hidden rows in the workbook. Besides finding hidden rows and columns, the Document Inspector dialogue box provides plenty of other helpful info, like counting comments, locating hidden worksheets, or even spotting embedded documents.
To delete all hidden rows, follow the steps below:
Step 1: Open the datasheet and click on the File tab in the menu bar.
Step 2: Click on the Info option in the sidebar.
Step 3: Click on the Check for Issues box.
Step 4: Click on the Inspect Document option in the dropdown menu.
Step 5: In the Document Inspector window, click the Inspect button.
Step 6: In the result, scroll down and find the Hidden Rows and Columns section. It will show an exclamation mark beside it with the number of hidden rows in your datasheet.
Click the Remove All button beside it to delete all the hidden rows from your datasheet.
Step 7: The exclamation mark will be replaced by a green tickmark indicating no hidden rows in your datasheet.
Also read: How to change the series name in Excel?
