Step 2: Go to VIEW tab > Freeze Panes > Freeze Top Row. Step 1: Select the worksheet where you want to freeze your top row.
![how do i freeze top rows in excel how do i freeze top rows in excel](https://www.customguide.com/images/pages/excel/how-to-freeze-a-row-in-excel.png)
Let’s look at the below steps to understand the method. To freeze the first 4 columns, select column E (the fifth column) and click the magic Freeze button, etc. So, in excel, we have an option called Freeze Top Row, which holds on to the top row when scrolling down and helps us see the heading all the time. In the drop-down menu, select Freeze Panes. Click the View tab in the Ribbon and then click Freeze Panes. If you want to freeze row 2 but do not want to freeze any columns, click in A3. For example, if you want to freeze row 6 and column A, click in B7. Note: to unlock all rows and columns, click the Freeze button again. Click below the row you want to freeze and to the right of the column you want to freeze. Scroll down to the rest of the worksheet. Another solution is to format the spreadsheet as an Excel table. To freeze the top row, select row 2 and click the magic Freeze button.ħ. This freeze row example is perhaps the most common because people like to lock the top row that contains column headers, such as in the example below. 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. Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training. Go to the View tab, then in the Window group, from the Freeze Panes dropdown, select Freeze Panes. Excel automatically adds a dark grey horizontal line to indicate that the first three rows are frozen. Just as when you are trying to freeze rows in any Excel data set, click in the row under the top row of the pivot table.
![how do i freeze top rows in excel how do i freeze top rows in excel](https://cdn.ablebits.com/_img-blog/freeze-panes/freeze-columns-excel.png)
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. To unlock all rows and columns, execute the following steps.ġ.
![how do i freeze top rows in excel how do i freeze top rows in excel](https://cdn.ablebits.com/_img-blog/freeze-excel/freeze-multiple-rows-excel.png)
Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.