Repeat a line on every word page. Header on every Excel page

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.

And other additional elements are sometimes easier not to draw, but to add using the tab Layout. In order for this tab to appear, you need to place the cursor anywhere in the table. In the tab Layout there is a group of teams Rows and Columns . And in this group there are teams Insert top, bottom, left and right . This is how you can add rows and columns to any place in the table, including a header. And then merge and split cells using a group of commands Merge .

But all this, in principle, is quite obvious, and becomes clear once you carefully examine this tab. Let's now look at less obvious things.

Repeat table header on every page in Word 2007

If your table is very large, or is located in such a place that it does not fit on one page, its rows go to the next page. It is convenient to make sure that the header is repeated all the time, no matter how many pages the table stretches over.

To do this, you just need to select the header, go to the tab Layout, and select the command there Data - Repeat Header Rows .

Inserting formulas into tables in Word 2007

In this case, you place the cursor in the cell where the amount will be, go to the tab Layout, and select a team Data - Formula .

A window will appear Formula, in which in the field Formula the expression will be written =SUM(ABOVE), that is, the sum of those numbers that are in the cell above. Click OK and the amount will be entered.

If you change any source data, the amount will not change automatically, unlike the formulas in n. To change the final value, you need to update it.

To update, place the cursor in the middle of the final number, press the right key, and select the item Update field .

Sometimes you need to calculate something other than the sum, such as the average. To do this, just go to the tab Layout - Data - Formula , clean the window Formula expression after the equal sign, in the field Insert function find the item AVERAGE, and click on it. In the field Formula the following expression will appear: =AVERAGE(). Now you need to write in parentheses the average of which will be calculated. In parentheses you write ABOVE. You will get the following formula: =AVERAGE(ABOVE). After this, the average value of all numbers located above will appear in the cell.

You can also add various arithmetic operations of your own to the formulas. Let's say you want to not only calculate the amount, but also add the number 10000 to it, multiply all this by 2, and then raise it to the power of 1.05. This is all quite easy to do. First go to Layout - Data - Formula and then into the field Formula you write: =((SUM(ABOVE)+10000)*2)^1.05
The result will appear in front of you. Just do not forget to write the formula correctly, in particular the parentheses, otherwise the formula will generate an error.

Numbering cells in a Word 2007 table

In many tables, the first column is reserved for numbering. In the header they usually write № , or No., and the numbers 1, 2, 3 and so on go down. Usually numbers are set manually. But imagine the situation - you insert a new row into the middle of the table. In this case, you will have to copy all the cells below in the column and paste them in a new place so that the numbering moves up. If you constantly adjust the table in this way, it will not be very convenient for you. It is better to put down automatic numbering.

Select all the cells in which you want to see automatic numbering. If these cells already have numbers, delete them.

Then go to the tab Home — Paragraph , and press the button Numbering. This button is also used to create a numbered list.

The numbering will be created and will be automatically adjusted as new lines are added.

If you don’t like the numbering format, and by default it is a number with a dot, place the cursor in any cell with numbering, go to the tab Home, click on the drop-down list to the right of the button Numbering, and select a different format option. If you don’t find what you need there, click on the item Define new number format , and you prescribe the format that suits you. For example, you can remove the period after the number. The format will then automatically change in all cells.

Sometimes the numbers are pressed to the right edge of the cells, which is not very nice. This means you need to change the indentation. To do this, right-click on any number, and all numbers are highlighted in gray. Select the item from the drop-down menu Change list indentation , and in the field Number position change the value to a lower value. See the result. If you don’t like it, change the value again until the numbers are what you need.

Sorting rows in a Word 2007 table

Sometimes you need to sort the rows in a table so that in some column the data is in alphabetical order. Naturally, the data in other columns should remain consistent. Sorting data is a fairly simple matter. First, select the data that needs to be sorted in the desired column. After that, go to the tab Layout, and select a team Data - Sorting . The data will be sorted.

Video about the necessary little things when working with a table in Word 2007

You can get more detailed information in the “All Courses” and “Utilities” sections, which can be accessed through the top menu of the site. In these sections, articles are grouped by topic into blocks containing the most detailed (as far as possible) information on various topics.

You can also subscribe to the blog and learn about all new articles.
It won't take long. Just click on the link below:

In some Microsoft Word documents you have to work with tables. Information in this form is better perceived and remembered. If it is small and takes up one sheet, then making a table in Word is easy. But what if it takes up several sheets?

When viewing material designed in this way, it is inconvenient to constantly return to the beginning to see what the data columns are called. In this article we will look at how to make a repeating table header in Word. That is, a row with column headings will appear on each page.

How to attach a header to each sheet

Let's transfer the names for the columns using this example.

To repeat them on each new sheet, highlight the corresponding line. Then go to the “Table Tools” - “Layout” tab and in the “Data” group, click on the “Repeat Header Rows” button.

After this, the column names will be repeated on each new sheet.

Making a second header line on each page

If your column names are indicated in several lines, for example, the main name of all columns and the name of each separately, or the name and their numbering, then you may need to transfer not the first line, but the second or third, to subsequent sheets.

In the example I will show how to transfer the second row. But if you need to duplicate the headers of the third or any other, then everything is done in exactly the same way.

Place the cursor in the last right cell on the first page and press “Ctrl+Enter” to divide the table into two parts.

On the “Home” tab, you can click on the “Display all characters” button, and then at the end of the first sheet you will see the inscription “Page break”.

If your last cell on the first page was large, 8-10 lines long, then after inserting a break, there will be a lot of free space on the first page. To prevent this from happening, you need to add one more line. I wrote how to do this in the article on how to write a continuation of a table in Word. Follow the link and read method 2.

Go to the second page and place your cursor in the top left cell. Then you need to paste what we copied earlier - press “Ctrl + V”.

The title will be added on the second sheet.

Now we need to duplicate it. Select the added row, open the Layout tab, and in the Data group, click Repeat Header Rows.

This is how you can transfer headers, but not all, but only those that are needed.

Please note that if you want to change the header, then you need to do this with the one you duplicated. Duplicated ones, that is, those that are repeated, cannot be changed.

How to remove duplicate table headers

If you have a table in your document with the column names moved to the second page, and you need to remove them so that they appear once at the beginning, then do the following.

Select the first header that is duplicated, not the duplicated one (by the way, you won’t be able to select them). Then open the “Working with Tables” tab – “Layout” and in the “Data” group, click on the “Repeat Header Rows” button.

After this, the titles on all other pages will be removed.

That's all. We looked at how to duplicate the header for table columns in Word. If you have any questions, write them in the comments.

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.

Lesson: How to continue a table in Word

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.

Lesson: How to make a table in Word

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

Automatic header transfer

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.

Lesson: Adding a row to a table in Word

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.

Lesson: How to automatically number rows in a table in Word

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 "Unification" select option "Split table".

Lesson: How to split a table in Word

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).

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

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.

Lesson: How to Convert a Table to Text in Word

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

We are glad that we were able to help you solve the problem.

Ask your question in the comments, describing the essence of the problem in detail. Our specialists will try to answer as quickly as possible.

Did this article help you?

Hello, dear users of the multifunctional text editor WORD. From today's “Crib Sheet” you will learn how to make, perform according to GOST, insert, pin, move, repeat, copy names, headings, inscriptions, table headers in Word to other pages. As before, we will work with its 2016 version.

You may ask, why am I spamming with all possible synonyms for one concept? But the fact is that there is a lot of confusion in this seemingly linguistic issue. Let's agree with you that the inscription above the table is another name for it. But the contents of the first table row are the header or title. Now, having dealt with the subject of our conversation today, we can begin to “make” it. Let's go?

How to make an inscription above a table in Word

This operation can be carried out in three ways. The first of them ensures full compliance with the requirements of GOSTs: 7.32-2001 (for the preparation of theses), as well as 1.5-93 and 2.105-95 (ESKD - Unified System of Design Documentation). The inscription turns out to be modest and discreet, but at the same time the tables are automatically numbered. The second and third methods are for those who are not constrained by the GOST framework and want to clearly design the name of the table. So…

Caption for the table in Word according to GOST

Select the table. To do this, click the left mouse button on the movement marker (the cross in the upper left corner). After this, call the context menu by clicking the right mouse button (the cursor is on the table field). In the window that pops up, select the line "insert title"(see Fig. 1).

In the first cell of the dropped window (see Fig. 2) we write the name. Moreover, friends, please note that according to GOST it begins with the word “Table” with a serial number. Then, through a dash with a capital letter, we enter the title itself and do not put a period after it. If the specified cell contains not the word “table”, but “equation” or “figure”, then you can make a replacement in "parameters" line "signature".

In the third line "position" we are given the choice to place the table title at the top or below it. GOST allows both options. After filling out all the required fields, do not forget to click the button "OK".

You can delete a name that was inserted by mistake or that you don’t like using the key DELETE.

How to insert a table title in Word with your own formatting

Sometimes Word users have problems entering the table name. The cursor does not want to go beyond its upper boundaries. In this case, you need to do this:

place the cursor in the upper left cell;
in the toolbar "Working with tables" go to the tab "Layout";
in section "Unification" click on the button "split table"(Fig. 3).

Now our cursor has obediently taken its place above the table and is ready to enter its name. Any styles, sizes and colors of fonts are available to us. You can place the table title in a frame. Read how to do this here. But this method of giving a table a name has one drawback. Sometimes, if further formatting is necessary (adding/deleting rows, columns), the inscription “moves” to the side. It looks very ugly. To prevent such incidents from arising, it is better to use the third method.

How to add an inscription to a Word table so that it does not move

The first step is to add a row at the top of the table. Let me remind you how to do this: panel "Working with tables"- tab "Layout"- chapter "Rows and Columns"- button "insert on top". Moreover, the new line will be empty, without text (Fig. 4).

Next, in the newly added line you need to merge the cells. To do this, select the line in the same tab "Layout" go to the section "Unification" and press the button "merge cells"(Fig. 5). After that, in the resulting large cell, enter the name of the table, center it and format the text.

Now, in order for the inscription to look beautiful, you need to remove the cell borders. Select it again and follow the path: panel "Working with tables"- tab "Constructor"- chapter "Framing"- button "borders". In the drop-down menu, go down to the very bottom and click on the line "borders and fill".

After this, a new window will open in which you need to select the tab "Border" and deselect the buttons corresponding to the top and two side frames, then - "apply to cell" And "OK".

Now the inscription is practically “tightly glued” to the Word table. Everything looks very beautiful. But this method also has its pitfalls. It only applies to small tables that fit on one sheet. Otherwise, you, friends, will not be able to duplicate the table header in its continuations on subsequent pages without repeating the title. And you're not supposed to do that.

Because everyone knows that it is better to see once. than to read many times, I have prepared a short video for you, friends:

So... We are done with the inscriptions and names of Word tables. Let's now deal with headings.

How to attach a table header in Word

This question arises in the case of large tables that span several pages. Then, of course, for the convenience of working with their data, it is better to duplicate the title line at the beginning of each page. This is what we mean when we use the term “fix.”

So, it’s very easy to attach a table header in Word. To do this, you need to select it, then in the tab "Layout" and section "Data" activate button "repeat header lines"(Fig. 6). Now on each new page your sign will begin, as expected, with a header.

The same can be done using the window "Table Properties". To open it, select the entire table, right-click on its field, and in the drop-down menu we find the line we need. In the window go to the tab "Line" and check the box "repeat as heading on every page"(Fig. 7).

In this case, you just need to open the window again "Table Properties" and now go to the tab "table". Pay attention to the group "Wrap around". Choose a button "NO", it must be activated (see Fig. 8). Only then will you be able to duplicate the table header on subsequent pages.

Now you will succeed.

How to freeze only the second row of a table without a header

It happens that a large and complex table has many columns and takes up several pages. Then, to make it easier to perceive its contents, column numbers are placed in the second line under the heading, and the continuation of the table on each new page begins with this numbering.

But how is this done? After all, when moving the table header, you cannot ignore its first row. It won't work. And we will not take the same actions that we did to repeat the title on each page. Let's do it simpler:

select the line with numbers;
copy it ( Ctrl+C);
insert into each first row in the continuation of the table on new pages ( Ctrl +V);

Everything is clear with this question. Isn't it?

How to insert the inscription “continuation of table” in Word

Yes, in large tables that occupy several pages, according to GOST, such an inscription is required. However, even if you do not have a GOST document, the inscription “continuation of the table” at the beginning of each new tabular sheet will still be quite appropriate. But the WORD program does not allow you to enter text between the rows of the table. What should I do? There is a way out. You need to follow these steps:

place the cursor in the last cell of the last row of the table on the first page;
make a page break at this point (Tab "Insert"- chapter "Pages"- button "page break");
The last line of the first page will shift to the second, and under the table on the first page you can place the cursor and enter the text: “continuation of the table” (see Fig. 9).

But we need this inscription not on the first, but on the second and subsequent pages. Calmly. As soon as you start entering text, it will “jump” to the second sheet. Everything will be as it should be.

If the table occupies not 2, but 3 or more sheets, then, unfortunately, this operation will have to be repeated on each sheet again. This process cannot be automated.

For the second part of our article (about headers and headings), a video clip has also been prepared for you, dear readers:

In my opinion, friends, we have discussed all the issues that may arise when working with inscriptions and table headers in Word 2016. I hope you understand everything. If I missed something, ask questions in the comments. The next “Crib Sheet” will be about splitting and merging tables in Word. And for today I say goodbye to you. Good luck to you!

Your guide to WORD 2016 GALANT.

Here are some more articles on working with tables:

How to do calculations in Word 2016 tables
Columns and rows of a WORD 2016 table

Sometimes it becomes necessary to repeat a certain line as a heading on each page. If this is the first row of the table or the first few rows, then this is done quite simply.

However, sometimes it becomes necessary to repeat, as a heading, not the first lines, but only the second, third, etc. For example, if you look at the table below:

In this case, you need to reproduce the second line each time the table is moved to the next page. If the repetition of the second line is organized together with the first, then there are no problems.

However, if the second line needs to be repeated, but the first does not, then there is a problem, since MS Word does not provide such an option, the repeat line option is simply greyed out.

What to do in this case?

Simply setting the repetition of only the second line will not work, so you will have to use your imagination and use the tools that are provided to the user. In total, at the moment, we were able to come up with two ways that would allow us to duplicate the required line.

First way.

The idea is to create not one table, but two: the first table will consist of only one line - this is the header line, and the second - the main one - will have a numbered line as headers.

And the next step that comes to mind is deleting the line that separates the two tables, but the “smart” one converts the two tables into one and, accordingly, we come to where we started, i.e. one table in which it is impossible to repeat the second row alone. An interesting point is that even if you first take care to make the first row of the main table repeating, and merge the tables afterwards, the repeating row will also be deleted (for more details on this point, see the video).

So, in order to achieve this goal, you will have to resort to a certain trick, namely, not to delete the line, but to make it very small, one point, and, in order to further reduce the distance, set the line spacing to a minimum. If you plan to make several tables, then you should create your own style for the font size and line spacing.

The only indication that something is wrong with the table is the thicker strip separating the top of the table from the main part. To fix this, we’ll simply make the bottom border of the top table invisible.

Now nothing at all shows that instead of one table, in fact, there are two. Naturally, in the same way you can separate not just one line from above, but several.

Video demonstrating the first method of moving an arbitrary table row.

Second way.

In principle, the first method is more than enough, but there is another possibility to create an arbitrary repeating title.

With the second approach, there is no need to create two tables; one table is created, and a repeating header is created in the footers.

The essence of this method is to reduce to a minimum the distance between the table in the header and footer and the table in the text of the document, but, unfortunately, the line that appears in the header and footer after inserting the table cannot be easily gotten rid of, so you will have to use the trick from the first method, namely to make the bottom border of the table in the headers and footers invisible, and the line under the table minimal.

It is impossible to visually distinguish whether the table is in the footers or on the sheet, and the top indent can be adjusted at your discretion.