Creating a floating header is the same process as freezing a row, in these examples we will freeze the first row which is also the header row. We will first achieve this by using the menu method and then by using the drag method.
An example dataset has been created for this demonstration. You can follow along by clicking here to access our sample sheet:
In the dataset select a cell in the row you want to freeze. We want to freeze the header row we will select a cell in the header row.
From the View option in the top tool-bar select Freeze followed by 1 row. There are several other options in this menu but for this example we just wish to freeze the header row.
With the freeze applied scroll down. The header row remains locked in place.
The grey line above the label of row 1 is the freeze line. See that the cursor turns to a hand icon when you hover over this.
Click and drag the grey line underneath the label of the header row and release to apply the freeze.
Scroll down. The header row remains locked in place.
We hope this article has helped you and given you a better understanding of how to freeze a header row in Google Sheets. You might also like our articles on how to make a row sticky in Google Sheets and how to freeze multiple rows in Google Sheets. We also recommend reading our guide on how to mail merge in Google Sheets.
