Resetting the "end" of a spreadsheet in Excel 97

rtcopeland · Apr 26th, 2002, 10:34 AM

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. · Apr 26th, 2002, 10:39 AM

Save your worksheet and then Control+End.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 10:34 AM	#1
rtcopeland New Member Join Date: Apr 2002 Posts: 1	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.

Apr 26th, 2002, 10:39 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Save your worksheet and then Control+End.