On the view tab click freeze panes freeze panes. Next switch to the view tab click the freeze panes dropdown menu and then click freeze panes.

How To Freeze The Size Of The Cells In A Table In Word Words

Select view freeze panes freeze panes.

How to freeze cells in excel. If you want to freeze columns select the cell immediately to the right of the. Here we want to freeze row five and column b so we ll select cell c6 by clicking it. Select the row or the first cell in the row right below the last row you want to freeze.

Select the row right below the row or rows you want to freeze. 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. Click the view tab.

Freeze the top row. Click on the tab labeled view at the top of your excel session. Click on the small arrow next to freeze panes located in the.

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. Go to the view tab.

Freeze the leftmost column. To do this select the uppermost and leftmost cell that you don t want to freeze. In case you want to lock several rows starting with row 1 carry out these steps.

How to freeze a row in excel. Select the freeze panes command and choose freeze panes that s all there is to it. How to freeze cells in excel freezing cells determine what you want frozen.

Freeze columns and rows.