Instructions on how to open when Print title in Excel is locked

Perform setup before printing but can't use the Print title feature in Excel? 

When preparing to print an Excel file, we can use the Print title feature to repeat the title on each printed page. With large Excel files, this feature will be very useful and save us a lot of time. However, many people are experiencing the problem of Print title in Excel being locked and not knowing how to handle it. Right now, TipsMake will analyze this issue more deeply with you!

Why is Print title in Excel locked?

Enter print mode to prepare for printing but discover that the Print title section is blurred and parameters cannot be filled in. Yes! This is the problem that you and many others are also facing. So is this due to something wrong with Excel?

In reality, the problem is not as serious as you think. Specifically, once in print mode, you can only review but cannot directly set the Print title in this mode. To make it easier to understand, print mode is a mode for you to censor content, not a mode for editing. If you want to use Print title, you must return to the editor.

Instructions on how to handle when the Print title feature in Excel is hidden

For those who are new to Excel, they will certainly feel confused when Print title is disabled. However, to fix this problem will not be too difficult. Below, I will give you detailed instructions on how to handle this unpleasant situation.

1. Step 1 : At the print mode interface, click the arrow icon in the upper left corner of the screen. This will return you to the Excel working screen.
2. Step 2 : In the toolbar area, select the page layout tab .

1. Step 3 : Select Print title and now you will see that boxes like Rows to repeat at top or columns to repeat at left are no longer blurred.

1. Step 4 : Set up the parameters in the Print title section as you like. Then press Ctrl + P to switch to print mode. Now if you go to page setup and open the sheet tab, you will see the parameters have changed.

What if I have applied the above measures but it is not effective?

With my experience, if you follow the instructions above correctly, the success rate of fixing the error will be almost 100%. However, nothing will be absolute, so if you have done it the way above, the Print title in Excel is still locked. Try to fix it by closing and reopening the Excel file. Although this method is very simple, it is extremely effective when you do not know where the cause comes from.

In addition, some Add-ins may affect the normal operation of Excel. If you have tried every way to fix the error but cannot, try turning off the add-ins you have installed on Excel. To do this, go to file> options> Add-ins> Go .

When you see the list of Add-ins appear, you just need to uncheck the items you want and click ok to save.

Print title in Excel being locked is not a serious problem. I am confident that, after applying the measures I have instructed above, you will be able to quickly and completely solve this problem.

David Pac

Update 25 August 2024