How to Print the Gridlines of an Excel Worksheet

Gridlines -- the lines that separate cells -- don't appear on printed worksheets or workbooks by default in Microsoft Excel 2013. To print the gridlines, change the Sheet options from the Page Layout tab. Define a print area if you need to print the gridlines of empty cells; Excel doesn't print them by default. Don't forget to see how the gridlines will print by previewing the document before sending it to the printer.

...
The Print menu and the spreadsheet preview section.
credit: Image courtesy of Microsoft

Step

Open the workbook in Microsoft Excel and select the spreadsheets you want to print. Select several spreadsheets by holding "Ctrl" and clicking each sheet.

...
Several sheets selected in Excel 2013.
credit: Image courtesy of Microsoft
...
The Print box in the Gridlines section in Excel 2013.
credit: Image courtesy of Microsoft

Step

Select the "Page Layout" tab and then check the "Print" box in the Gridlines section of the Sheet Options group to print the gridlines. The new setting is applied to all selected spreadsheets.

...
The Print Area button in the Page Setup group.
credit: Image courtesy of Microsoft

Step

Set a print area if you need to print empty cells and their gridlines. To set a print area, select the cells you wish to print, click "Print Area" in the Page Setup group on the Page Layout tab and select "Set Print Area."

...
The Print Preview pane.
credit: Image courtesy of Microsoft

Step

Preview the document before printing it by clicking "File" and selecting the "Print" tab. The preview is displayed in the right pane.

Step

Format the cell borders if the default gridlines are not what you're looking for. You can change both the style and the color of cell borders.