First, go to the worksheet where you want to freeze the first two rows.Now, if we want to freeze the first two rows of the dataset, then here are the involved steps. Let’s assume we have a dataset of students’ language-wise test scores. And, this time you can use the Freeze Panes option again. Unlike the previous method, you can freeze a set of rows too. ➤ Then, go to the View tab, select Unfreeze Panes from the Freeze Panes drop-down. ➤ Initially, go to the worksheet where the row is frozen. If you want to unfreeze the rows, then follow the below steps:

A gray straight line under the row indicates the locked row.

Consequently, the top row of our dataset is frozen.

Next, go to the View tab, select Freeze Top Row from the Freeze Panes drop-down.

First, go to the worksheet where you want to lock the top row.

Now, we will apply the ‘ Freeze Panes’ option to freeze the header row. For example, we have a dataset containing students’ names and test scores. Freeze Top Rows in Excel Using Freeze Panesįreezing Panes is one of the easiest options to lock rows in Excel. Reading through it, it sounds a bit involved, but it will work, and because of the peculiarities of Excel's DV you are limited in ways to do this.6 Methods to Freeze Rows in Excel 1. You say 'yes' and the values contained in 'Names' will update accordingly. Then every time Children.xls is opened, it will ask if you want to update the linked formulae to Master.xls. Rather than the names be stored in Children.xls, they would be better stored as a dynamic link to Master.xls, so A1 on Sheet2 of Children.xls (the first cell of Names) might have the formula : The range 'Names' might have the names 'John', 'Jack', 'James' etc. Children has the DV on Sheet1 and that 'Name' is on Sheet2 and occupies the range A1:A10. Let's say that you have two files, Children.xls and Master.xls. What you need to find out is the range that is defined by the name 'Names'. A named range is basically a range of cells that is defined by a name. You define a named range by going to Insert > Name > Define. There is a named range set up called 'Names'.

Stacking excel drop downs excel 2016