How to print names of columns or rows on every page

Table is sometimes longer than one page. It is very useful to print names of columns or rows on every page. This example shows how to do that.

Example 1 / Repeat column names on every page

Let’s have a big table of invoices. On the picture is just a small part of the table. The task is to print the first row of the table on every printed page.

List of invoices in Excel

Go to the Page Layout >> Print Titles

Page Layout - Print Titles

Select field Rows to repeat at top >> select rows you want to repeat on every printed page >> press OK

Rows to repeat at top

Try print the table or check it in the Print Preview.

Example 2 / Repeat row names on every page

The same problem as in the previous example, but now we need to print the first column of the table.

List of orders in Excel

Go to the Page Layout >> Print Titles

Page Layout - Print Titles

Select field Column to repeat at left >> select columns you want to repeat on every printed page >> press OK

Columns to repeat at left

Try print the table or check it in the Print Preview.

Add a comment »5 comments to this article

  1. Column names on each page? No problem! Thank you.

    Reply

  2. Print Excel table headers solution. Perfect. Thank you. I was always wondering how to repeat table headers on every page. This solved my issues.

    Reply

  3. I like to party, not look ariltces up online. You made it happen.

    Reply

  4. How to Freeze Panes in this Excel?

    Reply

    • Fiidnng this post. It’s just a big piece of luck for me.

      Reply



Copyright © All Rights Reserved · Green Hope Theme by Sivan & schiy · Proudly powered by WordPress