Results 1 to 3 of 3

Thread: Excel won't print all pages

  1. #1

    Default Excel won't print all pages

    I've never encountered this before. Let me preface that I am a 20+ year user of Excel. Currently using Excel 2007.

    I have 43 pages set up to print which encompasses 75 rows and 271 columns (I am using Page Break Preview when viewing the spreadsheet). Whenever I attempt to print, or review with Print Preview, only 37 pages are generated (through column #244).

    There is no print area defined (only print titles). Any ideas? Thanks.

  2. #2
    Board Regular bobsan42's Avatar
    Join Date
    Jul 2010
    Bulgaria, GMT+2 (42.891813,25.313594)

    Default Re: Excel won't print all pages

    try to define the print area.
    or give some more info or upload the file.
    "'s sad that in our blindness we gather thorns for flowers..."
    mostly using:
    windows 7 (64-bit) / excel 2013 (32-bit) / access 2013 (32-bit) / some imagination & Google of course
    You don't need to read between the lines - just read them all!

  3. #3

    Default Re: Excel won't print all pages

    I forgot to mention that I did define the print area, and I still got the same result.

    However, after looking to delete some columns - which still caused the number of pages to be short by 5 pages - I thought that the inverse may work. So I added the equivalent of 5 pages worth of columns at the end of the print area. This did the trick.

    I'm still scratching my head. The sheet is all data with very little formulas. A very simple sheet, albeit a large chunk of columns. I am unable to upload due to the sensitive nature of the data.

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