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 going to the mode Excel work "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 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" through 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 vertical stripe Scrolling down, we see that the header, when printed, will appear on the second and subsequent pages of the document. 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.
Long tables with a large number of rows are very inconvenient because you constantly have to scroll up the sheet to see which column of the cell corresponds to the specific name of the header section. Of course, this is very inconvenient, and most importantly, it significantly increases the time spent working with tables. But the program Microsoft Excel offers the ability to pin the table header. Let's figure out how to do this.
If the table header is on the top line of the sheet and is simple, that is, it consists of one line, then, in this case, fixing it is quite simple. To do this, go to the “View” tab, click on the “Freeze Areas” button, and select the “Freeze Top Row” item.
Now, when scrolling the tape down, the table header will always be located within the visible screen on the first line.
Securing a complex hat
But this method of attaching a header to a table will not work if the header is complex, that is, it consists of two or more lines. In this case, to secure the header, you need to secure not only the top line, but an area of the table consisting of several lines.
First of all, select the first cell on the left, located under the table header itself.
In the same “View” tab, again click on the “Freeze areas” button, and in the list that opens, select the item with the same name.
After this, the entire area of the sheet located above the selected cell will be frozen, which means the table header will also be frozen.
Securing the header by creating a “smart table”
Often, the header is not located at the very top of the table, but slightly lower, since the name of the table is located on the first lines. In this case, of course, you can pin the entire header area along with the name. But, fixed rows with names will take up space on the screen, that is, they will narrow the visible overview of the table, which not every user will find convenient and rational.
In this case, creating a so-called “smart table” is suitable. In order to use this method, the table header should consist of no more than one line. To create a “smart table”, being in the “Home” tab, select together with the header the entire area of values that we intend to include in the table. Next, in the “Styles” tool group, click on the “Format as table” button, and in the list of styles that opens, select the one that you like best.
Next, a dialog box will open. It will indicate the range of cells you previously selected, which will be included in the table. If you selected correctly, then you don’t need to change anything here. But below, you should definitely pay attention that there is a checkmark next to the “Table with headers” parameter. If it is not there, then you need to put it in manually, otherwise you won’t be able to attach the hat correctly. After this, click on the “OK” button.
An alternative option is to create a table with a docked header in the Insert tab. To do this, you need to go to the specified tab, select the area of the sheet that will become a “smart table”, and click on the “Table” button located on the left side of the ribbon.
In this case, exactly the same dialog box will open as when using the method described earlier. The actions in this window must be performed exactly the same as in the previous case.
After this, when you scroll down, the table header will move to a panel with letters indicating the address of the columns. Thus, the line where the header is located will not be fixed, but, nevertheless, the header itself will always be in front of the user’s eyes, no matter how far he scrolls down the table.
Attach a header to each page when printing
There are times when a header needs to be attached to each page of a printed document. Then, when printing a table with many rows, there will be no need to identify the columns filled with data by comparing them with the name in the header, which would be located only on the first page.
To attach a header to each page when printing, go to the “Page Layout” tab. In the “Sheet Options” tool block on the ribbon, click on the icon in the form of an inclined arrow, which is located in the lower right corner of this block.
The page settings window opens. You need to go to the “Sheet” tab of this window if you find yourself in another tab. Opposite the “Print continuous lines on each page” option, you need to enter the address of the header area. You can make it a little simpler and click on the button located to the right of the data entry form.
After this, the page options window will collapse. You will need to use your mouse to click on the table header. Then, again click on the button to the right of the entered data.
Having moved back to the page parameters window, click on the “OK” button.
As we can see, visually in Microsoft editor Excel hasn't changed anything. In order to check how the document will look when printed, go to the “File” tab. Next, move to the “Print” section. On the right side of the window Microsoft programs Excel has a document preview area.
Scrolling down the document, we make sure that the table header is displayed on each page prepared for printing.
As you can see, there are several ways to attach a header to a table. Which of these methods to use depends on the table structure and why you need anchoring. When using a simple header, it is easiest to use the pinning of the top line of the sheet; if the header is multi-level, then you need to pin the area. If there is a table name or other lines above the header, then in this case, you can format the range of cells filled with data as a “smart table”. In the case when you plan to print a document, it would be rational to attach a header to each sheet of the document using the through line function. In each case, the decision to use a specific fastening method is made purely individually.
Today I want to tell you about a small but important function that is hidden from the view of Excel users. This article will show you how to print row and column headings on every page.
I am sure that many who have to print large and complex Excel documents encounter this problem as often as I do. You can pin the heading row and flip through the document on your computer screen without losing sight of the column titles. However, when the same document is sent to the printer, the top line is printed on the first page only. If you are tired of turning printed pages back and forth, trying to figure out what data is contained in this row or that column, read this article carefully and you will soon find out the solution to the problem.
Repeat the heading line on every printed page
So, Excel document It turned out to be very long and needs to be printed. When we open the preview before sending to the printer, we find that the row with column headings is only present on the first page. No need to worry! Using page options in Excel, we will configure the display of headings on each printed page.
Note: The mouse pointer changes to a black arrow. Now a single click will select the entire row.
Comment: To select multiple lines, hover your mouse over the first line, click, and while holding down the left mouse button, drag to the last line.
Comment: You can skip steps 6-8 and enter the range reference using the keyboard. However, be careful when entering - you must use an absolute link (with a $ sign). For example, to print the first line on every printed page, the link would need to be written like this: $1:$1 .
Ready! Now it will be very clear what the columns on each page mean.
Repeating the heading column on each printed page
If the worksheet is too wide, the heading column will only print on the first page. To make the document easier to read, let's do next steps and place a column with headings on the left side of each page sent to the printer.
Now we don’t have to flip pages back and forth to understand what data is in each line.
Printing row numbers and column letters
When writing cell references in Excel, columns are usually designated by letters (A, B, C) and rows by numbers (1, 2, 3). These letters and numbers are called the row and column headings of the worksheet. Unlike cells with headings, which by default are printed only on the first page, worksheet row and column headings are not printed at all by default. If you want these letters and numbers to be visible when printed, here's what you need to do:
Comment: If the dialog box is open Page settings(Page Setup), then on the tab Sheet(Sheet) check the section Seal(Print) in line Row and Column Headings(Row and column headings). Now the row and column headers Excel sheet will also be visible on every printed page.
That's better?
Printing headings makes working with paper copies of an Excel sheet much easier. Row and column headings printed on each page make the information contained in the document easier to understand. It is much easier not to get lost among the printed pages of a document if the row and column names are visible on each of them. Try it and you will understand how convenient it is!
Continuous lines are records whose contents are displayed when printing a document on different sheets in the same place. It is especially convenient to use this tool when filling out table names and headings. It can also be used for other purposes. Let's take a look at how you can organize these types of entries in Microsoft Excel.
Using through lines
In order to create a continuous line that will be displayed on all pages of the document, you need to do certain manipulations.
Now the data entered in the selected area will be displayed on other pages when printing the document, which will significantly save time compared to if you wrote and positioned (placed) the desired entry on each sheet of printed material manually.
In order to see what the document will look like when sent to the printer, go to the tab "File" and move to the section "Seal". On the right side of the window, scrolling down the document, we look at how successfully the task was completed, that is, whether information from end-to-end lines is displayed on all pages.
In a similar way, you can configure not only rows, but also columns. Simply in this case, the coordinates will need to be entered in the field "End-to-end columns" in the Page Options window.
This algorithm of actions is applicable to Microsoft versions Excel 2007, 2010, 2013 and 2016. The procedure in them is absolutely the same.
As you can see, the Excel program provides the ability to quite simply organize end-to-end lines in a book. This will allow duplicate titles to be displayed on different pages document, writing them down only once, which will save effort and time.
Loading...
