Lock Up Columns Release For Free

You're scrolling down your worksheet (or scrolling to the side), but part of it is frozen in place. This is probably because at some point you decided to freeze the panes. To fix this, click View > Window > Unfreeze Panes.

To unlock all the rows and columns, follow the steps mentioned below: Go to View > Freeze Panes > Unfreeze Panes. Click on Unfreeze Panes.

How to freeze multiple columns in Excel. In case you want to freeze more than one column, this is what you need to do: Select the column (or the first cell in the column) to the right of the last column you want to lock. Go to the View tab, and click Freeze Panes > Freeze Panes.

Freeze as many rows or columns as you want To freeze multiple rows (starting with row 1), select the row below the last row you want frozen and click Freeze Panes. To freeze multiple columns, select the column to the right of the last column you want frozen and click Freeze Panes.

Step 1: Select the cell E1. This is because the first four columns are to be frozen. Step 2: In the View tab, click the ?freeze panes? drop-down under the ?window? section. Select ?freeze panes,? as shown in the succeeding image.

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.

Freeze columns and rows in Excel Select the row below the row(s) you want to freeze (select row 6, if you want to freeze rows 1 to 5). On the View tab, click Freeze Panes > Freeze Panes.