Printing a large Excel Spreadsheet to a plotter

Question

I am trying to print a large Excel Spreadsheet to a plotter. I am on Office 365 on a Mac.  

I want it to print it all on one page. I have fit to page selected as well as 1-page wide to 1-page long selected. When I select my custom page size in my printer dialog, and select "Fit to Page" It does not scale it to fit the entire page. I do not have the option to scale this sheet. If I had this option, I would scale to 400% or whatever necessary? How can I add this?

If not this how can I create a custom size page in Excel. They only have a handful of stock sizes and none meet my needs. The page Setup dialog has no options for custom page size either.

Answer 1

Don't take this as gospel, But I believe the maximum print size for a document regardless of Printer is 22" by 22"

Also, do you have the plotter selected in the Page Setup? If you have in Printer Setup "Any Printer" then in all likelihood that is the reason you can't set up to print correctly. 

_________

Disclaimer:

The questions, discussions, opinions, replies & answers I create, are solely mine and mine alone and do not reflect upon my position as a Community Moderator.

Answer 2

Hi Tiffany,

Have you referred to the information Phillip provided?

Regards,

Sheen

Answer 3

Hi Philip,

Thanks for the info about the 22"x22" page max. I did select the plotter in the page setup and I selected the paper see I wanted. The problem Excel has that other programs don't is if I were to select a page size larger than the document I created in Excel, I can fit-to-page in the the print queue regardless of the original size. Excel on my Mac doesn't give me the option to increase/decrease by percentage.

Answer 4

Please disregard the reference to a 22x22 limit - that pertains only to Word documents. Excel will handle just about any Paper Size your output device is capable of throwing at it :-)

See if it helps to set the Scaling percentage in File> Page Setup (or use the corresponding button on the Page Layout tab of the Ribbon) before going to the Print dialog. Do not use Scale to Fit in the Print dialog, which [IMHO] would better be named Shrink to Fit.

Answer 5

So, I played around with the scaling and saw that by scaling to 20%, it increased my print area. Not sure how it works, but the smaller the percentage, the bigger the print area, and visa versa.

When I hit print and change the paper size in the print dialog box, it will not expand the job to the entire sheet. (see the tiny image in the top left corner). It doesn't make a difference if I hit fit to page or not.

 

Note that if I change the percentage to anything larger than 20% it splits the table into multiple pages.