HOW DO I GET RID OF BLANK PAGES?

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: HOW DO I GET RID OF BLANK PAGES?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a workbook with 7 pages of info. When I use Print Preview it shows 14 pages, the last 7 of which have no data on them. When I use Page Break Preview, it shows only 7 pages. How do I get rid of the 7 blank pages so when I print I do not waste paper (7 extra pages with just the header/footer)? Any help is greatly appreciated.

  2. #2
    New Member
    Join Date
    May 2002
    Location
    Netherlands
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It seems like you may have pages indicated after page #7. Go to 'view' then 'page break preview', scroll to the bottom of the last page and try pulling down the page seperator, you'll probably find that there are more pages there, just delete them.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    suggest using page break view and zoom to smaller size say 50 % easier to see see if you have any data in the odd 7 pages if not delete them


    if you have not see this before the blue lines outline each page

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi Slangbert,

    You may want >File>Page Setup>Sheet and see
    what is in the "Print Area"

    James

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com