How to Print the Gridlines of an Excel Worksheet

Techwalla may earn compensation through affiliate links in this story.
The Print menu and the spreadsheet preview section.
Image Credit: Image courtesy of Microsoft

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.

Advertisement

Step 1

Several sheets selected in Excel 2013.
Image Credit: Image courtesy of Microsoft

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

Advertisement

Video of the Day

Step 2

The Print box in the Gridlines section in Excel 2013.
Image Credit: Image courtesy of Microsoft

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.

Advertisement

Step 3

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

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."

Advertisement

Advertisement

Step 4

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

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

Advertisement

Step 5

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.

Advertisement

Advertisement

Report an Issue

screenshot of the current page

Screenshot loading...