Let's consider To
How to fix a table title in Excel, how to setup printing rows, columns on each Excel page, fix 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 circled 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 check the box next to the “grid” function, a grid will be printed Excel sheet gray dotted line (where cell boundaries are not drawn).
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 "
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 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.
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.
In this lesson I will tell you how to attach a header to each Excel page. This may be necessary if you are working with large tables. Usually, when they are printed, documents with a large number of pages are produced, and in order to make it convenient to work with them, it is necessary to save the table header on each sheet.
Excel has a built-in feature to place a header on all pages of a document. Open the table and go to the “Page Layout” tab and click on the “Print Headings” icon.
The Page Setup window opens. Here, on the “Sheet” tab in the “Print on each page” settings block, we need to indicate which rows and/or columns need to be continuous.
Click on the special icon in the “End-to-end rows” field and select the range in the table. You can also select “End-to-end columns”. After selecting the rows, press the Enter key to return to the sheet tab.
Finally, click the “Ok” button. Now, if you print the table, the specified header will be on all pages.
It is worth noting that if in the future you have to delete or add new rows in the table, then when printed, the header will be in the same place at the beginning of each sheet.
Today I’ll tell you how to solve the problem when Excel columns indicated by numbers. The situation may be familiar to many. you open Excel file and in the column labels there are numbers instead of letters. The addresses in this case have the unusual spelling R1C1, R1C3, etc.
In this lesson we will look at Excel functions, which are in the status bar. The status bar in Excel is represented by a strip at the very bottom of the program window, where you can display additional information.
In this lesson I will tell you how to freeze a row or column in Excel. Pinned areas will always be visible on the screen when scrolling vertically or horizontally.
In this lesson I will tell you how to make a drop-down list in Excel. Basically, it is created for one purpose - to limit the possibility of entering data to a certain list. For example, when there is a special cell in the table in which you mark which department this or that employee belongs to. This list is always the same. It is much more convenient to select a department from the list than to enter it manually each time or copy it from other cells.
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...
