Fonte Congele ou bloqueie linhas e colunas
To keep an area of a worksheet visible while you scroll to another area of the worksheet, you can lock specific rows or columns in one area by freezing or splitting panes.
When you freeze panes, you keep specific rows or columns visible when you scroll in the worksheet. For example, you might want to keep row and column labels visible as you scroll.
On the worksheet, do one of the following:
- To lock rows, select the row below the row or rows that you want to keep visible when you scroll.
- To lock columns, select the column to the right of the column or columns that you want to keep visible when you scroll.
- To lock both rows and columns, click the cell below and to the right of the rows and columns that you want to keep visible when you scroll.
On the View tab, in the Window group, click the arrow below Freeze Panes.
Then do one of the following:
- To lock one row only, click Freeze Top Row.
- To lock one column only, click Freeze First Column.
- To lock more than one row or column, or to lock both rows and columns at the same time, click Freeze Panes.