Excel Not Printing Gridlines: Here’s Why & How to Fix It

If Excel is only printing some gridlines you should probably update your printer drivers 🖨️

by Matthew Adams
Matthew Adams
Matthew Adams
Windows & Software Expert
Matthew is a freelancer who has produced a variety of articles on various topics related to technology. His main focus is the Windows OS and all the things... read more
Affiliate Disclosure
  • It’s annoying when Excel spreadsheet gridlines cannot be printed. Well, you need to take action.
  • In order to solve the problem, remember that it’s essential to have your drivers properly updated.
  • Another possible fix would be to check the gridlines option to be selected in your sheets.
  • Lastly, you will find more practical and easy-to-follow solutions within this guide.
Excel spreadsheet gridlines don’t print issues
A message from our partner

To fix Windows PC system issues, you will need a dedicated tool

  • Download Fortect and install it on your PC
  • Start the tool's scanning process to look for corrupt files that are the source of your problem
  • Right-click on Start Repair so the tool can start the fixing algorithm
Download from Fortect.com Fortect has been downloaded by 0 readers this month, rated 4.4 on TrustPilot

Some Excel users need to print their spreadsheets with gridlines. Then the printed output will include cell gridlines along with their values.

However, some users have said in MS support forum posts that their printers don’t print the gridlines in their Excel sheets.

One user added that:

Borders were printing last week on older version of Excel. With 2010, gridlines and borders are not printing.

How do I make Excel spreadsheet gridlines print again?

In this article

1. Make sure the Print gridlines option is selected

  1. Check that the Print gridlines option is selected in Excel.
  2. Click the Page Layout tab shown directly below.
  3. Select the Print check box under Gridlines.
The Print check box excel spreadsheet borders and gridlines not printing

2. Reduce the scale to 99 percent

  1. At first, select the Page Layout tab.
  2. Click inside the Scale box shown directly below.Scale box excel spreadsheet borders and gridlines not printing
  3. Enter 99 in the Scale box, and press the Return button.
  4. Then try printing the spreadsheet again.

3. Deselect the Draft quality option

  1. Select Excel’s Page Layout tab.
  2. Then, click the Page Setup button shown in the snapshot directly below.Page Setup button excel spreadsheet borders and gridlines not printing
  3. Click the Sheet tab on the Page Setup window.Page Setup window excel spreadsheet borders and gridlines not printing
  4. Deselect the Draft quality check box.
  5. Select the OK option.

4. Update the printer’s driver

You’ve heard that it’s essential to have your drivers properly updated. Outdated driver versions often lead to major stability problems, so make sure this isn’t your case as well.

How we test, review and rate?

We have worked for the past 6 months on building a new review system on how we produce content. Using it, we have subsequently redone most of our articles to provide actual hands-on expertise on the guides we made.

For more details you can read how we test, review, and rate at WindowsReport.

When you first plug in a device, Windows will often install its own generic version of the driver itself, and the devices should get basic functionality from the start.

However, you want more than that for your printer. Manually looking for the right drivers is a challenging task. Avoid it from the start by downloading and installing Outbyte Driver Updater.

This tool gives you the chance to instantly update all your drivers with a few clicks and get back to printing in no time.

No less important, before you go obsessing about keeping your drivers up to date, start using this tool to schedule driver scans. Isn’t it easier this way?

Additionally, the software helps you to automatically update old drivers individually or at one go. Plus, you will handle corrupted or missing drivers more easily with automated support at any time.

Then, using specialized aid from this program is way better than doing it manually, plus you can optimize your PC performance by properly resolving driver issues.

Get Outbyte Driver Updater

5. Select the best print quality

  1. Select the File tab.
  2. Click Print on the left of the tab.
  3. Click Printer Properties to open a window like the one shown directly below.printer properties window excel spreadsheet borders and gridlines not printing
  4. Select the tab that includes a print quality option like the one shown directly below.
    • The tab that includes that option varies between printer properties windows.Print quality settings excel spreadsheet borders and gridlines not printing
  5. Click Best if Standard is selected.

6. Select Print to PDF

  1. First of all, click the File tab.
  2. Click Print to open the options shown directly below.Excel's print options excel spreadsheet borders and gridlines not printing
  3. Select Print to PDF on the printer drop-down menu.Print to PDF option excel spreadsheet borders and gridlines not printing
  4. Click the Print button.
  5. A Save Print Output window will then open. Enter a title for the PDF file in the text box.
  6. Click the Save button.
  7. Open the spreadsheet’s Portable Document File in Adobe Reader or other alternative PDF software.
  8. Print the spreadsheet from the PDF software.

Those are some of the resolutions that can fix Excel spreadsheets’ gridlines not printing.

Remember that you can also open and print Excel spreadsheets within alternative freeware spreadsheet applications like LibreOffice Calc. A spreadsheet’s gridlines might print fine when you utilize Calc.

Which one of these fixes did the trick for you? Let us know by leaving us a message in the comments section below.

This article covers:Topics: