I'm troubleshooting a bloated / laggy file, and noticed that when I press Ctrl+END, which I was told should move the cursor to the bottom- and right-most used cell of the sheet, it takes me to cell BV96570.
The BV column makes sense, because I do indeed have data in cells out to column BV, but the sheet only has ~3,500 rows of cells with data. So why does the sheet think that rows all the way down to 96,570 are "used"?
The weirdest thing is that if I highlight rows 4,000 - 100,000 and DELETE them, Ctrl+END still takes me to cell BV96570. In other words, I'm actively deleting anything that could be below row 4,000 and the sheet still thinks 96K+ rows are being 'used'.
What could be going on here?
The BV column makes sense, because I do indeed have data in cells out to column BV, but the sheet only has ~3,500 rows of cells with data. So why does the sheet think that rows all the way down to 96,570 are "used"?
The weirdest thing is that if I highlight rows 4,000 - 100,000 and DELETE them, Ctrl+END still takes me to cell BV96570. In other words, I'm actively deleting anything that could be below row 4,000 and the sheet still thinks 96K+ rows are being 'used'.
What could be going on here?