deleting unused space at the end of a worksheet
 

I have several worksheets that have a lot of space either at the end or on
the right side of the document that is blank. I have fixed it so that I am
only printing the pages with information but how do I get rid of all this
extra space?

deleting unused space at the end of a worksheet
 

beckyz, you can reset the used range


Have a look here for a way to do it
http://www.contextures.com/xlfaqApp.html#Unused
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"beckyz" wrote in message
...
I have several worksheets that have a lot of space either at the end or on
the right side of the document that is blank. I have fixed it so that I
am
only printing the pages with information but how do I get rid of all this
extra space?

deleting unused space at the end of a worksheet
 

It worked! Thank you so much.

"Paul B" wrote:

beckyz, you can reset the used range


Have a look here for a way to do it
http://www.contextures.com/xlfaqApp.html#Unused
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"beckyz" wrote in message
...
I have several worksheets that have a lot of space either at the end or on
the right side of the document that is blank. I have fixed it so that I
am
only printing the pages with information but how do I get rid of all this
extra space?

deleting unused space at the end of a worksheet
 

Your welcome, thanks for the feedback
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"beckyz" wrote in message
...
It worked! Thank you so much.

"Paul B" wrote:

beckyz, you can reset the used range


Have a look here for a way to do it
http://www.contextures.com/xlfaqApp.html#Unused
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"beckyz" wrote in message
...
I have several worksheets that have a lot of space either at the end or
on
the right side of the document that is blank. I have fixed it so that
I
am
only printing the pages with information but how do I get rid of all
this
extra space?