+ Reply to Thread
Results 1 to 7 of 7

How to choose A3 size paper in excel

  1. #1
    Registered User
    Join Date
    05-04-2020
    Location
    Oxford
    MS-Off Ver
    16
    Posts
    6

    How to choose A3 size paper in excel

    Morning,

    I'm sure in previous versions of Excel you could choose A3 size paper from the dropdown box. In the current version I'm using this size isn't available. Does anyone know if this can be amended at all?

    TIA
    C.

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: How to choose A3 size paper in excel

    Try this and let me know if it works.

    Click on Print Preview
    Change your Printer to Microsoft XPS Document Writer.
    Click on Printer Properties.
    Click on Advanced.
    In Paper Size click on drop-down menu.
    Should see A3 there.

  3. #3
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: How to choose A3 size paper in excel

    Two different ways to do this.

    One is to create the Excel document as an A3 page(s):
    Page Layout Ribbon => Page Setup Tab => Size dropdown: select A3 from list
    *If this is not available, it means something screwy happened in your Options for your document, or your normal template.

    Two is to tell the printer to break up the spreadsheet onto A3 pages:
    File => Print => Page size (this may just display the size)
    *If you select a printer that does not have the capacity to print A3 sizes, then the printer usually won't show this option.
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  4. #4
    Registered User
    Join Date
    05-04-2020
    Location
    Oxford
    MS-Off Ver
    16
    Posts
    6

    Re: How to choose A3 size paper in excel

    Hi mikeava

    It worked until, I tried to print and then when I chose my printer I lost the A3 option?

    Thanks
    C
    Last edited by Nocturnal Wolf; 06-03-2020 at 04:11 AM. Reason: Spelling error

  5. #5
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: How to choose A3 size paper in excel

    What make & model is your printer ?

  6. #6
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: How to choose A3 size paper in excel

    Sorry something came up, couldn't respond right away. It won't print using the Microsoft XPS Document Writer?

  7. #7
    Registered User
    Join Date
    06-02-2020
    Location
    London
    MS-Off Ver
    365
    Posts
    51

    Re: How to choose A3 size paper in excel

    That would suggest that your printer doesn't support A3 paper (or at least the driver is telling Excel that it doesnt).

    Does it support/have A3 paper? Do you have the same issue with Word or other applications? As already asked, what is the make/model of the printer?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. size paper excel
    By max_max in forum Excel General
    Replies: 1
    Last Post: 12-11-2015, 06:29 PM
  2. Troubleshoot Paper Size in Excel
    By Nancy Babbitt in forum Excel General
    Replies: 3
    Last Post: 08-05-2006, 01:55 PM
  3. [SOLVED] Can Excel print onto a 11-17 inch paper size?
    By Keith2000 in forum Excel General
    Replies: 1
    Last Post: 07-09-2005, 02:05 AM
  4. Replies: 2
    Last Post: 03-09-2005, 07:06 PM
  5. How do you set a custom paper size in Excel?
    By Bambi41 in forum Excel General
    Replies: 1
    Last Post: 01-24-2005, 11:06 PM
  6. [SOLVED] SPECIFY REQUIRED PAPER SIZE IN EXCEL 2000
    By Augustine in forum Excel General
    Replies: 0
    Last Post: 01-17-2005, 09:06 AM
  7. SPECIFY REQUIRED PAPER SIZE IN EXCEL 2000
    By T S Augustine in forum Excel General
    Replies: 0
    Last Post: 01-17-2005, 09:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1