excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Family Tips
Gardening Tips
Home Tips
Money Tips

Newest Tips

Changing a Link's Source

Using Conditional Formatting to Shade Rows

Editing by Moving and Copying

Making Sure Duplicate Names Aren't Entered

Applying a Conditional Format to a Full Row

Hiding Worksheet Tabs

Making Cells Flash

 

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.

Related Tips:

Document and Annotate! One of the easily overlooked tools provided by Word is the ability to add footnotes and endnotes to your documents. WordTips: Footnotes and Endnotes is the definitive resource guide to using these tools to enhance your documents. Check out WordTips: Footnotes and Endnotes today!