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.

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 Launcher Button image .

      Page Setup Dialog Box Launcher
    2. On the Page tab, in the Print quality box, click the resolution that you want to use.

      Page Setup > Page options

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

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 Launcher Button image .

      Page Setup Dialog Box Launcher
    2. On the Sheet tab, under Print, select the Draft quality check box.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Print a worksheet or workbook

Printing in Excel

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×