Originally Posted by
kostas
Dear All,
I have the following problem.
I use a worksheet that contained about 30-40.000 rows of data. After some sorting, editing and general processing I am left with about 3.000 rows of data. The rest of the worksheet "appears" blank, although I suspect that from row 3000 to almost the end there must be some "null" cells in the rows.
The problem I face is that whenever I press control+shift+end to go to the end of my worksheet, instead of landing in row no.3000 where my data finish, I land in the middle of nowhere somewhere around row 30.000+. I tried Deleting, clearing all formats and all sorts of combinations of delete/clear in the rows that appear blank but the problem persists.
Is there a way that I can permanently delete these rows so I dont have the problem when I want to jump to the end of my worksheet?
Please do not suggest hiding rows as this is not what I am looking for.
Thank you all for your answers in advance.
Bookmarks