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.Click on Delete Row from the pop-up menu.Select all the filtered rows in view and right-click with your mouse.
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
0 kommentar(er)
