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.

Excel 2016 Go To Special dialog box

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.


<< 25. Excel How to split a column of text into several columns ? How to split a cell ?

27. Excel How to extract text from a cell ? >>

Reader comments

Add a comment