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. 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. Scroll down to the rest of the worksheet. Split and Freeze panes are mutually exclusive you can only have one or the other. 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.

Now when you scroll down, you should still continue to see the column headings. In our example, weve selected cell A2 which is just below the 'Order ID' heading. Then under the Window menu, select Freeze Panes. Select the cell that is below the left-most column heading that you wish to see. On the View tab, in the Window group, click Freeze Panes. To freeze the top row, open your Excel spreadsheet. To unlock all rows and columns, execute the following steps.ġ. Follow this guide to know how to use 'Freeze. Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen. If you wish to keep an area of spreadsheet always visible, you can use the 'Freeze panes' feature on Microsoft Excel.

How to freeze frame in excel 97