scroll control of an Excel spreadsheet

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.

Edit>Delete>Entire 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"
<Nephets@discussions.microsoft.com> wrote:

>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" <Nephets@discussions.microsoft.com> wrote in message
news:DE081BF2-AF1A-4E6D-B9CF-2DBBDD4967E7@microsoft.com...
> how do i reset the scroll length to match the actual size of an Excel
> spreadsheet?