bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Printing > Printing More Than One Copy

Printing More Than One Copy

Summary: When it comes time to print your worksheet, you may need more than one copy. If you use the Print tool, you値l only get one; to get more than one you値l need to use the Print dialog box, as described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Excel gives you complete control over how it prints your worksheets. If desired, you can print more than one copy of your information. To print multiple copies, follow these steps:

  1. Choose Print from the File menu. Excel displays the Print dialog box. (Click here to see a related figure.)
  2. In the Number of Copies box, indicate the number of copies you want to print.
  3. In the Print Range and Print What areas of the dialog box, specify what you want to print.
  4. Check the status of the Collate option.
  5. Click on OK.

Tip #3236 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates.
 
Check out Timesheet Templates today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)