| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| Confirm before deleting a worksheet? | Excel Discussion (Misc queries) | |||
| Deleting filtered out data from a worksheet | Excel Worksheet Functions | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Linear Mode
