Delete Empty Rows
Posted by thomas venn on January 16, 2002 10:36 AM
Way back a few months ago, there was a question regarding the ability to delete empty rows. By this I mean having Excel no longer recognize the empty rows as still containing data. For example, If I delete all my data from rows 500 to 65000, then I press Control+End, I go to row 65000. What I want is to have excel go to row 499, because that is the last row, but Excel is going to row 65000 because there was data there before. Any help is appreciated.