Now go to the drop-down of the Temporary column. All the rows without the value 0 are now deleted. Do a right-click and click on the option Delete Row. So, we get the rows that we have to delete. Go to the drop-down option in the ‘Temporary’ column. We can see the filtering drop-downs in the title bars of the dataset. 
From the drop-down select the option Filter.
We will select the entire dataset (B4:G15) again. We can see 0 only in the rows that we want to keep. Here all the hidden data are now visible. Then, go to the Sort & Filter drop-down. Select the entire dataset (B4:B15) again. Here, we will get only the sales data for New York and Boston. Just select the option New York and Boston. Now, go to the filtering drop-down of the title Location. As a result, we will see a dataset like this with filtering options at the column head. From the dropdown click on the option Filter. In the beginning, select the entire dataset (B4:G14). Just follow the simple steps to execute this: Suppose, in the following dataset we just want to keep the sales data of the location New York and Boston. We will use filtering to apply this method. Adding Temporary Column to Delete Hidden RowsĪnother approach is to delete hidden rows by adding a temporary column. #How to run document inspector in excel mac how to
Read More: How to Delete Specific Rows in Excel (8 Quick Ways)Ģ. So, you must keep the backup of the data if you don’t want to delete them permanently. We can not undo the deleted rows after this process. The below image shows the uninterrupted sequence of row numbers after deleting the hidden rows.
Finally, we can see that the hidden rows are not present anymore. Select the option Remove All for the Hidden Rows and Columns section. After that, in the new window scroll down. Then from the Document Inspector window click on the option Inspect. From the drop-down select the ‘Inspect Document’ option. Firstly, got to the File option from the ribbon. Now we will follow some steps to delete these hidden rows. So, we can see the highlighted rows are not visible. Do a right-click on the cell index number. Here, to hide the highlighted rows, select the rows. Let’s see the process of hiding the rows first: After this, we will delete the highlighted rows. For your convenience, in this method, first, we will hide rows that are highlighted. The following dataset consists of sales data. We have to use VBA to do which we will discuss in the latter part of this article. So, this method is not applicable if we want to delete rows just from a single worksheet. 
It deletes hidden rows from the entire workbook. ‘ Inspect Document’ option is an effective way to hide rows. ‘Inspect Document’ Option to Delete Hidden Rows in Excel
3 Methods to Delete Hidden Rows in Excel 1.
0 kommentar(er)
