In Microsoft Excel, headings serve as on-screen guides to facilitate working with cells or ranges. By default, the row and column headings in Excel do not appear in printed documents. However, if you wish to include them in your prints, Excel provides an option to enable the printing of row and column headings. This article will guide you on how to print headings in Excel versions 2016, 2013, 2010, and 2007.
As Excel doesn't print headings automatically, you must activate this feature yourself. There are two methods to accomplish this:
From the Ribbon:
You can access the option to print headings directly from the Ribbon.
From the Page Setup Dialog:
Alternatively, you can activate this feature just before printing your document by using the Page Setup dialog.
Now, let's delve into each of these options in detail.
Print Headings 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
Once you've navigated to the Page Layout tab and located the Sheet Options column, specifically the Headings section, you'll find two distinct sets of checkboxes that pertain to different elements in your spreadsheet.
The first set of checkboxes, associated with gridlines, allows you to control the visibility of gridlines in your printed document. Meanwhile, the second set of checkboxes, under the Headings section, is focused on the inclusion of headers in your printout.
To enable the printing of headers, make sure to check the box labeled "Print" in the Headings section. This action ensures that the column and row headers, which typically contain labels or identifiers for your data, will be included when you print the workbook.
This feature is particularly useful when you want to maintain clarity and context in your printed copies, as headers serve as a reference for understanding the content of each column and row. Once you've checked the "Print" option under Headings, you can proceed to print your workbook, and the headers will be included in the printed document for enhanced readability and comprehension.
Enable Using the Page Setup Dialog
For this method, begin by initiating the printing process through the Print page option, which can be accessed by pressing Ctrl + P on your keyboard. However, don't print it yet.
Within the Print window, you will notice the Settings section. At the end of this section, there is a link labeled "Page Setup." Click on this link to open the Page Setup dialog, which will allow you to configure various printing options.
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. This ensures that the printed document provides a comprehensive view, retaining the necessary context provided by headings for better readability and reference.
While Excel doesn't automatically print row and column headings, users can easily enable this feature for enhanced document clarity. With two methods are outlined in this article, you can ensure that headings are included in the printed document, improving readability and reference for users working with Excel versions 2007, 2010, 2013, and 2016.
