How to Change the Print Resolution in Excel 2010

The print resolution that is specified by a document or image on your computer can have a big impact on both the quality of the printed page, and the speed at which the print job completes. Higher dpi print jobs will generally take longer and use more ink than jobs performed at a low dpi, but higher dpi settings will provide a better looking print.

If you have specific printing needs for a worksheet in Microsoft Excel 2010, then you can modify the print resolution that is used for that specific worksheet. While the print quality options that are offered in Excel are based entirely on the capabilities of your printer, you may find that switching to a different dpi can improve some element of your Excel printing practices.

 

Adjusting the Print Resolution in an Excel 2010 Worksheet

Note that the print resolutions offered will vary, depending on your printer. Many printers will only have one option for print resolution, meaning that you will be unable to select another.

 

  • Step 1: Open the file containing the worksheet for which you wish to change the print resolution.
  •  

  • Step 2: Click the Page Layout tab at the top of the window.
  • click the page layout tab

     

     

  • Step 3: Click the Page Setup button at the bottom-right corner of the Page Setup section in the Office ribbon.
  • click the page setup button

     

     

  • Step 4: Confirm that the Page tab is selected at the top of the window, then click the drop-down menu to the right of Print quality, and select from the options listed. As mentioned previously, the options on this menu will vary based on your printer. Once you have selected the preferred resolution, click the OK button at the bottom of the window.

select the print quality

 

 

Are you having difficulty with the print formatting whenever you try and print a worksheet in Excel 2010? Our guide to Excel printing will point you to many of the most commonly adjusted setting that can make it easier for your audience to read a spreadsheet that you have printed.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.