deleting unused space at the end of a worksheet

[Guest]

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?

 

[Paul B]

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

 

[Guest]

It worked! Thank you so much.

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

 

[Paul B]

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