Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can't delete blank pages
I have a spreadsheet that when I go into print preview there are 59 pages. I
did not create the spreadsheet. However, there is only something on 3 of those pages. How to I delete all of these extra pages. Thanks very much for any help. I am using Excel 2003 Dee |
#2
|
|||
|
|||
on the main sheet select just those areas you want to print and goto
<file<print area< set print area "Dee" wrote: I have a spreadsheet that when I go into print preview there are 59 pages. I did not create the spreadsheet. However, there is only something on 3 of those pages. How to I delete all of these extra pages. Thanks very much for any help. I am using Excel 2003 Dee |
#3
|
|||
|
|||
#1 - Select the range of cells you want to print, use the menu to choose
FilePrint AreaSet Print Area #2 - You may have extraneous info in cells (blanks, formulas that evaluate to "", etc) in cells outside your print area. see Debra Dalgleish's site http://www.contextures.com/xlfaqApp.html#Unused "Dee" wrote: I have a spreadsheet that when I go into print preview there are 59 pages. I did not create the spreadsheet. However, there is only something on 3 of those pages. How to I delete all of these extra pages. Thanks very much for any help. I am using Excel 2003 Dee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
How do I delete 2000 pages created by Excel from my one page doc. | Excel Worksheet Functions | |||
How do I delete extra blank pages at end of doc...only show when. | Excel Discussion (Misc queries) | |||
blank data field shows quote in formula, how to delete it? | Excel Discussion (Misc queries) | |||
How do I delete pages? | Excel Discussion (Misc queries) |