Let’s assume a scenario where we have a more complex filter to perform on our employee information. Delete Hidden Filtered Rows Using the Inspect Document Feature Read More: Formula to Remove Blank Rows in Excel (5 Examples)ģ.
After that enter the following code into the Module.Click Developer → Visual Basic, a new Microsoft Visual Basic for Applications window will be displayed.At first, select all the rows you need to filter ( including the column headers).Then you can also use the VBA to get the above task done more quickly. If you are familiar with VBA code or feel comfortable working with VBA.
Read More: How to Filter and Delete Rows with VBA in Excel (2 Methods) You can simply click on the Filter button from the Data Tab, to see the rest of the data.But don’t worry!! It will not affect the other rows that are currently hidden. It will delete the current rows containing the information about the employees working in the Sales department that we have filtered.A warning pop-up box will appear and will ask if you want to delete the entire row.
Upon clicking OK, you will now see the information of those employees working in the Sales.You can just untick the Select All box to uncheck every type of department quickly and then select or check only the box next to the Sales.Uncheck all the boxes next to every type of Department except for the Sales.A window will pop up that will let you filter the Department column according to your choice. For this example, we want to only filter out those rows containing the information about the employees working in the Sales. So, select the drop-down arrow in the down-right corner of the Department Header.Click on an arrow to apply Filter on that respective column. These small arrows will let you apply Filter on the respective column. You will see a small downward arrow in the down-right corner of each header column.Click on the Filter button under the ‘ Sort and Filter ’ section under the Data tab.First, we will select the whole data range of our worksheet.Now, we will filter the data and delete both the visible and hidden rows using 5 different methods. We have the name of the employees, the department they are working in, their blood group, and their joining date. Let’s assume a scenario where we have information about employees of a company. 5 Suitable Methods to Delete Filtered Rows in Excel