Problem sizing documents when printing from Excel

By dandowftm
Jan 16, 2008
Topic Status:
Not open for further replies.
  1. Hi all,

    I have a problem that is starting to annoy me as I cant seem to find a way around it.

    What i am doing is trying to print off a spreadsheet in excell but I am having to size it down so that it fits the page correctly, it should fit onto 2 pages but when i first look at the page break preview it shows 12 pages.

    So after moving these around so that they look correct i go into print preview and it shows everything correctly, but i want this spreadsheet to fit the whole page, not just occupy the left hand corner of it.

    I have tried everything i can think of, margins, print areas, allsorts but cannot get it to fit the whole page. i know it can be done too because someone else has done it without knowing how.

    Any help on this matter would be much appreciated.

    Cheers :)
  2. AlbertLionheart

    AlbertLionheart TechSpot Chancellor Posts: 2,711

    Sometimes the proportions of the page will change the print layout - have you tried setting the layout to landscape? Does that make a difference
  3. dandowftm

    dandowftm Newcomer, in training Topic Starter Posts: 16

    Sorry, forgot to mention that it is landscape i am trying to print to
  4. AlbertLionheart

    AlbertLionheart TechSpot Chancellor Posts: 2,711

    Then I am bereft of ideas! Sorry!
  5. jobeard

    jobeard TS Ambassador Posts: 13,285   +281

    be sure there are NO extra rows in the sheet AND no extra sheets.

    you may like to Define Print Area to force print only the selected area:

    1- select the top-left cell to be printed (like that in the heading or title row)
    scroll to the LAST ROW, scroll right to the LAST COLUMN and hold the shift key and click (you've selected the content desired).

    2- now use the File->Print Area->Set Area

    3- finally, File->Print as normal
  6. dandowftm

    dandowftm Newcomer, in training Topic Starter Posts: 16

    Yes, i have set the print area and everything else i could think of.
    the print areas look correct when i go into print preview but i want to stretch the spreadsheet to fit the full A3 page.
    Here,
    [​IMG]
    this might help you more, thats the print preview, and i want it to fit the pages width as it will be easier to read when printed, and i know it can be done
  7. AlbertLionheart

    AlbertLionheart TechSpot Chancellor Posts: 2,711

    Ahah! You want to print to A3 size paper on an A3 printer?
    Change the paper settings in Excel Print > Page Settings from A4 to A3.
    Don't forget to change it back again as this will change all.
  8. dandowftm

    dandowftm Newcomer, in training Topic Starter Posts: 16

    lol, its set to A3 already!
    I'm totally beaten now like
  9. jobeard

    jobeard TS Ambassador Posts: 13,285   +281

    are you printing to a printer that is DIRECTLY attached to your system or a
    printer that is shared elsewhere?
Topic Status:
Not open for further replies.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.