26. Excel How to Delete Filtered Rows ?

---

When a filter is applied to a sheet, the unfiltered rows are hidden.

If you select and delete the filtered rows, then the hidden rows in that selection may be deleted.

To prevent hidden rows from being deleted :

1 - Apply the filter and select the rows to be deleted.

2 - Open the Find and Select menu in the Editing group of the Home tab of the ribbon and choose Go To Special...

3 - In the Go To Special dialog box, check the Visible cells only option.

4 - Confirm with the OK button. This way the hidden rows are not selected.

5 - Open the Delete menu in the Cells group of the Home tab of the Ribbon and choose Delete Sheet Rows.

---