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: The Windows 7 Guide: From Newbies to Pros. In this 46 page guide you will be introduced to Windows 7 and what it has to offer. It will teach you about the new taskbar, how to resolve software compatibility issues, how to customize Windows Aero, and explain what the Windows 7 Libraries are all about. Also included: a detailed list of what software is included in Windows 7, and how easy networking is with Windows 7 along with other topics. The advice within this guide will help new users become acquainted with Windows 7 and can also help those who are on the fence about purchasing Windows 7 decide if it would be a good idea. 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.