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 - The Pocket Guide. Windows 7 is by far the most favorite and widely-used Microsoft operating system to date, and, there are literally thousands of customizations you can apply to it. This pocket guide will help you customize your Windows 7 PC and make it work in the easiest and most optimized way possible. The eBook is written in an easy to understand manner, whether you're a newbie or seasoned pro user. 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.