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.

How to freeze columns, rows, or panes so that they are visible as you scroll through large worksheets.

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 …

You're scrolling down your worksheet (or scrolling to the side), but part of it is frozen in place. This is probably because at some point you decided to freeze the panes. To fix this, click View > …

Need more help? You can always ask an expert in the Excel Tech Community or get support in Communities.

Freeze columns and rows to keep them in view while you scroll through your data. Select the cell below the rows, and to the right of the columns you want to freeze.

Como congelar painéis no Excel para manter linhas ou colunas em sua planilha visíveis enquanto você rola ou bloqueia-os no local para criar várias áreas de planilha.

Excel Enter and format data Layout Split panes to lock rows or columns in separate worksheet areas

Because Excel for the web runs in your web browser, the keyboard shortcuts are different from those in the desktop program. For example, you'll use Ctrl+F6 instead of F6 for jumping in and …

If you don't want content reviewers to accidentally change a Word document or an Excel spreadsheet, you can use formatting and editing restrictions. Note: To further restrict reviewers …