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 or get support in the Answers community.

See Also

Print a worksheet or workbook

Printing in Excel

Need more help?

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

Was this information helpful?

×