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. Scroll down to the rest of the worksheet. 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.
![freeze top rows in excel 2010 freeze top rows in excel 2010](https://www.tutorialspoint.com/excel/images/freezing_first_row.jpg)
All columns to the left of column E are frozen. To freeze columns, execute the following steps. If you are dealing with huge datasheet containing student records, then you may want to freeze top row or first column to easily understand data while scrolling up / across the datasheet. Excel automatically adds a dark grey horizontal line to indicate that the first three rows are frozen. Excel 2010 comes with Freeze Row and Freeze Column features, which make it easy to match and read details of huge data sets. A list of options appears to select the option of freeze panes which is the first option. We are going to highlight the first four rows because they are the ones we wish to lock, after that we go to the menu bar and click on view.Under view, search for freeze panes and click on it. Scroll down to the rest of the worksheet. Now that we have our excel sheet prepared, the next step will be to freeze the top 4 rows. On the View tab, in the Window group, click Freeze Panes.Ĥ. You can freeze Rows and Columns in Excel by making use of the 'Freeze Panes' option as available in the 'View' Tab located in the top ribbon menu. To freeze rows, execute the following steps.Ģ. Excel automatically adds a dark grey vertical line to indicate that the first column is frozen.
![freeze top rows in excel 2010 freeze top rows in excel 2010](https://www.addictivetips.com/app/uploads/2010/02/scrolldownthesheet1.jpg)
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. You will have three options there, choose one of them: Click on Freeze Top Row to freeze one row only. Click on the Freeze pane button in Window section. Now click on the VIEW tab on the toolbar. Select the Row or Column you want to freeze. Scroll down to the rest of the worksheet. Open your worksheet where you want to Freeze Rows/Columns.