reset the scroll on the right side

  • Thread starter Thread starter Gator
  • Start date Start date
G

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
 
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
 
Back
Top