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.

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.

You can lock only specific cells and ranges before you protect the worksheet and, optionally, enable specific users to edit only in specific ranges of a protected sheet.

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.

The following sections describe how to protect and unprotect a worksheet in Excel for Windows.

By splitting the worksheet, you can scroll down in the lower pane and still see the top rows in the upper pane. To split this worksheet as shown above, you select below the row where you want the split – …

Suppose you want to protect an entire workbook, but also wants to be able to change a few cells after you enable that protection. Before you enabled password protection, you can unlock some cells in …

You can use formatting and editing restrictions to prevent content reviewers from accidentally changing an Excel spreadsheet.

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.