Maybe you are not working with VBA in this case, but just letting you know, I think it’s a local system issue with printer types”. Here, we selected cells A1 through F13, held the Ctrl key, and then selected cells H1 through M13. To set multiple print areas in your sheet, hold Ctrl as you select each group of cells. Then, go to the Page Layout tab and click the Print Area drop-down arrow in the ribbon.
That was what I ran into, so I asked my client to record a macro of them printing on that size paper, they emailed me the code, and I was able to complete the macro at my desk by recording my print macro and plugging in their VBA paper size reference from the recorded code (it’s not always recorded as xlpaper11X17 or xlPaperTabloid, sometimes one or the other depending on Excel version), then sent them the finished workbook product. To set a single print area, select the cells. The selected cells will display a dark outline. Are you sure their printer can accommodate that size? Maybe you are designing the workbook for them but on your computer, your printer is not the type that handles that size paper. Click and drag the cursor to highlight those cells for the selected print area. If the printer cannot print it, you won’t see that size as an option in the settings. Those printer(s) (the default one or whichever you assign at the Control Panel level) must have the capability to print on that size paper. The issue is the printer(s) that are attached to the computer running the workbook.
I recently updated to Office365 and the same VBA script is now printing to PDF, but not scaling to fit all columns to a single page wide. When I print active worksheet, each print area stays on a separate page. For the past few years Ive used Office 2013, and with it, a particular VBA for Excel script which would print a worksheet to PDF, while scaling to fit all columns to a single page wide. If you see the print preview now, you will see only your selected area ready to print on your page.
From the dropdown menu that appears, select ‘Set Print Area’. Then, select Print Area from the Page Layout tab, under the ‘Page Setup’ group. “I ran into this before, with a client who only wanted that size paper, which in VBA code is referred to as xlPaper11x17 or xlPaperTabloid. For example I have set three print areas (A1:B9, E10:E14, and D21:G34) in one worksheet. For this, select the area that you want to print on one page. Can you help? I really need to be able to convert these documents on my laptop to Tabloid size layout and Print Preview them as such.
Plus, since it was a post from 2004 it may or may not be relevant.
I just found this on, but not sure how to do this or what a macro is.