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

Specify draft quality printing

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

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

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language