How to set the title row in Excel and process the title row in Excel worksheet

How to set the title row in Excel and process the title row in the worksheet

It is common to create dozens or hundreds of rows of tables in Excel. When looking at the lower part of the data, you cannot see the table's title line, which makes you confused what the astronomical numbers in each column mean. In addition, when the output is printed normally, only the first page can print the title line, and the rest of the pages are bald, and the last few pages are unknown. We can see how to solve this problem.

1. display the title line on each page

Click the front-end cell at the bottom of the row under the table heading line, and click "window"> split. The table is split into the upper and lower parts, and the first part is displayed as the heading line, the second part shows the specific table data (1), and then click the "window" menu → freeze the window. Then, I will try to flip the page to see it, is there a title line on each page (2 ).

Note: If you want to freeze one or more columns on the left, click the first or second row at the top of the table header line ...... Cell, because the split window is based on the cell where the cursor is located. However, the cursor can also be split at any place, and then point the mouse pointer to the horizontal or vertical split line. When the mouse pointer turns into a bidirectional arrow, hold down the left button and drag it to the desired place, if there is no frozen content on the left side, drag the vertical split line to the left of column A, that is, do not perform Vertical Split. (3)

2. Print and output each page with a title line

Click "file" menu → page settings. In the displayed "page settings" dialog box, click the "worksheet" tab and click the Red Arrow behind the "top heading line" box (4) open the "page settings-top title row" dialog box, and then select the title row to be printed on each page in the worksheet, in this case, "$1: $1" is displayed in the "page settings-top heading line" box ", this indicates the title line from the first line to the first line when printing the output on each page (we can also directly enter $1: $, 3… without selecting the title line ......). (5)

Click X or the Red Arrow behind the box to exit the "page settings-top title line" dialog box, finally, click the "OK" button (whether you have found the print method for the title column ). In this way, the title line is displayed on each page.