![]() 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
0 Comments
Leave a Reply. |