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. 

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.

• 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.

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.

• 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.

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

• How to Set Print Titles in Excel
• How to Set Print Titles to Repeat in Excel
• How to Set a Row as Print Titles in Excel
• How to Set Multiple Rows as Print Titles in Excel
• How to Remove Print Titles in Excel

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