Setting Print Quality

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:

  1. Display the Page Layout tab of the ribbon.
  2. Click the small icon at the bottom-right corner of the Page Setup group. Excel displays the Page Setup dialog box.
  3. Make sure the Page tab is selected. (See Figure 1.)
  4. Figure 1. The Page tab of the Page Setup dialog box.

  5. Use the Print Quality drop-down list to select the resolution of print quality you want to use.
  6. Click on OK.