To freeze the first 4 columns, select column E (the fifth column) and click the magic Freeze button, etc. Note: to unlock all rows and columns, click the Freeze button again. Whereas you are able to do this manually it is sensible to make use of VBA to pick the row and freeze the pane. Each time you will have a considerable amount of knowledge, it may be useful to maintain a selected row in sight whenever you scroll down the display. Scroll down to the rest of the worksheet. How To Freeze A Specific Row In Excel Using VBA. To freeze the top row, select row 2 and click the magic Freeze button.ħ.

Under Choose commands from, select Commands Not in the Ribbon.Ħ. The orange region above row 3 and to the left of column C is frozen.Īdd the magic Freeze button to the Quick Access Toolbar to freeze the top row, the first column, rows, columns or cells with a single click.ģ. To freeze cells, execute the following steps. Excel automatically adds a dark grey vertical line to indicate that the first four columns are frozen. All columns to the left of column E are frozen. To freeze columns, execute the following steps. Excel automatically adds a dark grey horizontal line to indicate that the first three rows are frozen. Scroll down to the rest of the worksheet. On the View tab, in the Window group, click Freeze Panes.Ĥ. To freeze rows, execute the following steps.Ģ. Excel automatically adds a dark grey vertical line to indicate that the first column is frozen. To freeze the first column, execute the following steps. On the View tab, in the Window group, click Freeze Panes. You will need to use Freeze Panes to freeze multiple rows or columns. To unlock all rows and columns, execute the following steps.ġ. Use the Text to Columns wizard on each column and at step 3 choose the format as Text. Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.

Freeze top 3 rows in excel 2016