Print Multiple Sheets on One Page in MS Excel
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.
- Choose Print from the File menu. Excel displays the Print dialog box.
- In the 'Print What' area of the dialog box, choose Entire Workbook.
- 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:
- Paper Set Up.
- Then select Make Post or Many Pages on a Sheet.
- Set the Pages Per Sheet drop-down list to 4.
- Click OK to close the Properties dialog box.
- 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!
Free eBook: Windows... On Speed. This 33 page guide will explain how to store your data to reduce disk fragmentation, how to properly remove programs to avoid registry junk, which system maintenance tools you should use to maintain a top notch performance, how to protect your system from malware attacks, and how to physically clean your machine to avoid hardware damage and failure. There's also a troubleshooting section for PCs already affected by deteriorating performance, and how to resolve it. Click here to download this eBook now! Note: this eBook is free, but registration is required; after that, you can select more ebooks and videos for download without registering again. If you have questions / problems with the registration form, please read this.