bottom
Excel 2007 Tips!
     
Your e-mail address is safe!
Close Note
excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Bugs and Pests Tips
Excel2007 Tips
Home Tips
Word2007 Tips

Newest Tips

Negative Elapsed Times

Specifying the Number of MRU Files

Changing Data Series Ordering

Seeing How Excel Evaluates Formulas

Highlighting a Cell if It Contains Specific Text

Filling Shapes with Pictures

Creating a List of Worksheet Formulas

 

Printing a Worksheet Draft

Summary: Do you want the absolute fastest print speed possible for a worksheet? Then you need to print a worksheet draft.

Excel allows you to print drafts of your worksheets. This can be very helpful in speeding up the printing process. When printing drafts, Excel doesn't include graphics or graphic-related items (such as gridlines) in the printed output. Instead, all you see is the text or numbers that make up your worksheet. To print a draft, follow these steps:

  1. Choose the Page Layout tab on the Ribbon.
  2. Click the small Page Setup icon at the bottom-right of the Page Setup group. You will see the Page Setup dialog box.
  3. Make sure the Sheet tab is selected. (Click here to see a related figure.)
  4. In the Print area of the dialog box, click on the Draft Quality check box. If the check box is selected, Excel will print drafts of whatever is printed.
  5. Click on OK.

Remember that the exact way in which draft printing is implemented is, in large part, up to your printer. Don't be surprised if you get different results doing a draft print on one printer as compared to another.