The headings in Excel are essentially the screen guides that make working with cells or ranges easier. By default, row and column headings in Excel don’t show in printed documents. If you want to print them anyways, Excel has an option which allows including row and column headings. In this article, we are going to show you how to print headings in Excel 2016, 2013, 2010 and 2007.
Since Excel does not print the headings by default, you will need to activate this feature yourself. You have 2 options to do this:
- From the Ribbon
- From the Page Setup dialog just before actually printing your document
Let’s see this options in detail.
Enable Using the Ribbon
Let’s begin with the quickest method. On your workbook, begin by going to the Page Layout tab in the Ribbon. The option you’re looking for is the checkbox named Print located under the Sheet Options column. Below is the path:
Page Layout > Sheet Options > Headings > Print
Note that the two sets of checkboxes here are for separate options. One column is for the gridlines and the other is for the headers. We’re going to be using the checkboxes under the Headings to include the headings in the print document.
Enable Using the Page Setup Dialog
For this method, simply start printing your page by going to the Print page (Ctrl + P), but don’t print it yet. In the Print window, click on the Page Setup link to open the Page Setup dialog. You can find the link at the end of the Settings section.
In the Print window, click the Page Setup link to open Page Setup dialog. You can find the link at the end of the Settings section.
Once the dialog is open, activate the Sheet tab, and then enable the Row and column headings option under the Print section. Click OK to save your changes. Now, Excel will include the headings on the printed page.