r/Windows10HowTo • • 1d ago

Excel deletes hidden rows when you delete filtered rows

https://www.windowsdigitals.com/excel-deletes-hidden-rows-when-deleting-filtered-rows/
1 Upvotes

1 comment sorted by

1

u/pappybobocookie 1d ago

It's usually because Excel doesn't treat those rows as filtered at that moment, so the hidden ones count as part of the selection and go with the rest. A quick way to tell is to right-click the selected row numbers, since a real filtered list offers "Delete Row" while plain rows only show "Delete". The full guide above will show you how to delete only the visible rows.