reset the scroll on the right side

[Gator]

I have 1000 records in Excel and I formatted an entire column down to line
65xxx and now when I use the scroll bar on the right it scrolls the entire
worksheet. How can I reset it where when I scroll the bar to the bottom of
the page, the page scroll to the last record and not the end of the worksheet

 

[Bob I]

Select rows 1001 to 65535 and delete them.

 

[Gator]

found it...I highlight the "blank" parts and do edit, clear, all and then save

 

[Gord Dibben]

Go to end of real data range.

SHIFT + End + DownArrow

Edit>Delete>Entire Rows.

Do same for columns to the right of real data range.

NOW>>>>>>>>>>Save the workbook.

In older versions you had to Save, Close then re-open to see the change.


Gord Dibben MS Excel MVP