Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I delete extra blank pages at end of doc...only show when.
I have a price list that is 24 pages.. but when someone prints it there are
extra balnk pages at the end (total of 48 pages). What do I need to do to eliminate those blank pages? |
#2
|
|||
|
|||
It depends on where the extra blank sheets are coming from.
I assume (shudder) that the pages are co-linear either horizontally or vertically check <view<pagebreak preview You may have an extra column or row selected which doubles the print job. additonally there might be a character in one other cells ( I have had a period in the wrong cell double the print job.) "LV" wrote: I have a price list that is 24 pages.. but when someone prints it there are extra balnk pages at the end (total of 48 pages). What do I need to do to eliminate those blank pages? |
#3
|
|||
|
|||
Maybe resetting the lastused cell will help.
Visit Debra Dalgleish's site for some nice techniques: http://www.contextures.com/xlfaqApp.html#Unused LV wrote: I have a price list that is 24 pages.. but when someone prints it there are extra balnk pages at the end (total of 48 pages). What do I need to do to eliminate those blank pages? -- Dave Peterson |
#4
|
|||
|
|||
Thank you so much!! It was a graphic/picture that is part of our letter head
and when I set it up one of the points touched just on very outer edge of the last column thus causing the horizontal co-linear pages. I re-adjusted it and "poof" the extra pages were gone . Again, many thanks!!! "bj" wrote: It depends on where the extra blank sheets are coming from. I assume (shudder) that the pages are co-linear either horizontally or vertically check <view<pagebreak preview You may have an extra column or row selected which doubles the print job. additonally there might be a character in one other cells ( I have had a period in the wrong cell double the print job.) "LV" wrote: I have a price list that is 24 pages.. but when someone prints it there are extra balnk pages at the end (total of 48 pages). What do I need to do to eliminate those blank pages? |
#5
|
|||
|
|||
Thank you for your help and providing me with the link below. I have saved
it to my favorites. I want to again thank you for helping me to eliminate the problem. It turned out to be a graphic that one of the end points extended oover (just a hair) into the next column thus creating the extra pages. Many thanks!!! "Dave Peterson" wrote: Maybe resetting the lastused cell will help. Visit Debra Dalgleish's site for some nice techniques: http://www.contextures.com/xlfaqApp.html#Unused LV wrote: I have a price list that is 24 pages.. but when someone prints it there are extra balnk pages at the end (total of 48 pages). What do I need to do to eliminate those blank pages? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
blank data field shows quote in formula, how to delete it? | Excel Discussion (Misc queries) | |||
delete certain pages | New Users to Excel | |||
How do I delete blank rows at the bottom of a spreadsheet to get . | Excel Discussion (Misc queries) | |||
How do I delete pages? | Excel Discussion (Misc queries) | |||
Extra pages | New Users to Excel |