How to print table name in excel. How to print headers (names) of rows and columns on each page in Excel

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:

Let's learn attach the table header as a heading for printing(with fixed rows or columns) on each page in Excel.

How often have you scrolled down or to the right and lost sight of the title?
If you fix the table header using freezing areas, then when scrolling the Excel sheet, the header will indeed remain motionless and the problem is solved, but when printed it will still not be repeated on each page, which can lead to incorrect interpretation of the data (you can easily confuse the data due to incorrect designation).

And then, in order to understand which row or column of data is responsible for what, you will have to return to the beginning of the sheet, which is extremely inconvenient. Therefore, if the printed document takes up more than one page, then repeating the headings will greatly simplify the reading of the document.

How to attach a heading to every printed page in Excel?

Excel has standard tools that allow you to make a repeating table header when printing a document.
But first, let’s decide what type of header we will need to work with; in general, there are two types:

Horizontal. The header is located at the top and the body of the table is at the bottom;
Vertical. The header is on the left and the body of the table is on the right.

There is only one difference in working with different types of headings - for horizontal ones we will make only the rows motionless, and for vertical ones - columns.
Let's move on to practice and use examples to look at how you can print a header in Excel so that it appears on every sheet.

How to fix a horizontal header?

Let's consider a large table (let's take one so that it probably won't fit on one page) with a horizontal header (rows 1-2 with the name of the table and the designation of the data contained in it), which we subsequently plan to print:

To see how the sheet will look when printed, you can use the preview (on the tab bar File -> Seal, or using Ctrl+F2).

As you can see, on the first sheet the header in the table is located at the top, but on the second it is not there at all, which makes it unclear what kind of data is in which column (for example, by looking only at the second page it is impossible to determine what exactly the data shows):

Now let's move on to setting the sheet printing parameters.
On the tab bar, select a tab Page layout and in the section Page settings press Print headings:

In the pop-up window (you can also customize the output here), we are interested in the block where we can set end-to-end rows and columns.
Name end-to-end precisely implies that these elements will pass through all printed sheets:

Accordingly, if the table header is presented in horizontal form, then in order to make the header motionless when printing the page, we need to set the dockable area as end-to-end rows.

Select the lines to pin (in this case, these are lines 1 and 2, i.e. enter $1:$2 ), and then click the view button to display the changes made:

As you can see, headings also appeared on the second sheet of the table, just like on the first.

Everything is ready, you can send the document for printing.

How to attach a vertical header?

Let's consider another case when the table header is located not horizontally, but vertically (column A with a list of employees):

First, let's check what our table looks like when printed.
Using the preview, we make sure that the heading on the second page is missing:

Let's repeat all the steps from the previous example (when we fixed the rows), but at the last step, instead of end-to-end rows, we will set end-to-end columns.
In this case, we need to fix the first column, so in the field Through columns enter $A:$A. As a result we get:

As we can see in this case, a floating header appeared on each sheet; now the document is also completely ready for printing.

Thank you for your attention!
If you have thoughts or questions on the topic of the article, share them in the comments.

In previous lessons, we described how to pin areas for convenient viewing of large documents when scrolling vertically or horizontally. As a rule, table row and column headers are fixed. But the question involuntarily arises: “How can Excel fix the table header when printing?”

In the “page settings” you can configure the printing of the table header on each page. So that the table can be just as conveniently viewed on printed sheets of paper. After all, the lack of table headings on each sheet significantly complicates the readability of printed data.

Print table header on every Excel page

After changing these settings, you can print a table header on each page. The result of these parameters can be seen when previewing the document or immediately after it is output to the printer.

Excel has more options for customizing document printing than Word.

Often, when printing a table or other document, you want the heading to be repeated on every page. Theoretically, of course, it is possible to determine the boundaries of pages through the preview area and manually enter a name at the top of each of them. But this option will take a lot of time and will lead to a break in the integrity of the table. This is all the more inappropriate, given that Excel has tools that can solve the task much easier, faster and without unnecessary breaks.

The principle of solving this problem using Excel tools is that the title will be entered only once in one place in the document, but when printed, it will appear on each printed page. You can use one of two options: use headers or footers.

Method 1: Using Headers and Footers

Headers and footers are the top and bottom margins of a page in Excel, which are invisible during normal operation, but if you enter data into them, they will be displayed on every printed element.

You can edit headers and footers by switching to Excel operating mode "Page layout". This can be done using several options. First of all, you can switch to the operating mode we need by clicking on the icon "Page layout". It is located on the right side of the status bar and is the central of the three icons for switching document viewing modes.

The second option involves first going to the tab "View" and while there, click on the icon "Page layout", which is placed on the ribbon in the toolbox "Book viewing modes".

In addition, there is another option for enabling the display of headers and footers in an e-book. Go to the tab "Insert" and click on the button "Header and footer" in the settings group "Text".

After we switched to view mode "Page layout", the sheet has been divided into elements. These elements will be printed as separate pages. At the top and bottom of each such element there are three header and footer fields.

For a table header, the top center field is best suited. Therefore, we place the cursor there and simply write the name that we want to assign to the table array.

If desired, the title can be formatted using the same tools on the ribbon that are used to format data on a regular worksheet range.

Then you can return to normal viewing mode. To do this, just click on the left icon for switching viewing modes in the status bar.

You can also go to the tab "View", click on the button on the ribbon called "Ordinary", which is located in the block "Book viewing modes".

As you can see, in normal viewing mode the table name is not displayed at all. Go to the tab "File" to see how it will look when printed.

Next we move to the section "Seal" via the left vertical menu. On the right side of the window that opens there is a document preview area. As you can see, the name of the table is displayed on the first page of the document.

Scrolling down the vertical scroll bar, we see that the header will appear on the second and subsequent pages of the document when printed. That is, we have solved the problem that was set for us initially.

Method 2: end-to-end lines

In addition, you can display the document title on each sheet when printing by using continuous lines.

So, we found out that in Excel there are two options to quickly display the table title on all printed sheets, with a minimum of effort. This can be done using headers or footers. Each user is free to decide which method is more convenient for him and is better suited for solving the task at hand. But it should still be said that through lines provide more opportunities. Firstly, when they are used on the screen, the name can be seen not only in a special viewing mode, but also in a normal one. Secondly, if the headers and footers require the title to be placed only at the very top of the document, then with the help of through lines the title can be placed on any line of the sheet. In addition, continuous lines, unlike headers and footers, were conceived by the developer specifically to organize headings in a document.

It might be useful to read: