Setting Print Quality

Summary: Excel can take advantage of different print quality settings that may be available in your printer driver. (This comes in handy when you want to print text in lower quality and charts in higher quality.) This tip explains how you can change the quality setting. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Many printers on the market these days provide a bevy of different features. It is not unusual, for instance, for printers to be able to print on different paper stocks, use different inks, and pull paper from different trays. Some printers even allow you to pick different levels of quality for output.

Print quality is often measured in DPI, or dots per inch. This is a measure of printer resolution and simply means the number of individual ink dots that a printer can produce within a linear inch. Some printer drivers used with Windows allow you to specify which resolution you want to use for a particular print job. If your printer allows you to adjust this setting, you can take advantage of it in Excel in this manner:

Choose the Page Setup option from the File menu. Excel displays the Page Setup dialog box.
Make sure the Page tab is selected. (Click here to see a related figure.)
Use the Print Quality drop-down list to select the resolution of print quality you want to use.
Click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2937) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Don't Go in Debt for Christmas! Tired of trying to keep up with the Joneses for Christmas? Want to enjoy the season rather than dread the aftermath? Learn how you can avoid the financial traps that spring up every Christmas.

Check out Top Fifteen Tips for Financing Christmas today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Setting Print Quality