How to Change Print Quality in Excel 2016

I wish I could work in Excel and not have to worry about printing. Between data being difficult to read, old print areas, and rows and columns that don’t fit on the page, there’s a lot that you might need to fix.

Spreadsheets are much easier to deal with on a computer (in my opinion), and the default settings in Excel aren’t ideal for the majority of the situations where I find myself printing in the program.

Unfortunately, spreadsheet printing is here to stay, so we need to look for ways to make printing a little simpler, as well as less taxing on printing resources like ink.

Excel 2016 has a setting that allows you to adjust the print quality of your spreadsheets. If you are printing very large, multiple-page sheets, then a lower quality can save you some ink or toner and, ultimately, some money.

Our guide below will show you how to adjust the print quality in Excel 2016.

How to Set the Print Quality for a Spreadsheet in Excel 2016

The steps in this article are going to change the quality of the spreadsheet when you print it. Lower quality will typically print faster and use less ink but may not look as good.

Depending upon your printing needs, it can often be a good idea to start with a lower-quality print setting and work up if needed.

Step 1: Open your spreadsheet in Excel 2016.

Step 2: Click the Page Layout tab at the top of the window.

click the page layout tab

Step 3: Click the small Page Setup button in the Page Setup section of the ribbon.

adjust excel print quality

Step 4: Click the Print quality dropdown menu and select the level of print quality that you would like to use. You can then click the OK button at the bottom of the window to save the setting.

how to change print quality excel 2016

Now that you know how to change the print quality in Excel 2016, you can adjust this option based on how good you need the quality of your printed spreadsheets to be in individual situations.

Are you having difficulty getting your spreadsheet to print the way that you want? There are a number of variables that can affect printing in Excel, and it can be frustrating trying to find all of the options that let you do what you need to do. Read our Excel printing guide for some tips that can make printing a more pleasant experience.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy