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:
- Go to the page layout tab at the top of the window
- Click the “expand” icon to the right of the “Page Setup” group heading. This will bring up the page setup window.
- Click the sheet tab
- Place a check next to “Gridlines” in the print section and click Ok.
- 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:
- Go to File -> Page Setup
- Click the sheet tab
- Check the box next to “Gridlines” in the Print area.
- Click Ok
That does it! Thanks, and happy computing!
This is a great tip! You definitely EXCEL in tip giving! Get it? EXCEL???
It’s a pun.