• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

hot off the press (selecting correct paper size)

Lawrence Dodge

Lawrence Dodge

Member
Hi all --
I have a large spreadsheet that I print out on a ledger 11 x17 size paper and for some reason, Excel has decided to get rid of this size paper in printer setup. I made sure to have the paper loaded but it either doesn't give me that size for a choice or it prints a forth of the worksheet on four different sheets. I even tried creating a new worksheet and still can't get 11x17, is there a way to manually enter this paper size?
thank you much
Lawrence
 
Hi Hui --
Thanks for getting back to me so quickly. I understand it is called Tabloid (or sometimes I have seen it called Ledger), the problem is Excel is not even giving me that option on the drop down at all. I changed printers and then found it on the drop down, but when I printed the sheet it blew up everything so it took 4 ledger sheets instead of the one that it should be. If I set page size to 1 sheet wide, it prints on one sheet but the print is micro. Any thoughts?
 
Also check that the printer you have as default supports that page size.
If Not add that page size to your printer
Goto Start
Devices & Printers
Right Click on your Printer, Printing Preferences
Add a Custom page size
 
Here is my Excel 2013 under Win 7
It looks like Ledger is a landscape version of Tabloid

Capture.png
 
I went to devices and printers, etc but there was no way to add a paper size. I really am starting to believe this is a printer issue more than an Excel issue. I am going to my spreadsheet to PDF, then print so them so my sizes don't get all goofed up. thanks for your help
 
Are you on a Business PC or Home
As it sounds like you have access restrictions

If So ask your Administrator to give you access to your printers or at least add the paper sizes you need
 
our printer is a Sharp UD PCL6 and when I go to the drop down you indicated I get "letter", "legal" and "More Paper Sizes", when I click that I get this menu which even going through all the tabs doesn't let me choose a custom sizeupload_2015-2-27_9-11-39.png
 
Your on a managed system and will need to get an administrator to change your paper sizes.
 
You must log in or register to reply here.
Back
Top