Through rows in Excel

When sending Excel spreadsheets to a printer, it often becomes necessary to print a specific line (lines) on all sheets. Most often, this applies to table headers and their names. In order not to have to manually copy and paste the necessary data in different parts of the document, it is enough to perform only one operation – to make the line (lines) through. In this article, we will look at exactly how this can be implemented in the program.

Making a string through

To accomplish this task, we adhere to the following algorithm of actions:

1. Switch to tab “Page layout”. Clicking on the button “Print headers” in the tool group “Page settings”.Note: at the time of editing any cell or chart, the tools in this tab will not be available. If there is no printer installed on the PC (it does not have to be connected at the moment), the functionality will also be inactive.
2. A window with page options will appear. Being in the tab “Sheet” (should open automatically) click on the field for entering information opposite the item “cross lines”.
3. By holding down the left mouse button, we select, directly, in the table itself, a row or several rows that we want to make through. The selection must be made on the horizontal coordinate bar. Also, if desired, the coordinates of the lines can be entered manually. Press the button when ready OKAY.
4. The line(s) we have chosen will be printed on all sheets.

Checking through lines

In order to check whether we have set the through lines correctly, and how it will look when printing the table, we do the following:

1. Go to the menu “file”.
2. In the list on the left, click on the section “Seal”. In the right part of the window, we can see the document preview area – this is how it will look after printing.
3. Scrolling through all the pages of the document, we check the presence of through lines on them. You can change sheets using the scroll bar to the left of the preview area, arrows and the field for entering the desired page at the bottom, as well as by scrolling the mouse wheel.

In the same way, instead of rows, you can make columns through. In this case, you need to select the necessary elements in the table or specify the coordinates in the field opposite the parameter “through columns”.

Conclusion

Excel allows you to automate many operations when working with tables, including when it comes to printing large documents that do not fit on one page. To, for example, place the title and header of the table on each printed sheet, it is enough to make the lines with the necessary data end-to-end.