How To Make A Row Float In Google Sheets

Last Updated on October 30, 2023 by Jake Sheridan

In this tutorial, you will learn how to make a row float in Google Sheets.

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:

Step 1

Select the last row you want to float. The selected row and all rows above it will float

Step 2

Open the View menu and hover over the Freeze submenu, then select the Up to Current Row option

Step 3

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:

Step 1

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

Step 2

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.