How to Print the Gridlines and Headings on Your Excel Worksheet

Print Gridlines and Headings in Excel

Printing gridlines in Excel, along with row and column headings, can make it easier to read data in your spreadsheet. However, these features are not automatically enabled. Before Excel 2007, you could add gridlines only when you clicked print, so it was easy to forget. Now you can turn on both features from within a spreadsheet.

Note: These instructions apply to Excel versions 2019, 2016, 2013, 2010, and Excel for Office 365.

How to Print Gridlines and Headings in Excel

  1. Open a worksheet that contains data.
  2. Click the Sheet tab you want to print. To select all Sheets, right-click on a tab, and click Select All Sheets from the shortcut menu. To select two or more adjacent sheets, click the first sheet's tab, then hold down Shift on the last sheet you want to include. To select two or more non-adjacent sheets, click the first sheet's tab, then hold down Ctrl and click the other tabs you want to include.
  3. Click on the Page Layout tab.
  4. Check the Print box under Gridlines on the ribbon to activate the feature.
  5. Check the Print box under Headings to activate this feature as well.
  6. Print the worksheet by pressing Ctrl+P to open the Print dialog box.
  7. Click OK to print your worksheet.

In Excel, the main purpose of gridlines is to distinguish cell boundaries, although they also give the user a visual cue that helps align shapes and objects.