Change the print resolution or print quality for a worksheet

Using a high dots-per-inch (dpi) resolution for printing produces quality printing results, but it may take longer to print. You can change the resolution settings to a lower dpi setting, depending on the type of printer that you use. If the printer that you use supports draft quality printing, you can specify draft quality for faster printing instead.

What do you want to do?


Change the print resolution

  1. Click the worksheet for which you want to change the print resolution.
    1. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher Button image next to Page Setup.
      Excel Ribbon Image
    2. On the Page tab, in the Print quality box, click the resolution that you want to use.

 Note   The dpi settings that are available depend on the type of printer that you are using.

Top of Page Top of Page

Specify draft quality printing

  1. Click the worksheet that you want to print by using draft quality printing.
    1. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher Button image next to Page Setup.
      Excel Ribbon Image
    2. On the Sheet tab, under Print, select the Draft quality check box.

Top of Page Top of Page

 
 
Applies to:
Excel 2007