How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.

If you want the row and column headers always visible when you scroll through your worksheet, you can lock the top row and/or first column. Tap View > Freeze Panes, and then tap the …

On the View tab, select Freeze Top Row. When you do this, the border under row 1 is a little darker than other borders, meaning that the row above it is frozen.

Print column headings on each page of your worksheet so your readers won’t have to go back to the first page to see the headers.

If a worksheet spans more than one page, you can print row or column headers or labels (also called print titles) in the first row or mutliple rows on every page.

In the table, right-click in the row that you want to repeat, and then select Table Properties. In the Table Properties dialog box, on the Row tab, select the Repeat as header row at the top of …

In the Columns to repeat at left box, enter the reference of the columns that contain the row labels. For example, if you want to print column labels at the top of every printed page, you …

To insert a single row: Right-click the whole row above which you want to insert the new row, and then select Insert Rows. To insert multiple rows: Select the same number of rows above which …

Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities. See Also Copy and paste a formula to another cell or worksheet Switch …

Learn how to create your own custom postal code format in Excel, and format numbers as postal codes.