Make Excel 2007 Print Gridlines In Workbook File
By Default Excel does not print out gridlines with your Excel data. Here is how to make Excel print out the gridlines for easier document readability.
When you are ready to print out the Excel document click Page Layout tab on the Ribbon, then click on Page Setup
In the Page Setup dialog box click on the Sheet tab. Place a checkmark next to Gridlines and click OK. When you print your document you will now have the gridlines appear with your data!
This article was originally written on 06/24/07
Daily Email Updates
You can get our how-to articles in your inbox each day for free. Just enter your name and email below:
I have followed the instructions on how to print the gridlines on a Excel worksheet and I still can’t get them to print…any other suggestions??
Thanks
i want to learn about computers and want for self study i have no knowledge about it and itss the business of my husband can you help me please i want to help him in his business
Virginia,
This site is probably the best place you can come for tutorials on whatever you need to do. If you have specific questions you can always use our forum. Or simply email myself or The Geek!
Same problem here, I followed the instructions and could not get the gridlines to print in excel 2003 and also now in office 2007. Very frustrating, can anyone help?
Go to the “Home” tab at the top left.In the “Font” field, under the font size, there’s a box icon divided into four squares, hover your mouse over i and it will say “All Borders”. Clicking it will print all your grid lines.
Cool, thanks for the help everybody!
Brad ,I tried that way and it did not print with gridline,so I went on page setup and check marked the gridlines and it worked,Thanks a lot.
My girlfriend is having a problem with the gridlines not printing. she followed all of these steps, which worked if you create a new document in excel 2007 but will not print grid lines if she opens a file that was previously saved in excel 2003.
help would be appreciated.
Excel 2007 will not print or print preview the gridlines if you have “Draft quality” checked on the Sheet tab of Page Setup.
Thanks for that tip Pete. I was helping a user with a no gridlines printing issue and ran into a brick wall trying to resolve it. Your tip did the trick.
None of that worked until I also set my print area to include the whole page, duh. So, maybe some other user will forget to do that too first thing… SO
1) SET YOUR PRINT AREA
2) USE THE REST OF THE TIPS ON THIS PAGE
Cheers
Brad
Thanks for the help but I am frustrated that I can’t find a “Home”tab at the top left. Top left of what? Sorry to be so dumb
See above
Alan again. Here’s a 99% solution. File/Page Set Up/ Tick gridlines/OK then put some characters in the bottom right cell (above the page break) and print
Make sure you DO NOT have the “Draft Quality” check-box checked on the print setup screen–if you do, the gridlines will not print.
Is there any way to have the grid lines print out solid as opposed to the “dots” There doesn’t seem to be a choice with excel
How do you print gridlines on just part of a sheet? Say for instance, you want a narrative paragraph up above, and your tabular infor with gridlines only below? What then?
I have downloaded an excel workbook from my boss’s computer which had 2003. I need to print the payroll report in landscape at a reduced print size. My computer will not print landscape but her computer will print the same report off my computer in the landscape form. I have chatted on line with HP help and they told me to uninstall my printer software and reinstall. I did and it printed one page correctly but not any more. When you look at the print preview it shows ok but still won’t print correctly. Can anyone help
I am having the same problem as Sharon had back in December – it’s driving me insane? Print preview will show the landscape layout but even though I change to landscape, set print area and then save, it just goes back to portrait? Thanks for any help anyone may be able to give!
Thanks to Pete for his suggestion. I had done all the other things suggested, but if you leave draft quality ticked, it will not print out the gridlines – not something I would ever have thought of so thanks again
I tried all those things and it still doesn’t print out the gridlines. All the print gridlines boxes are checked, just changed the print quality from draft to presentation (also tried other options), clicked home tab and clicked all borders, and set the print area. Color is set to automatic. What else am I missing?
I am trying to print Excel Spreadsheet with gridlines in Landscape format. All it prints is 1 column down one side in Portrait format. Help please.