How to Clear Print Titles in Excel

There is an advantage that we can get if we activate Print Title in Excel, that is, we don't have to bother typing the title on every page, if we want to print in Excel with the same title on every page. The most benefit is when we create a table that is more than one page long.

By using Print Title, we don't need to be tired anymore in making column headings from the table on each page because it will automatically appear when printed.

More tutorials:

• How to Show Margins in Excel 2007 Print Preview
• How to Clear Print Area in Excel
• How to Open 2 Different Excel Files on 1 Screen
• How to Print 2 Pages on 1 Sheet in Excel 2010
• How to Print Landscape in Excel

However, there are drawbacks if we use this feature, which is that column headings will continue to appear even though the page we are printing is not a continuation of the table we created.

So, to remove or deactivate Print Titles, the method is the same as when we activated it, that is, you enter the "Page Layout" menu, then select "Print Titles". Empty or delete the contents in "Rows to Repeat at Top", after that friends click "OK" and see the results.

Automatically Print Title will be deactivated or lost. How is it friends, easy right? good luck