How to Ensure the Title is Printed on Every Page when Printing Excel Worksheets

Excel is very helpful in work because it allows you to input a lot of data and information. Besides, you can print it on paper to finish your work. And today we have the Excel tips to ensure printing title on every page.

Sometimes, in your work, you will print an Excel file on paper. Besides, in most of the time, one piece of paper is not big enough to print all the information. And certainly, you need to print several pieces of paper. Thus, a problem exists that on the other paper, there is no title. So it is very inconvenient to check the category because you need to check the previous page. For example, here is a worksheet of student scores, and you need to print it. But in the printing preview, you will find that there are two pages. And in the second page, there is no title.Two Pages in Printing Preview

And if you can print the title on every page, you can save a lot of time and energy to check. So here is a way to accomplish this target.

Printing Title on every Page

  1. Click the “Page Layout” tab on the ribbon.
  2. And now click the button of “Print Titles” on the ribbon.Click Print Titles
  3. And then you will see a new window pop up. In the “Rows to repeat at top”, input the title row into the text box.Rows to Repeat at Top
  4. And then click “OK”. Now you have finished all the settings. To check whether it will print on every page, you can still see in the printing preview.The Title in the Second Page

You will see that the title is also in the second page. And now you can print it without any worry.

Retrieve Data in Damaged Excel Files

If your work needs to use Excel, you will find that you will rely more and more on it. That is because Excel contains many effective features. However, there are times that you may suffer from        Excel file corruption. And such data disaster can happen due to many different reasons, such as virus, malware, hardware failure, power failure or some human errors. To be honest, such accidents can sometimes be unavoidable. And once such accidents happen, your Excel files are most probably get damaged. So you may try the useful tool to repair Excel file. Sometimes, even if the file corrupts, the data stored in it still exists. And our repair tool is capable of retrieving data from even severely damaged files. Thus, your loss can reduce to the smallest.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com

One response to “How to Ensure the Title is Printed on Every Page when Printing Excel Worksheets”

  1. If you want to print a workbook title on every page as well as all the column headings, I would use Insert –> Header & Footer –> then enter your workbook title at the top page view where it says “Click to add header.”