Internet Scholar

Freeze the leftmost column. Freeze the top row.

Keep Excel Headings In Place With The Freeze Panes Option

How to freeze lock in place a cell in excel steps select the row s or column s located just below or to the right of the row s or column s you want frozen.

How to freeze cells in excel. To do this select the uppermost and leftmost cell that you don t want to freeze. Select the row or the first cell in the row right below the last row you want to freeze. Click the view tab.

Click on the small arrow next to freeze panes located in the. How to freeze cells in excel freezing cells determine what you want frozen. Here we want to freeze row five and column b so we ll select cell c6 by clicking it.

Go to the view tab. If you want to freeze columns select the cell immediately to the right of the. Click on the tab labeled view at the top of your excel session.

In case you want to lock several rows starting with row 1 carry out these steps. Next switch to the view tab click the freeze panes dropdown menu and then click freeze panes. Select the row right below the row or rows you want to freeze.

Select view freeze panes freeze panes. Select the cell below the rows and to the right of the columns you want to keep visible when you scroll. Freeze rows or columns.

Select the freeze panes command and choose freeze panes that s all there is to it. How to freeze a row in excel. Freeze columns and rows.

On the view tab click freeze panes freeze panes.