#Hot to freeze multiple panes in excel how to

You can freeze rows and columns that contain the dashboard so that the user can’t scroll away and the dashboard is always visible.

Apart from working with large data sets, one practical use where you may want to freeze panes in Excel is when you are creating dashboards.

You can unfreeze the frozen rows and columns at one go. Now when you scroll down or to the right, the frozen rows and columns would always be visible. You would notice two gray lines appear – one right next to the frozen columns and the other right below the frozen rows.

This will freeze the column(s) to the left of the selected cell and row(s) above the selected cell.

Select the Freeze Panes option from the drop-down.

For example, if you want to freeze two rows (1 & 2) and two columns (A & B), select cell C3.

Select a cell just below the rows and right next to the column that you want to freeze.

In such cases, it makes sense to freeze both rows and columns. In most of the cases, you would have the headers/labels in rows as well as in columns.

Now when you scroll to the right, all the columns with headers would always be visible. You would notice that a gray line appears to the right of the columns that have been frozen. This will freeze all the columns to the left of the selected cell.In the Zoom category, click on the Freeze panes drop-down.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.

#Hot to freeze multiple panes in excel how to

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).