|
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: - Options.
- 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!
-- Related newsletter articles:
2004/10/14 Print web pages in black and white (not color)? (print)
2006/07/20 Print a Worksheet: MS Excel (print)
2007/02/16 Print a Word Form: MS Word (print)
2005/08/02 Print Folder (Files in Directory)? (print)
2006/07/13 MS Excel Security Leaks Becoming Flood (excel)
2005/12/15 Store and Restore Your System with a 'Gut Box' (box)
2005/04/21 How to Ensure your online Transactions are Secure (box)
2005/12/23 From your Friends at Google (box)
2005/07/29 Print MP3 Playlist? (print)
2007/02/13 New Excel Attack Threatens Office (excel)
2004/06/01 Freeware greeting card program?, Part 2 (print)
2007/05/15 3D Printers: The New Way to Download Gifts (printer)
2006/04/23 Can't Copy and Paste Text as Filename in MS Office? (box)
2004/11/10 Problems running DOS applications in Windows?, Part 2 (printer)
2007/06/26 Easy Access to Functions in MS Excel (excel)
2005/09/15 Can't print because QuickLink III isn't installed? (print)
2007/02/06 Vista Upgrade DVD Trick: Clean Install Vista Without Previous OS (box)
-- Recent articles (from all channels): 2008/05/12 Today in History: for Monday, May 12, 2008
2008/05/12 [ShellX 20080512]: 'Remote Manager', and 'Cyber Bandwidth ...
2008/05/12 Video Gaming Trade Group Struggling
2008/05/12 T-Mobile Finally Joins 3G Phone Race
2008/05/12 Apple Slammed by Environment Watchdog
2008/05/09 [ShellX 20080509]: 'Advanced Run', and 'Diver Windows Manager'
2008/05/09 Texas Refuses Facebook Friend Request
2008/05/09 Photo-Enforcement Technology Replaces Officers On Patrol
2008/05/09 Cuban Government Says 'Ok Computer'
2008/05/09 Excel Can E-Mail Your Weekly Reports For You!
2008/05/08 [ShellX 20080508]: 'Shell Enhancer', and 'Lansweeper'
2008/05/08 Xobni: MS Outlook Social Networking Technology for your Inbox
2008/05/08 Music Companies Jump on GTA IV Bandwagon
2008/05/08 Fascinating: Memristor to replace Binary
2008/05/08 Adobe Hopes To Make Flash Master Of The (Mobile) Universe
2008/05/08 Spiffy Envelopes and Labels in MS Word
2008/05/07 [ShellX 20080507]: 'Winbin2iso', and 'Loop Typer'
2008/05/07 Yahoo Adds Security Warnings To Search Results
2008/05/07 Apple to Lose Money on iTunes Movie Releases
2008/05/07 Amazon.com takes New York Tax to Court
2008/05/07 Need Glasses for the Slide Sorter View in MS PowerPoint?
2008/05/07 After Winning The DVD Format War, Blu-Ray Sales Tank
2008/05/06 [ShellX 20080506]: 'Visual Basic 6.0 Portable', and 'Double-...
2008/05/06 Yahoo Outsources to Jajah
2008/05/06 New HP Circuit Could Change Technology Forever
2008/05/06 Movie Downloads To Match DVD Release Dates
2008/05/06 Microsoft Ends Yahoo Bid
2008/05/05 [ShellX 20080505]: 'Ie7 Pro', and 'Desktop Ok'
2008/05/05 The WB Network Hops Online
2008/05/05 Microsoft Slashes Price of Xbox 360 Overseas
2008/05/05 Google CEO Wants YouTube to Take More of Your Money
|
