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, in Figure 2, under Print title, at the top header row, click to

Select the position that the arrow in the diagram points to, and then return to the worksheet and select

Choose the table row you want to fix as the header, if you select 1, 22 lines, then

Appears as "$1:$2" at the top header row. Similarly, you can also use the same

In the "left-side header column," Select the table column you want to fix as the table side, fake

If you select 1, 22 lines, at the top header row should appear 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 you add

Less data, do not have to worry about the header and the table side, when printing each page will automatically add the header and the table side, you can preview the first look at

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

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".