how do i reset the scroll length to match the actual size of an Excel
spreadsheet?

Hi Hephets,

See Debra Dalgleish's notes on resetting the used range at:

http://www.contextures.com/xlfaqApp.html#Unused

---
Regards,
Norman


"Nephets" wrote in message
...
how do i reset the scroll length to match the actual size of an Excel
spreadsheet?

Nephets

First hit CTRL + End to see where Excel thinks is the end of used range.

If far below and right of what you know is your real used range then

scroll to bottom of data.

Select first blank row then SHIFT + End + DownArrow.

EditDeleteEntire Row.

Do same for columns to the right of your data.

Now the important step.................Save the workbook.

In some versions a close after save is also required.

When you re-open, your used range should be correct and your scroll length
much shorter.


Gord Dibben Excel MVP

On Wed, 30 Nov 2005 17:21:02 -0800, "Nephets"
wrote:

how do i reset the scroll length to match the actual size of an Excel
spreadsheet?