Scroll bar problem

L

Luke

If I drag the scroll bar to the bottom of the page I get down to line 65,000.
However there is only data in lines 1 - 100. This makes navigating around the
page difficult. Any suggestion how I can rectify this?

Luke
 
J

Jim Rech

Select all the rows from 100 on down and do an Edit, Delete. Then save the
workbook. The active area should then be reset and the scroll bar adjusted
accordingly.

--
Jim Rech
Excel MVP
| If I drag the scroll bar to the bottom of the page I get down to line
65,000.
| However there is only data in lines 1 - 100. This makes navigating around
the
| page difficult. Any suggestion how I can rectify this?
|
| Luke
 
Top