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.
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 or multiple rows and columns.
Freeze panes to lock the first row or column in Excel for Mac
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.
Recent versions (2503 onwards) include critical fixes for PivotTable refresh performance, freeze panes rendering, and geometric shape loading. Ensure you are running the latest Current Channel version for optimal performance.
Freeze columns in a Data Model in Power Pivot - Microsoft Support
How to freeze columns, rows, or panes so that they are visible as you scroll through large worksheets.
Freeze panes to lock the first row or column in Excel for iOS
To keep an area of a datasheet visible in Access while you scroll to another area, you can freeze one or more of the fields (columns). The fields that you freeze move to the leftmost position on the datasheet.
Work with stocks and geography data Turn your data into insights List of all Excel functions available VLOOKUP function IF function Create a drop-down list Combine text from two or more cells Freeze panes to lock rows & columns Create a PivotTable to analyze worksheet data Design the layout and format of a PivotTable Sort data in a PivotTable ...