How to keep headers in excel 2016 when scrolling
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.
#How to keep headers in excel 2016 when scrolling how to
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.
If you have a usual table with one header row, the steps are very easy: So, what's the button to click, and what are the pitfalls? Step number one is to look at your data and see if you need to lock just one row with the labels, several top rows, or columns. It allows you to keep track of the data you are looking at without having to scroll back and forth to see the column or row labels. This is one of the reasons Excel keeps the commonsense "Freeze" feature for you. With new Excel capacity to hold a million rows and numerous columns with numbers, it is easy to lose the connection between the value and its meaning on line 26935.