Results 1 to 4 of 4

HOW DO I GET RID OF BLANK PAGES?

This is a discussion on HOW DO I GET RID OF BLANK PAGES? within the Excel Questions forums, part of the Question Forums category; I have a workbook with 7 pages of info. When I use Print Preview it shows 14 pages, the last ...

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    7

    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

    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,140

    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

    Default

    Hi Slangbert,

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

    James

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