How to Print Gridlines in Excel 2013

You might be interested in learning how to print gridlines in Excel 2013 if you have printed out a document and found it difficult to read because all of the data seemed to group together. The lines separating the cells on your spreadsheet, called gridlines, and a very important factor in making the spreadsheet easier to read on your computer.

But those lines don’t print by default, so you need to adjust a setting to print gridlines in Excel 2013.

Step 1: Open the spreadsheet in Excel 2013.


Step 2: Click the Page Layout tab at the top of the window.

how to print lines on spreadsheet excel 2013



Step 3: Check the box to the left of Print under Gridlines in the Sheet Options section of the ribbon.

how to print gridlines in excel 2013


Another helpful print setting that you might want to use involves repeating a row at the top of every page in Excel 2013. This will make it much simpler for readers to identify the information contained within your cells.