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

Organize Your Data! Using the powerful sorting capabilities of Excel can help you get your data into just the order you need. Find out how you can use the full capabilities of sorting to your benefit.

Check out ExcelTips: Serioius Sorting today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Setting Print Quality