Print gridlines in a worksheet

By default, gridlines don't appear on a printed Microsoft Excel worksheet or workbook. This article describes how you can make the gridlines appear in your printed worksheets.

1. Select the worksheet or worksheets that you want to print. For more information, see Select one or multiple worksheets.

   Tip

   When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, select any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then select Ungroup Sheets.

2. On the Page Layout tab, in the Sheet Options group, select the Print check box under Gridlines.
   

   Note

   If the check boxes in the Sheet Options group appear dimmed, it may be because you have a chart, image, or other object selected on the worksheet. If you cancel that selection, you'll be able to use the check boxes.

3. Select the File tab, and then select Print.
   Keyboard shortcut -- You can also press Ctrl+P.

4. Select the Print button.

Next steps

After you select the Print check box, you might want to take the following steps:

• Preview the gridlines – To see how the gridlines will print, check the Print Preview window (or in some versions you can press Ctrl+F2 to open the File tab, which displays a preview of a printed worksheet). Gridlines print only around actual data in a worksheet. If you want to print gridlines around empty cells also, you must set the print area to include those cells. Or, you can apply borders around the cells instead. To learn more about these options, see Define or clear a print area on a worksheet or Apply or remove cell borders on a worksheet.

• Troubleshoot printing issues with gridlines – If gridlines don't show up when you print your worksheet, or if you can't see them in the Print Preview window, check that the Draft quality check box is not selected. Select File > Print and then select the Page Setup link. Select the Sheet tab and if the Draft quality check box is selected, clear the selection. For a shortcut to access the Page Setup dialog box, press Alt+P, S, P.

  

  If gridlines still don't print successfully, there may be an issue with your printer driver. In this case, you can try downloading the latest driver from the printer manufacturer's website. As a last resort, you can apply borders around the cells that you want to print. For more information, see Apply or remove cell borders on a worksheet.

Printing gridlines is not supported in Excel for the web but you can mimic gridlines by applying borders, like in this picture:

1. To add a border around each cell, select and drag to select cells that you want included.

2. On the Home tab, in the Font group, select Borders > All Borders.
   The areas with borders will now appear with darker lines.
   

3. For a print preview, select File > Print⁠.⁠

4. Pick the print option you want to preview and select Print.
   

5. In the preview, make sure the gridlines look the way you want them to, and then select Print.

   Note

   If you want to make changes before printing, select Cancel (in earlier versions, select the x) to close the preview and return to the worksheet.