Select the top-most cell in the column which is right next to the columns that contain headers.If you have more than one column that contains headers/labels, you may want to freeze all of it. If you insert a column to the left of the column that has been frozen, even the inserted column is frozen.įreeze/Lock More than One Column in Excel.You need to use the unfreeze option in the Freeze Panes drop-down. Once you freeze a column, you can not use Control + Z to unfreeze it.Now when you scroll down, the left-most column would always be visible. You would notice that a gray line now appears at the right border of the left-most column. This will freeze the left-most column of the data set.In the Freeze Panes drop-down, select Freeze First Column.
Here is how to freeze the left-most column: In such cases, it’s a good idea to freeze the left-most column so that the headers are always visible to the user.įreeze/Lock the Left-Most Column in Excel If you are working with a dataset that has headers/labels in a column and the data is spread across many columns, as soon as you scroll to the right, the header would disappear. In the Freeze Panes drop-down, select the option to Unfreeze Panes.Įxcel Freeze Panes Options – Freezing Column(s).Now when you scroll down, all the header rows would always be visible. You would notice that a gray line now appears right below the rows that have been freezed. This will freeze all the rows above the selected cell.In the Freeze Panes drop-down, select Freeze Panes.Select the left-most cell in the row which is just below the headers row.If you have more than one header rows in your dataset, you may want to freeze all of it. Now when you scroll down, the row that has been frozen would always be visible. You would notice that a gray line now appears right below the first row. This will freeze the first row of the data set.Here are the steps to freeze the first row in your dataset: In such cases, it’s a good idea to freeze the header row so that these are always visible to the user. If you are working with a dataset that has headers at the top row and a dataset that spans hundreds of rows, as soon as you scroll down, the headers/labels would disappear. Let’s see how to use these options to Freeze Panes in Excel while working with large data sets: Freezing Row(s) in Excel You can use these options to lock rows or columns (or both) into panes in Excel. Freeze First Column: It freezes all the columns to the left of the active cell.
Freeze Top Row: It freezes all the rows above the active cell.Freeze Panes: It freezes the rows as well as the columns.It shows three options in the Freeze Panes drop-down: In the Zoom category, click on the Freeze panes drop down.Freeze/Lock More than One Column in Excel.Freeze/Lock the Left-Most Column in Excel.Excel Freeze Panes Options – Freezing Column(s).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. 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.