

We do our printing at Officeworks - which is pretty much the only nation-wide printing / finishing / stationary / office furniture and equipment / etc company Australia has for small and medium businesses… They gave me the same answer as the few alternatives I could find online… Make it 4 x A6 per page and they’ll print it. The problem is, I have since discovered that printing A6 is a rather niche thing and everywhere I have asked about printing A6, has told me / said that I will need to put 4 x A6 documents on a single A4 document. Each document must be no bigger than A6, not even by a little bit. Step 2: Click the File tab at the top-left corner of the window.So I have a whole heap of (separate) documents that I need to print in “A6” size… Some need to be in “landscape” orientation, others need to be in “portrait” orientation. If you need to adjust additional print settings for your spreadsheet, you can click here to read a guide with additional settings.

Note that all of the worksheets that you are trying to print must be part of the same Excel workbook. The steps in this article will show you how to change the printing settings in Excel 2013 to allow for the printing of multiple worksheets within a workbook on one page. How to Print Multiple Worksheets on a Single Page in Excel 2013 (Guide with Pictures) Our article continues below with additional information on printing more than one spreadsheet on a page in Excel, including pictures of these steps.

You may often be able to set or clear print areas to manage the data that you print, but another way to reduce the amount of paper in this situation is to print multiple worksheets on one page. But you might find that you need to print all of the worksheets within a workbook, and that each of those sheets only contains a small amount of data. This is usually because there is a row or column that won’t fit on one page, causing an extra (sometimes multiple extra) page(s) to print. Printed Excel spreadsheets often waste a lot of paper. But if your needs require you to include more than one worksheet on a page when printing in Excel, then you may be wondering if there’s an option in the application to accomplish this. Each worksheet in your Excel file might include important information that you need to print. A Microsoft Excel workbook can frequently include a number of different tabs called worksheets.
