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 option you need.

Lock specific rows or columns in place by freezing panes, so you can scroll through an Excel spreadsheet and still see the top row or left column. You can freeze just the top row and first column …

If the Print Titles ribbon button is grayed out, check to ensure that you’re not currently editing a cell or an area chart. Also, check to verify that at least one printer is set up in Windows. On the Sheet tab, in …

In the Columns to repeat at left box, type 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 could type $1:$1 in …

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 each page …

You can highlight important files, folders, or links in a document library in SharePoint in Microsoft 365 or SharePoint Server 2019 by pinning them to the top of the document library.

You can add columns, rows, or cells to an Excel worksheet or delete them. Columns insert to the left, rows above, and cells above or to the left.

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 could type $1:$1 in …

You can also set your data up as an Excel table, which can automatically set the first row as a header row. To print specific data at the top or side of each printed page—such as the names of the months …