Lock Header Record For Free

To freeze the top row or first column: From the View tab, Windows Group, click the Freeze Panes drop down arrow. Select either Freeze Top Row or Freeze First Column.

How to Unlock a Locked Header in Excel. To unlock a locked header in Excel, simply unfreeze the panes by selecting the cell beneath the frozen row and to the right of the frozen column.

On the View tab, in the Window group, click the arrow below Freeze Panes. time, click Freeze Panes. Unfreeze Panes so that you can unlock any frozen rows or columns.

On the Page Layout tab, in the Page Setup group, click Print Titles. A page setup box will appear. To repeat Row 1 at the top of every printed page, select row 1 in the corresponding box, and then click OK (note that you can repeat columns at the left of each printed page in a similar way).

To unlock frozen rows and/or columns, go to the View tab, Window group, and click Freeze Panes > Unfreeze Panes.

Select the row below the row(s) you want to freeze (select row 6, if you want to freeze rows 1 to 5). On the View tab, click Freeze Panes > Freeze Panes.

Here's how: On the Insert tab, in the Text group, click Header & Footer. This will display the worksheet in Page Layout view and get the Design tab to appear. On the Design tab, in the Header & Footer group, click the Header or Footer button, and select the built-in header or footer of your choosing.

To get the header to stay in place when scrolling, you can use CSS position: fixed; property on the header element. This will allow the header to stay at the top of the page, even when the user scrolls up or down the page.