Header footer fixed Print in Excel

In peacetime work, the use of Excel to prepare the form does bring us a lot of convenience, however, when a sheet of data, such as hundreds of units of the payroll, printing due to the size of the paper is limited, it is not possible to print on a page, which requires multiple pages of printing, if each page to make the table head, Even if you use the method of replication is very cumbersome, and when you need to insert or reduce personnel, but also manually adjust the header of each page, I take Excel2000 as an example, introduced a simple fixed table head and table side method. First, we need to tell you that in an Excel table, the header is called the header row, and the table side is called the header column. Let's start by opening an Excel file that needs to fix the header row or header column, click the Page Setup menu item in the File menu, open the Page Setup interface, and select the worksheet, as shown in Figure 1.

tab, click to select the top heading row under Print title in Figure 2, select the position that the arrow in the diagram points to, and then go back to the worksheet and select the table row that you want to fix as the header, if you select 1, 22 rows, then display as "$1:$2" at the top header row. In the same way, you can use the same method to select the table column you want to be fixed as the table side in the "Left header column", if you select 1, 22 rows, then the "Top header row" should be displayed as "Figure 1$1:$2". Click the OK button in the page Setup interface so that you

Figure 2

Figure 3

The 1th, 2, and 1th columns in the current worksheet have been fixed. All you have to do is add the data to the following table body, and no matter how much data you add, you don't have to worry about the header and the table side, each page will automatically add the header and the table side when you print, so you can preview it first to see

//------------------------------------------------------------------------------------------------------------- --------------------------------------------------

End of table

When you make page setup, click Header/Footer and custom footer, and then enter and format and position the footer in the left, center, and right footers by the last line of the table. "OK".