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.
Step 3: Click the small Page Setup button in the Page Setup section of the ribbon.
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.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.