Resetting the "end" of a spreadsheet in Excel 97

[rtcopeland]

I an working in Excel 97 and am using the CNTL-END keys to move quickly to the end of a document. On spreadsheets where I have deleted data from cells or deleted entire rows, Excel recognizes those cells as the end of the spreadsheet. I want to know how to reset the end of the spreadsheet so when I use CNTL-END it will only go to the last cell I have actual data.

 

[Mark W.]

Save your worksheet and then Control+End.