Print gridlines in Microsoft Excel

Who doesn’t love Excel?  On top of all of the great things it can do, it does a heck of a job of looking neat and organized.  While you can create gridlines of certain styles and thicknesses around each cell, sometimes the standard thin-gray ones do the trick.  But by default, these aren’t printed on the spreadsheet.  How do you get excel to print these?

To print gridlines in Excel 2007:

1. Go to the page layout tab at the top of the window
2. Click the “expand” icon to the right of the “Page Setup” group heading.  This will bring up the page setup window.
3. Click the sheet tab
4. Place a check next to “Gridlines” in the print section and click Ok.
5. Alternatively, within the page layout tab, you can check the “Print” box under Gridlines in the Sheet Options group.

In all other versions of Excel:

1. Go to File -> Page Setup
2. Click the sheet tab
3. Check the box next to “Gridlines” in the Print area.
4. Click Ok

That does it!  Thanks, and happy computing!

Advertisement