How to set fixed header in Excel

The header is fixed when viewing the Excel table

php editor Baicao shared the method of setting a fixed header in Excel. The fixed header can keep the title row always visible when the table is scrolled. Easy to view data. In Excel, you can set a fixed header through the freeze pane function. The specific operation is to select the header row to be fixed, then click the "Freeze Panes" button in the "View" tab, and select "Freeze First Row" or "Freeze First Column". In this way, you can easily achieve the effect of fixed header of Excel table.

Follow the editor's instructions and fix the meter head. No matter how it rolls or slides, the meter head will be firmly fixed on top of the form for easy viewing.

(1) If your table header has only one row, then directly select [View] - [Freeze Pane] - [Freeze First Row];

(2) If your table header has multiple rows, you must first select the row below the table header. For example, if you want to use the first two rows as the table header, select the third row, and then select the view. [View]-[Freeze Panes]-[Freeze to Row 2] under the options will do it.

At this time, no matter how many rows you scroll down in the table, the header will always be fixed there.

If you want to cancel the fixed header, click [View]-[Freeze Pane]-[Unfreeze Pane] again.

When printing an Excel table, each page has a header.

There is a lot of data, and there will be multiple pages when printing. If you want to print multiple pages, each page will have a header. header, then you can use the following method~

(1) Click [Page Layout]-select [Print Title], and click the icon to the right of the top title row in the pop-up page;

(2) At this time, the mouse will turn into a horizontal black arrow. Drag the mouse to select the row to be the header, and then click the icon on the right side of the top title row;

(3) At this time, the original window will pop up again, just click OK.

When printing multiple pages in this way, the starting line of each page will also be the header.

We also give you a tool that you must have on hand just in case: Pepsi Niu Excel Password Recovery Tool. When you forget the password to open Excel or restrict the editing password, you can use it to quickly and safely retrieve your password.

More Excel skills and tools are available at Pepsi Niu! www.passneo.cn

The above is the detailed content of How to set fixed header in Excel. For more information, please follow other related articles on the PHP Chinese website!