How To Make A Row Float In Google Sheets
When scrolling through large datasets in Google Sheets, it’s easy to lose track of what data is stored in each column as soon as the headers scroll out of view.
Instead of scrolling back and forth to check headers each repeatedly, you can make the top row (or rows) float so they never scroll out of view.
Google Sheets makes it easy to do this with just a few clicks
Make a Row Float Using the Menu
To make one or more rows at the top of your spreadsheet float at the top and not scroll, follow these steps:
Select the last row you want to float. The selected row and all rows above it will float
Open the View menu and hover over the Freeze submenu, then select the Up to Current Row option
The selected row or rows will now be frozen and float at the top of the spreadsheet when you scroll. You can see which row(s) are frozen by the light grey line that separates the frozen and unfrozen rows
Make a Row Float by Dragging
In addition to the menu option, you can also freeze rows using the dragging shortcut:
In the upper left corner of the spreadsheet, there is an empty grey box. Locate the heavy grey line that divides this box from the row 1 label below it. This is the handle we’ll use to freeze rows using the dragging shortcut
Click on the grey divider line and drag it down over all the rows you want to freeze and release to freeze those rows
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to make a row float in Google Sheets. Want more? Check out all the Google Sheets Tutorials.
Get more Google Sheets stuff
Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.
Thank you for subscribing.
Something went wrong.