How to Delete Filtered Rows in Excel

To delete filtered rows in Excel, follow the steps below:

1. Open your Excel workbook and select the worksheet containing the data you want to filter and delete rows from.
2. Click on the Data tab in the Excel ribbon.
3. In the Sort & Filter group, click on Filter. This will enable filtering for your data and display small drop-down arrows next to each column header.
4. Click on the drop-down arrow in the column header for the criteria you want to filter by. This will open the filter menu.
5. In the filter menu, uncheck Select All, then select the specific criteria you want to filter your data by. Click OK to apply the filter. Your data will now be filtered, displaying only the rows that meet the selected criteria.
6. To delete the filtered rows, follow these steps:a. Select the visible (filtered) cells by clicking on the first visible cell in the data, then press Ctrl + Shift + Right Arrow to select the entire row.b. After selecting the first row, press Ctrl + Shift + Down Arrow to select all visible rows.c. With the filtered rows selected, right-click on any of the selected cells, and click Delete Row from the context menu.
7. After deleting the filtered rows, click on the Filter button in the Sort & Filter group on the Data tab to remove the filter and display your remaining data.

Example

Let's assume you have an Excel sheet with sales data, and you want to delete rows where the sales amount is less than $100.

1. Follow steps 1-3 above to enable filtering for your data.
2. Click the drop-down arrow in the column header for the "Sales Amount" column.
3. In the filter menu, click Number Filters > Less Than.
4. In the Less Than dialog box, enter 100 in the box next to "is less than" and click OK. Your data will now be filtered to display only rows with sales amount less than $100.
5. Follow steps 6a-6c to delete the filtered rows.
6. Finally, follow step 7 to remove the filter and display the remaining data.