Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Oct 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reformat Excel spreadsheet to fit a particular siz (XP SP-1)

    Hello,

    I made an Excel File which looks ok on the screen.
    Now I want to reformat it for 2 sizes: A4 and A3.

    In both cases it must fit nicely within the page margins.

    What is the quickest & best way to go about this?

    Help!!!

    TIA.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Reformat Excel spreadsheet to fit a particular siz (XP SP-1)

    Do you want to fit more rows/columns on the A3 page, or do you want to blow up the A4 version to A3?

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Reformat Excel spreadsheet to fit a particular siz (XP SP-1)

    Hi,

    Since an A4 page's dimensions are the same as an A3's times the square root of two (rougly 71% - or 141% going the other way), you have two readily-available options, neither of which involve any reformatting of the worksheet, per se, both of which involve a simple adjustment in File|Page Setup|Page:

    1. If the document is already formatted for A4, set the 'Adjust to' factor to 141% (you might want to increase the page margins by the same factor); and
    2. If the document is already formatted for A3, set the 'Adjust to' factor to 71% (you might need to decrease the page margins by the same factor). Alternatively, you might be able to get by with doing no more than setting the 'Fit to' size to 1 page wide by 1 page tall.

    How easy is that!

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    2 Star Lounger
    Join Date
    Oct 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reformat Excel spreadsheet to fit a particular siz (XP SP-1)

    Hello,

    Thanks v. much.

    I have made the doc. to A3 ('cause it has a lot of content) and am now trying to make an A4 version for a colleague who only has an A4 printer.

    Tried the "'Fit to' size to 1 page wide by 1 page tall" option & it seems to work wonders.

    Seems to actually SCALE the content to fit the page.

    Thanks fellow WOPRs - you guys are doing a great job.

Posting Permissions

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