Note: to unlock all rows and columns, click the Freeze button again. A little darker and thicker border to the right of column A means that the left-most column in the table is frozen. Scroll down to the rest of the worksheet. Freezing the first column is as simple as clicking View > Freeze Panes > Freeze First Column. 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. Here we discuss how to freeze rows and columns using Freeze Panes in excel with some examples & downloadable excel template. To freeze columns, execute the following steps. Excel automatically adds a dark grey horizontal line to indicate that the first three rows are frozen. If you are working on a large spreadsheet, it can be useful to freeze certain rows or columns so that they stay on screen while you scroll through the rest of the sheet. 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.Ģ. An alternative to split is to create a new window within Excel to view the same data. Split would allow you to view and scroll independently a vertical and or horizontal split. Excel automatically adds a dark grey vertical line to indicate that the first column is frozen. Split and Freeze panes are mutually exclusive you can only have one or the other. To freeze the first column, execute the following steps. On the View tab, in the Window group, click Freeze Panes. To unlock all rows and columns, execute the following steps.ġ.
Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.