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,