Print Multiple Sheets on One Page in MS Excel

Dennis Faas's picture

If you ever have the need or desire to print several worksheets on one page in MS Excel, you can do it. Just follow the steps below.

  1. Choose Print from the File menu. Excel displays the Print dialog box.
     
  2. In the 'Print What' area of the dialog box, choose Entire Workbook.
     
  3. Click the Properties button. Excel displays the Properties dialog box for the printer.

All printers are different so you will have to poke around a bit in your printer's properties to find the right place.

With my printer, I select:

  1. Options.
     
  2. Paper Set Up.
     
  3. Then select Make Post or Many Pages on a Sheet.
     
  4. Set the Pages Per Sheet drop-down list to 4.
     
  5. Click OK to close the Properties dialog box.
     
  6. Click OK to actually print the worksheets.

Your printer may offer a similar capability to what is outlined here, but you may need to do some exploring through the printer's 'Properties' dialog box to find it.

Of course, printing in this manner can lead to some very small text on the printout, because the printer driver simply reduces each page to occupy a proportionate area of the printed page.

When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!

Rate this article: 
Average: 1.4 (17 votes)