In Excel there is a table header on every page. Printing continuous lines in Excel

Most often, Microsoft Excel is used to create tables, since the default sheet is divided into cells, the size of which can be easily changed to a suitable size, and rows can be automatically numbered. In this case, at the top of all data there will be a so-called header, or column headings. When printed, it will definitely appear on the first page, but what about the rest?

We will deal with this in this article. I’ll tell you two ways to make sure that when printed, the title and headings in the table are repeated on every page in Excel, and how to increase the font, size and color for them.

Using through lines

The first way is to use through lines. In this case, you need to add additional rows above the table, one or more, and enter the required text in them.

Select any cell from the first row and, being on the "Home" tab, click "Insert". Then select from the list "rows per sheet".

Next you need to make one from several blocks. To do this, select those that are located exactly above the table, click on the corresponding button and select from the list either simply “Merge”, or with placement in the center.

You can now print a title for the table.

Then move on to formatting it. For this you can use the buttons located in the “Font” group. I made the general title larger, changed the font and added a background. I also made the column names on a gray background and applied italics to them.

After that, open the tab "Page layout" and press the button "Print Headers".

A window like this will open. Put italics in the box "through lines".

Next, click on the first row (where the number 1 is) and drag it down the required amount. In the example, the repeating title corresponds to the first, second, and third row. In this case, a small field will show what you are highlighting.

We return to the familiar window and click “OK” in it.

To see what we did, click “File” at the top and then select “Print” on the left.

The preview window will show you what the printed page will look like. As you can see, there are headings on the first sheet.

Using headers and footers

The second way is to add headers and footers. Since our header is already repeated, we did this in the previous step, let's now duplicate the general name of the table on all sheets.

Open “View” at the top and go to mode "Page layout".

The header field we need will appear at the top of the page, click on it.

If it doesn't appear, place italics on the line between the pages and click on it to show the empty space.

The footer is divided into three parts. Type the appropriate text in one of them. In the example, I will print the table name in the center. Then select it and, using the buttons on the "Home" tab, you can increase the font, change the color, add boldness or italics.

When finished, switch from markup mode to normal.

Let's see what we got. Using the method described above, go to “File” - “Print”. The first page contains both the title and the name of the table.

In these ways, you can add a table title to each page in Excel when printing. Use the option that is most suitable for solving your problem.

Rate this article:

Making repeating table headings in MS Word is quite simple; just select a row, call up the context menu, and on the “Row” tab, select the item: “repeat as heading on each page.”

Note. If you need to make an arbitrary string repeat, then how to do this is described in detail.


Everything is great and simple, but many tables are created and designed in the MS Excel spreadsheet processor. How to make repeating headings here?

In Excel, the procedure for creating repeating headings is not much more complicated, but there are still differences.

So, in order for a certain line to be repeated on each printed page, you need to go to the “ Page layout" and in the group " Page settings» select the item « Print headings».


By selecting repeat on each page “through lines”, it is possible to select several lines that will be repeated on each printed page. There is also the possibility of repeating columns. By the way, in the English version of the spreadsheet processor these menus are called more logically: “ Rows to repeat at top" And " Columns to repeat at left».


It should be noted that there is a significant difference in the operation of these functions in MS Word and MS Excel. In the case of a spreadsheet processor, you can see the repetition of rows only when previewing a document that is being prepared for printing, or after printing itself; in Word, the repetition of the header rows of a table will already be visible in the document itself.

Most often, Microsoft Excel is used to create tables, since the default sheet is divided into cells, the size of which can be easily changed to a suitable size, and rows can be automatically numbered. In this case, at the top of all data there will be a so-called header, or column headings. When printed, it will definitely appear on the first page, but what about the rest?

We will deal with this in this article. I’ll tell you two ways to make sure that when printed, the title and headings in the table are repeated on every page in Excel, and how to increase the font, size and color for them.

Using through lines

The first way is to use through lines. In this case, you need to add additional rows above the table, one or more, and enter the required text in them.

Select any cell from the first row and, being on the "Home" tab, click "Insert". Then select from the list "rows per sheet".

Next you need to make one from several blocks. To do this, select those that are located exactly above the table, click on the corresponding button and select from the list either simply “Merge”, or with placement in the center.

You can now print a title for the table.

Then move on to formatting it. For this you can use the buttons located in the “Font” group. I made the general title larger, changed the font and added a background. I also made the column names on a gray background and applied italics to them.

After that, open the tab "Page layout" and press the button "Print Headers".

A window like this will open. Put italics in the box "through lines".

Next, click on the first row (where the number 1 is) and drag it down the required amount. In the example, the repeating title corresponds to the first, second, and third row. In this case, a small field will show what you are highlighting.

We return to the familiar window and click “OK” in it.

To see what we did, click “File” at the top and then select “Print” on the left.

The preview window will show you what the printed page will look like. As you can see, there are headings on the first sheet.

Using headers and footers

The second way is to add headers and footers. Since our header is already repeated, we did this in the previous step, let's now duplicate the general name of the table on all sheets.

Open “View” at the top and go to mode "Page layout".

The header field we need will appear at the top of the page, click on it.

If it doesn't appear, place italics on the line between the pages and click on it to show the empty space.

The footer is divided into three parts. Type the appropriate text in one of them. In the example, I will print the table name in the center. Then select it and, using the buttons on the "Home" tab, you can increase the font, change the color, add boldness or italics.

When finished, switch from markup mode to normal.

Let's see what we got. Using the method described above, go to “File” - “Print”. The first page contains both the title and the name of the table.

In these ways, you can add a table title to each page in Excel when printing. Use the option that is most suitable for solving your problem.

Rate this article:

If you have created a large table in Microsoft Word that occupies more than one page, for ease of working with it, you may need to display a header on each page of the document. To do this, you will need to set up automatic transfer of the title (the same header) to subsequent pages.

So, in our document there is a large table that already takes up or will only take up more than one page. Our task is to configure this table in such a way that its header automatically appears in the top row of the table when you go to it. You can read about how to create a table in our article.

Note: To move a table header consisting of two or more rows, you must also select the first row.

1. Place the cursor in the first row of the header (first cell) and select this row or rows that make up the header.

2. Go to the tab "Layout", which is in the main section "Working with tables".

3. In the tools section "Data" select an option.

Ready! With the addition of rows in the table that will carry it to the next page, the header will be automatically added first, followed by new rows.

Automatic wrapping of not the first row of the table header

In some cases, the table header may consist of several rows, but automatic wrapping only needs to be done for one of them. This, for example, could be a line with column numbers located below the line or lines with the main data.

In this case, we first need to split the table, making the row we need a header, which will be transferred to all subsequent pages of the document. Only after this will it be possible to activate the parameter for this line (already the header) "Repeat Header Rows".

1. Place the cursor in the last row of the table located on the first page of the document.

2. In the tab "Layout" ("Working with tables") and in the group "An association" select option "Split table".

3. Copy that line from the “big” main header of the table, which will act as a header on all subsequent pages (in our example, this is the line with the names of the columns).

    Advice: To select a line, use the mouse, moving it from the beginning to the end of the line; to copy, use the keys "CTRL+C".

4. Paste the copied row into the first row of the table on the next page.

    Advice: Use the keys to insert "CTRL+V".

5. Select the new header with the mouse.

6. In the tab "Layout" click on the button "Repeat Header Rows" located in the group "Data".

Ready! Now the main table header, consisting of several lines, will be displayed only on the first page, and the line you added will be automatically transferred to all subsequent pages of the document, starting from the second.

Removing the header on each page

If you need to remove the automatic table header on all pages of the document except the first, do the following:

1. Select all the rows in the table header on the first page of the document and go to the tab "Layout".

2. Click the button "Repeat Header Rows"(group "Data").

3. After this, the header will be displayed only on the first page of the document.

We can finish here, from this article you learned how to make a table header on each page of a Word document.

Let's consider To How to fix a table title in Excel, how to setup Print rows and columns on each Excel page, freeze the top rows and columns. How to freeze a table header in Excel so that when scrolling a large table, the table header is always visible, etc., read the article “How to freeze a row and column in Excel.”
How to print a table header on every Excel page.
To print a table header on each page, go to the “Page Layout” tab in the “Sheet Options” section and select the “Page Options” function. This button is located at the bottom right of the Sheet Options section - it's a small button with an arrow.
This button is circled in red in the image. In the window that appears, go to the “Sheet” tab.
In the “Print on each page” section, in the “through lines” line, set string range(table headers). Here in the picture the range of one line is indicated.
In order not to manually write the range, you can make it simpler. Place the cursor in the line “through lines” (click the mouse) and go to the table. Select all the rows of the table header, the address will be written automatically.
The header range in the table will be outlined with a pulsating dotted line (see image). Here you can immediately see how it turned out. To do this, click the “View” button. If everything suits you, click the “OK” button.
Print columns on each Excel page.
In the same way as rows, you can set the range of columns that should be printed on each page.
You can put the address of a column (or row) simply. Place the cursor in the line “through columns”. Then, click with the mouse on the column address (letters, A, B, etc.), this column will be highlighted, its address will appear in the “through columns” line. You can select several columns at once. Using this principle, we select rows by clicking on the row address line, “1”, “2”, etc.).
If in the Print section of the window If we check the “grid” function, the Excel sheet grid will be printed with a gray dotted line (where the cell borders are not drawn).

How to create a table in Excel, see the article "How to create a table in Excel".
In the same window you can configure sequence of printing pages. Here, in the example, it is configured like this: first all pages of the table are printed down, then it goes to the next pages to the right of the printed pages and again from top to bottom, etc.
If needed print part of table (range), then we will use the function in the same window. To do this, enter the parameters of the selected range in the table in the same way as you indicated the range of the table header.How to work with a range in a table, see the article "What is a range in Excel".
In a table, you can hide the values ​​of some cells from prying eyes. There are methods that hide cell values ​​on the monitor, but are printed when printed on paper. But, there is a way to hide data when printing. Read more about such methods in the article "

 

It might be useful to read: