How to Remove Print Titles in Excel (3 Methods)

Get FREE Advanced Excel Exercises with Solutions!

We occasionally need to print exported files or files that we have received from others. In that case, we may face difficulties with print titles that come as Title, Header, or Row and Column Headers. We have a sample dataset containing these 3 issues. Let’s see, how to remove print titles in Excel.

How to remove print titles in excel


How to Remove Titles from Print in Excel: 3 Ways

In this article, we will see the Page Setup and Header option to remove print titles in Excel.


Method 1: Remove Print Titles Using Page Setup

When we try to print our file we see that Sale ID, Category, Product, Quantity, Unit Price, and Total Price these titles is appearing every time.

This is the first page of the worksheet and contains the title.

But when we go to the next page, we still see that the same title appears.

We want this title to appear only on our first page. Let’s see, how to remove this.

Steps:

  • First, go to the PAGE LAYOUT and click Print Titles.

How to remove print titles in excel by page setup

  • Now, a dialogue box will pop up and we can see $2:$2 in the Rows to repeat at top box.

How to remove print titles in excel by page layout

  • Simply, remove this row reference and click OK.

  • Now, press CTRL+P and we can see no print title on page 2.

How to remove print titles in excel by page setup

That’s it. Simple.

Read More: How to Set Print Titles in Excel


Method 2: Header Option to Remove Print Titles

This time, we are facing another problem. You can see Sale, Confidential, and Page Number above the printing page. So, let’s learn how to remove this type of title.

Steps:

  • At first, go to PAGE LAYOUT > Print Titles.

How to remove print titles in excel using header option by page setup

  • As a result, a dialogue box will pop up and we will select None from the drop-down box of Header from the Header/Footer tab.

  • Finally, if preview this page, it will look like the following image.

How to remove print titles in excel by page setup

Read More: How to Set Multiple Rows as Print Titles in Excel


Method 3: Remove Row and Column Titles

Sometimes while printing, we can see row and column headers/titles are also being printed or we can see it in the Print Preview section. There is an easy step to resolve this issue.

How to remove print titles in excel using header option by page layout

Steps:

  • Simply, go to PAGE LAYOUT and uncheck Print in the Sheet Option as shown in the image below.

  • Now, our image will look like the following when we want to print.

Read More: How to Set a Row as Print Titles in Excel


Practice Section

We’ve attached a Practice sheet where you may practice these methods.


Download Practice Workbook


Conclusion

That’s all for the article. These are 3 different methods for how to remove print titles in Excel. Based on your preferences, you may choose the best alternative. Please leave them in the comments area if you have any questions or feedback.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mahbubur Rahman
Mahbubur Rahman

Mahbubur Rahman is a highly skilled and experienced professional with a strong background in both engineering and business administration. With an impressive technical skill set and a passion for innovation and problem-solving, Mahbubur has achieved great success in his field.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo