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,
>