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
"Luke" wrote in message
...
| 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