Any objects (pictures/controls) on that worksheet?

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlfaqApp.html#Unused

(Just to verify that you did it ok.)

roadkill wrote:

Thanks for your efforts, but neither suggestion worked. I tried selecting
all of the rows below the data and then deleting them, selecting one column
(end of data to the bottom) and then deleting all of the rows, and I tried
selecting all cells below the data and clearing all. After each I
immediately saved, exited, and opened again but there was no change. Any
other ideas?
Will

"Gord Dibben" wrote:

CT and roadkill

Clearing will not reset the used range. Excel still thinks those rows/cells
are in use.

Deleting the entire rows then saving/closing and re-opening will reset the
used range.


Gord Dibben Excel MVP

On Tue, 6 Sep 2005 17:10:49 -0700, "CyberTaz"
wrote:

Hello roadkill-

Try this... Select all rows below your data, go to EditClearAll, then
close the file (save if prompted). When you reopen the file the scroll bar
_should_ be back to normal.

HTH |:)

"roadkill" wrote:

I have a spreadsheet in which the moving piece in the vertical scroll bar is
very narrow and, if you move it to the bottom, you have gone far below the
bottom of the data. I tried deleting all rows (i.e. entire rows) between the
end of my data and the scroll end, but this didn't seem to have any effect.
Then I tried deleting rows all the way to the bottom of the spreadsheet.
This didn't help either. Any ideas on why this is happening or how to fix it?

Thanks in advance,
Will



--

Dave Peterson