How to set the window freeze in Excel and print the title bar per page

1. Freeze the window so that the title does not change with the number of pages when dragging

You can lock a row or column by selecting a row or column, a window--a frozen pane. To lock a row and column at the same time, you need to select the cell that is between this row and the column.

As shown in the figure, when a cell is selected and the frozen pane is lit, the type column and the Acer row are fixed when they move.

2. Excel prints title bar per page

FILE--Page Setup--Worksheet

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/Office/excel/