Print Titles in Excel Is Disabled, How to Enable It?

We will use the dataset below to demonstrate why Print Title doesn’t work in certain cases and how we can resolve the issue. 

Print titles are disabled, how to enable it?

Reason 1 – Print Title Greyed Out Because of Chart Selection

There can be a selection of charts that may cause the grayed-out Print Title problem in Excel.

The sample sheet contains an employee table with charts showing the salary distribution of employees. The Print Titles in the Page Setup group in the Page Layout tab is showing properly.

Disabled Print Title Icon in Excel Because of Chart Selection,

  • The Print Title is still shows properly when we select the table, which means the selection of tables doesn’t affect the Print Title.

  • Select the chart on the information in the table and try to select the Print Title. The Print Title icon is now grayed-out and not clickable.

Greyed Out Print Title Icon Because of Chart Selection

To resolve this, exit from the edit mode by pressing the Esc button. Proceed to Print Title.

Read More: [Fixed!] Print Titles Must Be Contiguous and Complete Rows or Columns

Reason 2 – Print Title Disabled Due to Editing Cell

Editing a cell in an Excel sheet can disable the Print Title icon for a short period of time.

  • Cell E5 is in select mode but not in edit mode. The Print Title icon is showing properly.

Disabled Print Title Due to Editing Cell

  • To edit the cell in E5, double-click on cell E5 or press F2 while hovering over the cell. Doing either of them will let you enter the edit mode and edit the value inside cell E5.
  • The Print Title icon in the Page Layout tab is grayed-out and not available for clicking.

Disabled Print Title Due to Editing Cell

Exit the edit mode by pressing the Esc button. Print Title is now available.

Read More: How to Print Titles in Excel Except for Last Page

Reason 3 – Because of Compatibility Mode

In Excel 2007, you may be unable to use the Print Title icon if the sheet is in compatibility mode. In this case, you need to switch to a non-compatible version of Excel.

Reason 4 – Unable to Access Print Title from Print Preview

In the earlier versions of Excel, the Print Title was in the print preview window. Often, the Print Title icon does not work in the Print Preview window or is grayed out.

To overcome the issue, always click Print Title from the Page Setup group.

Read More: How to Select Column A as Titles to Repeat on Each Page

Download Practice Workbook

Related Articles

<< Go Back to Print Titles | Page Setup | Print in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Rubayed Razib Suprov
Rubayed Razib Suprov

Rubayed Razib, holding a BSC degree in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a devoted member of the ExcelDemy project. He has contributed significantly by authoring numerous articles and showcasing proficiency in VBA. Razib efficiently automates Excel challenges using VBA macros and actively participates in the ExcelDemy forum, providing valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel,... Read Full Bio

  1. After a looking at several hits in a google search, I did not find the solution. However, I finally discovered that I could unlock the Print titles functionality by turning off filtering.

Leave a reply

Advanced Excel Exercises with Solutions PDF