How to print the same values \u200b\u200bon each page. Print through lines in Excel

It is often required that when printing a table or other document, the header is repeated on each page. Theoretically, of course, you can determine the boundaries of the pages through the preview area and manually enter the top of each of them. But this option takes a lot of time and will lead to the rupture of the integrity of the table. This is all the more inappropriate, considering that there are tools that are able to solve the task much easier, faster and without unnecessary gaps.

The principle of solving this problem excel tools It is that the title will be entered only once in one place of the document, but when printing is displayed on each page being printed. You can use one of two options: Use footer or end-to-end rows.

Method 1: Using footers

Footers are the upper and lower fields of the page in Excel, which as usual mode The works are invisible, but if you make data in them, they will be displayed on prints on each printed element.

1. Edit footers can be transferred to mode excel works "Page layout". This can be done by applying several action options. First of all, switching to the mode of operation you need, clasping on the icon "Page layout". It is located on the right side of the status string and is the central of the three to switch the document viewing modes.

   

   The second option provides for pre-switch to the tab. "View" And, being there, click on the icon "Page layout"which is placed on the ribbon in the tool block "Book viewing modes".

   

   In addition, there is another option to turn on the screening of footers in electronic book. Go to the tab "Insert" and click on the button "PERSONS" in the settings group "Text".



2. After we switched to view mode "Page layout"The sheet was divided into elements. These elements will just be on the print to go out as separate pages. At the top and bottom of each such element there are three fields of footers.



3. For the title table, the top central field is most suitable. Therefore, we install the cursor and simply write the name that we want to assign a tabular array.



4. If you wish, the name can be formatted by the same tape tools that are designed to format data on the usual sheet range.



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

   

   You can also go to the tab "View"Click on the tape button called "Normal"which is located in the block "Book viewing modes".



6. As you can see, in the usual viewing mode, the name of the table is not displayed at all. Go to the tab "File"To see how it will look like.



7. Next, move to the section "Print" through left vertical menu. On the right side of the window that opened the window is the preview area of \u200b\u200bthe document. As you can see, the table name is displayed on the first page.



8. Scrolling the vertical scroll bar down, we see that the title when printing will be displayed on the second and subsequent pages of the document. That is, we decided that the task that was in front of us initially.

Method 2: Thrings

In addition, to display a document header on each sheet when printing can be used using cross-cutting strings.

So, we found out that in Excele there are two options to quickly display the header of the table on all printed sheets by attaching to this minimum effort. This can be done using footers or through lines. Each user itself is waited to decide which method is more convenient for it and is best suited to solve the task. But still it should be said that through lines provide more opportunities. First, when applied on the screen, the name can be seen not only in the special view mode, but also in the usual one. Secondly, if the header suggests the names of the name only at the very top of the document, then with the help of through lines, the name can be placed in any line of the sheet. In addition, through lines, in contrast to footers, are conceived by the developer specifically for organizing headlines in the document.

Make repeating table headers in MS Word simple enough, it is enough to highlight the string, call context menu, and on the "String" tab, select item: "Repeat as a title on each page".

Note. If you need to make a repeating arbitrary string, then how to make it described in detail.

Everything, excellent and simple, however, many tables are created and drawn up in the MS Excel table processor. How to make repeated headers here?

In Excel, the procedure for creating repeating headlines is not much more complicated, but still there are 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 item" Print headlines».

When choosing a repeat on each page "Throws", it is possible to select multiple 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 tabular processor, these menu is called more logical: " ROWS TO REPEAT AT TOP"And" Columns to Repeat at Left».

It should be noted a weighty difference in the operation of these functions in MS Word and MS Excel. In the case of a table processor, see the repetition of the rows only when previewing the document, which is prepared for printing, or after the print itself, in Word, the repetition of the tablet lines will be already visible in the document itself.

Did you ever run a long or very wide table when somewhere on the fifth page you already do not understand what kind of data are we talking about? Of course, people came up with ways to make such a job more comfortable, for example, after the header lines inserted the line with the count numbers. But it did not help too much. Excel developers solved this problem by inventing through lines. This article will help you master the techniques of working with this tool.

The figure shows a table that occupies not one page. For comparison, the appearance of the first and second page in printing ( preview). The headers of the graph is not visible, including the string with their numbers.

To correct this flaw, do the following:

on the tab Page layout Find a team Print headlines;

in the window that opens, do not write anything in the field Thrings, And specify the desired string with the mouse and view the document (for this, click on the corresponding button in the same window).

By the way, to see the second page, use the flipping buttons to the left below the page.

If you need to repeat not one, but several rows (for complex headers), then filling the field Thrings, Highlight numbers of all lines, cells from which should be on each sheet.

For wide tables, it is necessary to print on each page of the name of the rows. In this case, the algorithm of actions is the same, but by installing the cursor in the field Through columns, Highlight the cells from which should be repeated.

What pages look like after installing through columns, you can see in the picture.

What can the user be encountered when working with this tool? Most often questions arise about the unavailability of the button Print headlines. This situation is possible if:

you never searched Excel documents before printing and do not suspect that you have no printer;

you worked with a diagram, and not clicked outside;

you did not complete the editing of the cell and the cursor is still inside it.

If suddenly, for some reason, you need to refuse to print selected rows on each page, or change the list of repeated rows, then in the Clean all fields in the dialog box, and, if you wish, specify the strings or the rebound.

All the techniques with which you met in this article are available in different versions Excel, with the only difference that in some cases (for example, Excel 2003.) The dialog box needs to open the page Parameters command.

Today I want to tell you about small but important functionwhich is hidden from Excel users views. From this article you will learn how to enable the print headers and columns on each page.

I am confident that many who have to print big and complex documents Excel, faced with this problem as often as me. You can fix the string with headlines and flip the document on the computer screen without losing sight of the columns name. However, when the same document goes to the printer, the upper line is printed only on the first page. If you are tired of turning printed pages back and forth, trying to figure out what the data is contained in this line or in the column, carefully read this article and very soon know the solution to the problem.

Repeat a string with headers on each printed page

So, the Excel document turned out very long, and it must be printed. Opening the preview before sending to the printer, we discover that the string with columns headers is present only on the first page. Do not worry! Using the page parameters in Excel, we will configure the output of the headers on each printed page.

Note: The mouse pointer took the type of black arrow. Now the whole string will be selected with one click.

Comment: To highlight a few rows, hover the mouse on the first of them, click and holding left button Mice pressed, stretch to the last line.

Comment: Steps 6-8 You can skip and enter a link to the range using the keyboard. However, be careful when entering - you need to use an absolute link (with a $ sign). For example, to display the first string on each printed page, the link must be recorded as follows: $1:$1 .

Ready! Now it will be completely clear what the columns mean on each page.

Repeat column with headers on each printed page

If the work sheet is too wide, then the column with headlines will be printed only on the first page. To make a document more understandable to read, execute the following steps and place a column with headers on the left side of each page sent to the printer.

Now we will not have to overflow the pages to back to reveal that the data is in each line.

Print numbers rows and letters of columns

When recording references to cells in Excel, the columns are usually denoted by letters (a, b, c), and the lines are numbers (1, 2, 3). These letters and numbers are called row headers and sheet columns. Unlike cells with headlines that are displayed by default only on the first page, the headers of the strings and columns of the sheet by default are not printed at all. If necessary, these letters and numbers are visible when printing, you need to do this:

Comment: If the dialog box is open Page settings (Page SETUP), then on the tab Sheet (Sheet) Check in the section Print (Print) in the string String and columns headers (Row and Column Headings). Now the headings of strings and columns leaf Excel Also will be visible on each printed page.

That's better?

Printing headlines greatly simplifies work with paper instances of the Excel sheet. Line headers and columns printed on each page facilitate the perception of the information contained in the document. It is much easier to not be confused among the printed pages of the document if the names of the rows and columns are visible on each of them. Try and see how convenient it is!

If in Microsoft Word. You created a table of large sizes, which occupies more than one page, for the convenience of working with it may be needed to make the display of the header on each page of the document. To do this, you will need to configure the automatic transfer of the title (the same cap) for subsequent pages.

So, in our document there is a large table that already occupies or only will take more than one page. Our task is to configure this very table so that its hat automatically appears in top string Tables when moving to it. On how to create a table, you can read in our article.

Note:To transfer a table with a table consisting of two or more rows, it is necessary to highlight the first string.

1. Install the cursor in the first header line (first cell) and select this string or string from which the cap consists.

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

3. In the tools section "Data" Select a parameter.

Ready! With the addition of rows in the table that will be transferred to the next page, the cap will first be automatically added, and there are already new lines behind it.

Automatic Transferring Not First Row Table Hat

In some cases, the table hat may consist of several lines, but automatic transfer is required only for one of them. This, for example, may be a string with column numbers, located under a string or rows with basic data.

In this case, you first need to divide the table by making the row with the cap you need, which will be transferred to all subsequent pages of the document. Only after that for this line (already caps) you can activate the parameter "Repeat the headlock strings".

1. Install 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 a parameter "Divide the table".

3. Copy the string from the "big", the main header of the table, which will perform the cap on all subsequent pages (in our example it is a string with the names of columns).

Tip: Use the mouse to highlight the line by moving it from the beginning to the end of the string to copy the key "Ctrl + C".

4. Insert the copied string in the first line of the table on the next page.

Tip:Use the keys to insert "Ctrl + V".

5. Highlight a new cap using the mouse.

6. In the tab "Layout" Click on the button "Repeat the headlock strings"located in the group "Data".

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

Removing the header on each page

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

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

2. Click on the button "Repeat the headlock strings" (Group "Data").

3. After that, the cap will be displayed only on the first page of the document.

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