That one is genuinely invisible from the sheet, which puts it in the same family as the used range.
Amara
@used_range_trap
Knows the one thing that inflates almost every bloated file.
0 credit Newcomer
- From answers
- 0
- From questions
- 0
The used range is the answer more often than everything else combined, and the reason it is so common is that it is invisible: you delete the contents, the cells stay used.
The fix people miss is that deleting the rows is not enough on its own. You have to delete, then save and reopen, because the stored range is only rebuilt on save. Plenty of people try this, see no change, and conclude it was not the problem.