Print Large Size Excel Sheets Wall Size

When using excel if the page break size is altered to modify the print area on exporting the spreadsheet to pdf the resulting page size may differ than what is set in the original document.

Print large size excel sheets wall size.

When you create a publication for example banners and select a size larger than 8 5 by 11 inches in page setup publisher prints a publication that is larger than a single sheet of paper in publisher you can print publications as large as 240 by 240 inches. When i send an excel document to the printer the font size is much smaller than it is in the electronic document on my screen. One of the important things of working with large worksheets is the possibility to switch between presentations of results only and all intermediate data. 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.

If your office has an option to print in a larger page choose a page size like tabloid ledger or a3. In the worksheet click file print. Under settings click custom scaling custom scaling options. They are larger pages.

I have fit to page selected as well as 1 page wide to 1 page long selected. So if your data has more columns than usual then use a large size page for example tabloid has 11 by 17 size. Click page and in the adjust to box pick a percentage by which you want to increase or decrease the font size. I want it to print it all on one page.

Cause the problem is that when a postscript printer is selected as the default printer for excel the application does not scale the sheet size. Keep in mind however that the printout may be difficult to read because excel shrinks the data to fit. How to print a large excel spreadsheet. In the scale to fit group in the width box select 1 page and in the height box select automatic columns will now appear on one page but the rows may extend to more than one page.

Review your changes in print preview and if you want a different font size repeat the steps. I have tried more than one printer so i am ruling out any driver issues. The font should be size 12 but looks to be printing in size 9. On the right side you ll get a preview of your wall art with dimensions on how big the poster size will turn out as well as how many sheets of paper will be used.

I am on office 365 on a mac. Any help would be much appreciated. Before you click print check the paper size setting in the printer properties. You ll use the output size section to customize the overall size of the wall art by changing how many sheets wide or tall to print.

Several types of page sizes are available for printing your excel worksheet.