Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
LV
 
Posts: n/a
Default 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   Report Post  
bj
 
Posts: n/a
Default

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   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Lv
 
Posts: n/a
Default

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   Report Post  
Lv
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
blank data field shows quote in formula, how to delete it? wdanner Excel Discussion (Misc queries) 2 April 4th 05 08:44 PM
delete certain pages Lady Layla New Users to Excel 4 March 30th 05 04:29 PM
How do I delete blank rows at the bottom of a spreadsheet to get . Miklaurie Excel Discussion (Misc queries) 1 January 26th 05 03:30 PM
How do I delete pages? Sara Excel Discussion (Misc queries) 5 December 8th 04 02:25 AM
Extra pages Loi New Users to Excel 2 December 2nd 04 01:13 AM


All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"