delete extra space

Does anyone know a good way to clear out the extra space on a sheet that at
one time had data but now doesn't but the scrolling still goes as far down as
the data used to go down? I have tried clear formatting, deleting the rows
and/or columns and the like, but have had no luck. Strike that I have had
random luck, sometimes it kind of works, but only for the rows and not the
columns, any one know how to go about this?

Thanks,

Try this:

Delete the entire rows and columns that are a problem.

Save the workbook
(On some versioins of Excel you must also close the workbook (that you just
saved) and re-open it.)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"WBTKbeezy" wrote:

> Does anyone know a good way to clear out the extra space on a sheet that at
> one time had data but now doesn't but the scrolling still goes as far down as
> the data used to go down? I have tried clear formatting, deleting the rows
> and/or columns and the like, but have had no luck. Strike that I have had
> random luck, sometimes it kind of works, but only for the rows and not the
> columns, any one know how to go about this?
>
> Thanks,
>

WBTKbeezy wrote:
> Does anyone know a good way to clear out the extra space on a sheet that at
> one time had data but now doesn't but the scrolling still goes as far down as
> the data used to go down? I have tried clear formatting, deleting the rows
> and/or columns and the like, but have had no luck. Strike that I have had
> random luck, sometimes it kind of works, but only for the rows and not the
> columns, any one know how to go about this?
>
> Thanks,

Hi WBTKbeezy

The scroll bars should re-set to the size of the used range when the
workbook is saved.

Regards

Steve

Thanks guys, that helped... it also explained why it would randomly work!

"Scoops" wrote:

>
> WBTKbeezy wrote:
> > Does anyone know a good way to clear out the extra space on a sheet that at
> > one time had data but now doesn't but the scrolling still goes as far down as
> > the data used to go down? I have tried clear formatting, deleting the rows
> > and/or columns and the like, but have had no luck. Strike that I have had
> > random luck, sometimes it kind of works, but only for the rows and not the
> > columns, any one know how to go about this?
> >
> > Thanks,
>
> Hi WBTKbeezy
>
> The scroll bars should re-set to the size of the used range when the
> workbook is saved.
>
> Regards
>
> Steve
>
>