#How to freeze top 3 rows in excel 2016 how to

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.

#How to freeze top 3 rows in excel 2016 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).