A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I delete extra blank pages at end of doc...only show when.



 
 
Thread Tools Display Modes
  #1  
Old April 14th, 2005, 04:23 PM
LV
external usenet poster
 
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  
Old April 14th, 2005, 04:43 PM
bj
external usenet poster
 
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 viewpagebreak 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  
Old April 14th, 2005, 09:08 PM
Dave Peterson
external usenet poster
 
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  
Old April 20th, 2005, 04:49 PM
Lv
external usenet poster
 
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 viewpagebreak 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  
Old April 20th, 2005, 05:13 PM
Lv
external usenet poster
 
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i delete a extra blank page in my Word document. It keeps . Waterinstructor1 Page Layout 4 January 12th, 2005 12:16 AM
Contiguous cells are blank - Delete Howard General Discussion 2 October 11th, 2004 10:41 PM
cant delete pages alockshin Formatting Long Documents 1 June 7th, 2004 10:04 AM
Word 2000 Merge and Duplex - Need to add blank pages when needed Anne-Marie Norman via AdminLife Mailmerge 1 June 5th, 2004 11:25 PM


All times are GMT +1. The time now is 10:37 AM.


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