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