The grid structure is an important feature that helps distinguish between sections, and build an interface easily when using spreadsheets. They are the guide in this structure that makes each cell distinct from other. If you want the gridlines that appear on worksheets in your printed documents as well, you will need to follow a few additional steps. In this article, we are going to show you how to print gridlines in Excel 2016, 2013, 2010, and 2007.
You have 2 options to change the setting for including the gridlines:
- From the Ribbon
- From the Page Setup dialog just before printing
Enabling Excel Print Gridlines from the Ribbon
Let's begin with the quickest method. When your workbook is open, go to the Page Layout tab in the Ribbon for this option. This option is a checkbox located under the Sheet Options section with the name Print. Here is the path:
Page Layout > Sheet Options > Gridlines > Print
Note that the two sets of checkboxes here are for separate options. One column is for the gridlines and the other is for the headers. We're going to be using the checkboxes under the Gridlines to print gridlines.
Page Setup Dialog Method
For this method, simply start printing your page by going to the Print page (Ctrl + P), but don't print it yet. In the Print window, click on the Page Setup link to open the Page Setup dialog. You can find the link at the end of the Settings section.
Once the dialog is open, activate the Sheet tab, and then enable the Gridlines option under the Print section. Click OK to save your changes. Now, Excel will include the gridlines on the printed page.