deleting unused space at the end of a worksheet

B

beckyz

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?
 
P

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
 
P

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
 
Top