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 7: Tips & Tricks. This eBook is for users that want to go one step further in their understanding of the Windows 7 operating system. With over 50 of the finest tips and tricks, this 113 page Windows 7 eBook features a plethora of screenshots, and was written especially for novices in mind. Also included is a bonus section for Windows 7 applications. Written and presented by technology enthusiast Vasu Jain. About the author: Vasu Jain is a software developer, web engineer, blogger, and Master's student at University of Southern California. He has written 2 other eBooks, including Office 2010 Tips & Tricks, and Developing apps for Windows 8. 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.