Comments on: How to make Excel print gridlines

One of the most common complaints about gridlines is that they are not printed by default. In this article you’ll learn how to print gridlines in Excel and get these faint lines brighter on a hard copy by changing the default gridline color. Continue reading →

Table of contents

Comments page 2. Total comments: 43

  1. Thank you! Fixed my issue in a flash!

  2. After following every instruction listed, sheet 2 is still not printing gridlines. Frustrating.

  3. Selecting Print Grid Lines under Page Layout, I am getting lines for each row in Print Preview, however when printing the copy the grid lines encompass two or sometimes more rows. How to line each and every row?

  4. All of the tips on this page are excellent and are likely to be helpful to many. However, despite my having all the settings described above to PRINT gridlines (I have Excel 2010; Win 7), SOMETIMES my gridlines (and borders and underlines) do not print even though they show in Print Preview. (There is nothing systematic that I could detect about when this would happen.) What fixes the problem for me is saving the file, closing it, then opening it again. (Just saving is not sufficient.) Everything prints fine from that point on, even after closing the file and opening it again later, in other words, it is a permanent fix for that file. I don't understand why this works for me, it just does. By the way, I use an old HP1100 LaserJet printer. I saw some other webpages about this problem, and they mentioned the issue might be with the age of the printer or the printer driver. My driver is the one recommended by HP for Win 7.

    1. Larry! I tried all of the other suggestions, but none worked until I closed and reopened as you suggested. Thank you!

  5. I'm using Excel 2013.

  6. I do not want gridlines all over the sheet, so I use Format to put in the gridlines where I want them and how thick. They show up in the "Print Preview" mode, but fail to print.
    I have an HP 6525e All-In-One printer.

  7. gridlines show in print preview, but only row grid lines and 3 of the 10 column grid lines print. I have tried all the suggestions listed here. Anything else I Angry?

    1. Marcia,

      Please try to print another workbook. If the issue is reproduced, the problem is in your printer. If it is printed well, then the problem is in the particular workbook. Without seeing it we can’t assist you better.

  8. your instructions was the best. I worked two days on other sites and still couldn't print blank with grid lines. I followed your instructions and it worked fine. I thank you so much. That was a big help. I have windows 7 and new HP 8610 printer.

  9. Hoorah for Josh at HP Support. I'm running Windows 7 with Excel 2007 using a new HP ENVY 5530 printer. It was not printing all the gridlines. Bottom line results from Josh -- new printers cannot always understand older software such as Excel 2007. Another printer was added to my computer (HP Deskjet 6800 was chosen by Josh using the IP address of my printer). It is using the language of the Deskjet printer to translate and print to my ENVY 5530. It is now printing ALL gridlines. Hope this helps to solve some problems.

  10. I just figured out the easy way to get the gridlines to print. Go to your spreadsheet Home, select Page Layout, Select Margins, Select Custom Margins. Go to Options, then Printing Shortcut, Print Quality and Select "Best". It may take longer for the document to print, but you get the gridlines.

  11. I have the opposite problem. I have random gridlines printing in worksheets and all options for printing gridlines are not selected to print. Ideas?

    1. Hello Kimmer,

      There may be some custom border applied to your table.
      Just select the range where the issue occurs (the entire worksheet) and press Ctrl + 1. Move to the "Border" tab and click on the "None" icon, then press OK.
      Hope this will help.

  12. Spent half the night trying to get gridlines to print, including following several suggestions from other sites....but none mentioned setting the print area. As all the cells are empty in what I was trying to print, nothing else worked. Thanks for making my day.

  13. This is the most detailed list of applicable settings I've ever seen; other sources cover most of them but I've never seen the gridline color option before. That's a great tip in itself, even if you're having no printing problems.

    Unfortunately, there is a well-documented problem affecting at least Excel 2010 on Windows 7 in which gridlines still won't print even when you've taken all of these steps. It seems to involve printer drivers, so is outside the control of anything you do in Excel.

  14. But the problem is I almost never print any spreadsheet without gridlines. So I use the default setting 5% of the time and have to manually override it 95% of the time. That doesn't make a lot of sense.

  15. Yet another glowing thank you for an easy explanation and solution

  16. Thank you,

    but how do you get all your new sheets to have the same gridline colour instead of the non-existent white?

  17. How can I change Excel so gridlines default to being printed?

  18. As with other commenter, your solution worked for me for showing gridlines. Thank you very much.

  19. THANK YOU,THIS WAS THE BEST INCLUSIVE INFO. I FOUND AFTER VIEWING 7 OR 8 OTHER SITES. MOST OF THE OTHERS ONLY WENT AS FAR AS "PAGE LAYOUT/PRINT GRID LINES." I HAD ALREADY GONE THAT FAR AND STILL WAS NOT GETTING WHAT I NEEDED. SO YOUR DIRECTION TO GO TO ADVANCED OPTIONS DID THE TRICK.

    THANK YOU AGAIN
    SHERYL JORDAN

    1. Thank you so much for your kind words, Sheryl. I am glad that the steps in my article helped you to solve the task. I really appreciate your feedback.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)