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

Select rows 1001 to 65535 and delete them.

Gator wrote:

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

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

"Gator" wrote:

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

Go to end of real data range.

SHIFT + End + DownArrow

EditDeleteEntire Rows.

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

NOWSave the workbook.

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


Gord Dibben MS Excel MVP

On Tue, 9 Sep 2008 08:19:01 -0700, Gator
wrote:

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