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!
Mysticgeek is the resident IT expert at How-To Geek and a huge rock music fan. When he's not writing about Microsoft Office, he's probably writing at his personal blog. This article was written on 06/24/07 and tagged with: Microsoft Office
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.