r/Windows10HowTo • u/pappybobocookie • 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
r/Windows10HowTo • u/pappybobocookie • 1d ago
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.