In Excel Where Is Freeze Panes?
Freeze Columns and Rows Select the Cell Below the Rows and to the Right of the Columns You Want to Keep Visible When You Scroll. Select View > Freeze Panes >...
Freeze columns and rows
- Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
- Select View > Freeze Panes > Freeze Panes.
Where do I find freeze panes in Excel?
From the View tab, Windows Group, click the Freeze Panes drop down arrow. Select either Freeze Top Row or Freeze First Column. Excel inserts a thin line to show you where the frozen pane begins.
How do you freeze the second row in Excel?
How to freeze a set of rows in Excel
- Select the row below the set of rows you want to freeze.
- In the menu, click "View."
- In the ribbon, click "Freeze Panes" and then click "Freeze Panes."