26. Excel Comment supprimer les lignes filtrées ?
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.