Here we discussed How to Freeze Rows in Excel and different methods and shortcuts to Freeze Rows in Excel, along with practical examples and a downloadable excel template. This has been a guide to Freeze Rows in Excel. Make sure you have selected the right cell to freeze.
I am sure you had found it like a walk-in-the-park process you did not even have to do anything special to freeze your top row. We have seen how to freeze the top row in the Excel worksheet. You have frozen your top row to see the top row when you are scrolling down.Įven though I am in the 281 st row, still I can see my headers.įreeze or Lock Multiple Rows – Example #2 Step 2: Go to VIEW tab > Freeze Panes > Freeze Top Row. Step 1: Select the worksheet where you want to freeze your top row. Let’s look at the below steps to understand the method. 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. To freeze the first 4 columns, select column E (the fifth column) and click the magic Freeze button, etc.It is very difficult to see all the headers when we are scrolling down. 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. Also, if you use header columns and rows data references follow these, just look in the formula editor. If you click on the arrow you have options of relative reference, absolute column, absolute row, or absolute column and row. Excel automatically adds a dark grey vertical line to indicate that the first four columns are frozen. When you reference a cell or cells in a formula you can click on the cell reference in the formula and an arrow appears. 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. 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.ġ. Excel automatically adds a dark grey horizontal line to indicate that the top row is frozen.