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,

delete extra space
 

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,

delete extra space
 

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

delete extra space
 

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

delete extra space
 

I have a file that does the same thing as described originally by WBTKbeezy
but these suggestions do not work. I have Excel 2003. The data range is from
A1 to 02000 but the scroll bar does all the way to 653??? (the very last
possible row supported by excel). How can i make it stop?

"WBTKbeezy" wrote:

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

delete extra space
 

See this:

http://contextures.com/xlfaqApp.html#Unused

Biff

"caj" wrote in message
...
I have a file that does the same thing as described originally by
WBTKbeezy
but these suggestions do not work. I have Excel 2003. The data range is
from
A1 to 02000 but the scroll bar does all the way to 653??? (the very last
possible row supported by excel). How can i make it stop?

"WBTKbeezy" wrote:

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

delete extra space
 

Biff,
It worked for the columns but not for the rows.

"Biff" wrote:

See this:

http://contextures.com/xlfaqApp.html#Unused

Biff

"caj" wrote in message
...
I have a file that does the same thing as described originally by
WBTKbeezy
but these suggestions do not work. I have Excel 2003. The data range is
from
A1 to 02000 but the scroll bar does all the way to 653??? (the very last
possible row supported by excel). How can i make it stop?

"WBTKbeezy" wrote:

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

delete extra space
 

Are you sure you did it correctly? I don't know what else to suggest. I've
never had that procedure not work.

Biff

"caj" wrote in message
...
Biff,
It worked for the columns but not for the rows.

"Biff" wrote:

See this:

http://contextures.com/xlfaqApp.html#Unused

Biff

"caj" wrote in message
...
I have a file that does the same thing as described originally by
WBTKbeezy
but these suggestions do not work. I have Excel 2003. The data range is
from
A1 to 02000 but the scroll bar does all the way to 653??? (the very
last
possible row supported by excel). How can i make it stop?

"WBTKbeezy" wrote:

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

delete extra space
 

Hi CAJ,
Was it the macro that you tried, if not I would suggest using the macro.
Also make sure that you didn't actually stick data into an out of the way place
like the last row. Needless to say hidden work areas don't work very well.

I always have trouble trying to do it correctly manually, but the macro works
a lot better and it does all of the worksheets, and the macro forces a save,
which you could do later, but might forget.

Unless the macro has been
fixed though you would delete valid data if the address of the last cell
is a merged cell, though not likely in the worksheet you have a problem
with since it points to the last row, but other sheets just might have merged cells..
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Biff" wrote in message ...
Are you sure you did it correctly? I don't know what else to suggest. I've
never had that procedure not work.

Biff

"caj" wrote in message
...
Biff,
It worked for the columns but not for the rows.

"Biff" wrote:

See this:

http://contextures.com/xlfaqApp.html#Unused

Biff

"caj" wrote in message
...
I have a file that does the same thing as described originally by
WBTKbeezy
but these suggestions do not work. I have Excel 2003. The data range is
from
A1 to 02000 but the scroll bar does all the way to 653??? (the very
last
possible row supported by excel). How can i make it stop?

"WBTKbeezy" wrote:

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