I know this is a silly question, but how do you reset the end of data cell?
For example: Let's say I import a data file with 500 rows of data, three columns wide. I edit the data. I delete some records (rows). Massage the data. Delete some more rows etc. And now I am left with 425 rows of data, still 3 columns wide. If I use Ctrl+End I go to row 500 column 3 not row 425 column 3.
How do I "reset" the end of data area to row 425? Currently, I am copying all the data into a new workbook, closing the original workbook, and doing a "save as". There has to be an easier way.