ss

Change the print resolution or print quality for a worksheet

Applies To: Excel 2007

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.
2. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher 
3.  next to Page Setup.

1. 
   
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.
2. On the Page Layout tab, in the Page Setup group, click the Dialog Box Launcher 
3.  next to Page Setup.

1. 
   
2. On the Sheet tab, under Print, select the Draft quality check box.

Top of Page