How to Freeze Rows in Google Sheets: 5 Simple Ways to Stop Lost Headers
Learning how to freeze rows in Google Sheets takes less than a minute, and it saves you from losing your headers every time you scroll. On a computer, click View, then Freeze, then pick 1 row to pin the top row in place. The header stays visible while the rows below it scroll, so you always know which column holds the name, the date, or the amount. This guide shows five simple ways to freeze rows, plus the mobile steps and the mistakes that undo the freeze. Learning how to freeze rows in Google Sheets is a skill you will use in almost every long sheet.
Long sheets turn into a guessing game without frozen headers. Learning how to freeze rows in Google Sheets ends that guessing game. You scroll down to row 400, and the labels at the top vanish from view. You then guess whether column C holds the price or the quantity, and a wrong guess can corrupt a whole report. A frozen header row removes that guesswork, and it costs nothing to set up.
[SNIPPET TARGET] To freeze rows in Google Sheets on a computer, click View, then Freeze, then choose 1 row, 2 rows, or Up to current row. On Android, touch and hold the row number and tap Freeze. On iPhone and iPad, tap the row number and tap Freeze.
ANSWER BOX 1
To freeze rows in Google Sheets on a computer, click View, then Freeze, then choose 1 row, 2 rows, or Up to current row. A thick gray line appears under the last frozen row, and everything above it stays on screen while you scroll. To undo it, click View, then Freeze, then No rows.
ANSWER BOX 2
On the Google Sheets mobile app, there is no View menu, so you freeze from the row number itself. On Android, touch and hold the row number and tap Freeze. On iPhone and iPad, tap the row number, tap the right arrow in the menu, then tap Freeze. The mobile app only freezes the first row or the first column.
KEY TAKEAWAYS
- To freeze rows in Google Sheets on desktop, use View, then Freeze, then pick 1 row, 2 rows, or Up to current row.
- You can freeze up to 10 rows and up to 5 columns on desktop, and freezing always starts from row 1.
- On Android, touch and hold the row number and tap Freeze, while on iPhone and iPad you tap the row number and tap Freeze.
- The freeze is saved in the file, so everyone who opens the sheet sees the same frozen rows.
- Freezing never hides or deletes data, and you can remove it in two clicks with View, then Freeze, then No rows.
Contents
- What does it mean to freeze rows?
- 5 simple ways to freeze rows
- Freeze rows on Android and iPhone
- Freeze rows and columns together
- Freeze rows vs hide rows
- 5 mistakes that lose your headers
- FAQ
- Final Word
What Does It Mean to Freeze Rows in Google Sheets?
Freezing a row pins it to the top of the screen so it never scrolls away. When you learn how to freeze rows in Google Sheets, that pinned row is usually your header row. The frozen row stays visible while every row below it moves up and down as you scroll. Most people freeze row 1, because that row usually holds the column headers, such as Name, Date, and Amount. The freeze changes only the view, and it never changes the data, the formulas, or the order of the rows.
Google Sheets marks frozen rows with a thick gray line under the last frozen row. That line tells you at a glance where the frozen zone ends and the scrolling zone begins. If you freeze two rows, the line sits under row 2, and rows 1 and 2 stay put. The line is darker than the normal gridlines, so it is easy to spot even in a busy sheet.
A frozen header helps in every long sheet, from a class attendance list to a monthly budget. You can scroll to the bottom of a 500-row sales list and still see that column D is the price. That small detail stops data entry errors, because you never type a price into a quantity column by mistake. It also helps other people who open your sheet, since they see the labels at once.
Once your header stays put, the next step is to work with the rows below it. Our guide on how to filter data in Google Sheets shows how to show only the rows you need without deleting anything. Filtering pairs well with freezing, because the header stays visible while the filtered rows change.
QUICK ANSWER: Does freezing rows change my data?
No, freezing changes only what you see on screen. It never moves, hides, or deletes any cell, and it never changes a formula. The data stays exactly where it was, and only the scrolling behavior changes.
5 Simple Ways to Freeze Rows in Google Sheets
There are five ways to freeze rows, and all five give the same result. Each way to learn how to freeze rows in Google Sheets ends with the same thick gray line under your frozen rows. The View menu is the most reliable, the drag handle is the fastest, and the right-click route sits in between. The mobile app uses its own gesture, and the fifth way freezes rows and columns together. Pick the way that fits your device and your habit, and use it every time.
Way 1: Use the View menu on a computer
Open your spreadsheet in Google Sheets in a web browser. Click a cell in the last row you want to keep, such as a cell in row 2 if you want two frozen rows. Click View in the menu bar at the top, then point to Freeze in the menu that drops down. Choose 1 row to freeze only the top row, 2 rows to freeze the top two, or Up to row with the number of your selected row. Scroll down to test it, and the frozen rows stay on screen while the rest moves.
The View menu is the method Google documents on its own help page, so it works in every browser. It is also the clearest way to show someone how to freeze rows in Google Sheets for the first time. It also shows you every option in one list, which helps when you are not sure how many rows to freeze. If you pick the wrong count, just open the same menu again and pick a new one. The new choice replaces the old freeze at once, so there is no need to unfreeze first.
Way 2: Drag the gray freeze handle
Look at the top-left corner of the sheet, just above row number 1. There is a thick gray bar at the bottom of the column header area, and it is the freeze handle. Point your mouse at that bar until the cursor turns into a hand, then drag it down to the bottom of the last row you want frozen. Release the mouse, and a thick gray line appears under that row. The rows above the line are now frozen.
The drag handle is the fastest way on desktop, because it takes one motion and no menu. It is a quick way to learn how to freeze rows in Google Sheets without opening a menu. It works best when you can see the handle clearly, which is true on a large monitor. On a small laptop screen, the handle can be hard to grab, so the View menu is the safer choice there. If the drag does not work, check that you are pointing at the bar itself and not at a cell.
Way 3: Right-click a row number
Right-click the number of the last row you want to keep, such as row 3 for a three-row header. A menu appears next to the row number, and it holds a freeze option in current versions of Sheets on the web. Choose the freeze entry, and the rows from the top down to that row stay in place. Scroll down to confirm the freeze, and look for the thick gray line under row 3.
The right-click route is handy when your mouse is already on the row numbers. It is another way to learn how to freeze rows in Google Sheets from the row numbers themselves. It saves a trip to the top menu, and it feels natural if you often right-click to insert or delete rows. Not every browser version shows the same menu, so if the freeze option is missing, fall back to the View menu. The result is the same either way, so no time is lost.
Way 4: Freeze from the Sheets mobile app
The mobile app has no View menu, so freezing works from the row number. On Android, open the spreadsheet in the Google Sheets app, then touch and hold the row number of the last row to keep. Tap Freeze in the menu that appears, and the rows from the top down to that one stay in place. On iPhone and iPad, tap the row number, then tap the right arrow in the menu until you see Freeze, and tap it.
The mobile app only freezes the first row or the first column, so you cannot freeze three rows from your phone. If you need more frozen rows, set them on a computer, and the phone will respect the setting when you open the sheet. Keep frozen rows to one on a small screen, because a tall frozen zone leaves little room for the data below it.
Way 5: Freeze rows and columns together
You can freeze rows and columns at the same time, and both stay pinned while you scroll. Click View, then Freeze, and choose the number of rows first, such as 1 row. Open the same menu again, and choose the number of columns, such as 1 column. The top rows stay fixed as you scroll down, and the left column stays fixed as you scroll right. A thick gray line marks each frozen edge, one horizontal and one vertical.
This way suits wide tables where the first column holds names or IDs. It is a good way to learn how to freeze rows in Google Sheets when your table is wide. You can scroll right through twenty columns and still see whose row you are reading. It also suits budget sheets where the first column holds the category and the top row holds the month. Set the rows first, then the columns, and test both directions before you share the sheet.
How to Freeze Rows in Google Sheets on Android and iPhone
The Sheets app on Android and iPhone handles freezing with a tap gesture, and learning how to freeze rows in Google Sheets on a phone starts there, and the two platforms differ slightly. On Android, touch and hold the row number of the last row you want frozen, then tap Freeze in the menu that pops up. On iPhone and iPad, tap the row number once, then tap the right arrow in the menu that appears until you reach Freeze, and tap it. Both platforms save the freeze in the file, so it shows up on desktop too.

A frozen row on a phone takes up a bigger share of the screen than on a computer. That is why most people freeze only row 1 on mobile, even if the same sheet freezes two rows on desktop. A two-row header on a phone leaves little space for data, and scrolling becomes awkward. If the sheet feels cramped, unfreeze on the phone and refreeze on a computer with a single row.
If the Freeze option does not appear in the app menu, check your access to the file. A view-only file will not let you change the freeze, because freezing counts as an edit to the file layout. Ask the owner for edit access, or make a copy of the sheet that you own. A copy gives you full control, and you can freeze rows in it freely.
How to Freeze Rows and Columns at the Same Time
Freezing rows and columns together pins the top edge and the left edge at once. Once you know how to freeze rows in Google Sheets, adding a frozen column is the same menu, one step later. The top rows stay visible as you scroll down, and the left columns stay visible as you scroll right. The corner where they meet stays fixed in both directions, which is why this setup suits tables with both a header row and a label column. A sales table with months across the top and products down the side is a classic case.
Start with the rows, because the menu lists row choices first. Click View, then Freeze, then choose 1 row or Up to current row for a taller header. Then open the menu again and choose 1 column or Up to current column for the label column. Each choice adds its own gray divider line, so you can see both edges clearly. Scroll down and right to test the result before you move on.
| What you freeze | Menu path | Best for |
|---|---|---|
| 1 row | View, Freeze, 1 row | A single header row |
| 2 rows | View, Freeze, 2 rows | A header plus a sub-header row |
| Up to current row | View, Freeze, Up to row | A tall multi-row header |
| 1 column | View, Freeze, 1 column | A name or ID column |
| Rows plus columns | View, Freeze, rows then columns | Wide tables with labels on both edges |
Remember that the desktop limits still apply when you combine both. You can freeze up to 10 rows and up to 5 columns, and both must start from the top and left edges. You cannot freeze rows in the middle of a sheet, and you cannot freeze a column in the middle either. If the freeze will not apply, try fewer rows or fewer columns first.
Sorting a wide table works best when the header is frozen first. Learning how to freeze rows in Google Sheets first makes sorting safer. Our guide on how to sort data in Google Sheets shows how to sort a whole table without scrambling its rows. A frozen header keeps the labels visible while the sorted rows move, so you can check the result at a glance.
Freeze Rows vs Hide Rows: Which One Wins?
Freezing and hiding look similar, but they solve different problems. Knowing how to freeze rows in Google Sheets helps you choose freezing when a row must stay visible. Freezing pins a row to the top of the screen, so it stays visible while you scroll. Hiding removes a row from view entirely, so it takes up no space on screen. A frozen header helps you read the sheet, while a hidden row helps you clean up the view. Neither one deletes data, and both can be undone in seconds.
Choose freezing when the row holds labels you need to see all the time. That choice is the heart of learning how to freeze rows in Google Sheets. A header row, a totals row at the top, or a title row all belong in the frozen zone. Choose hiding when a row holds data you do not need right now, such as old months in a budget or helper rows for a formula. Hidden rows still exist, and you can unhide them with a click on the small arrows that mark the gap.
| Feature | Freeze rows | Hide rows |
|---|---|---|
| Row stays visible | Yes, pinned at the top | No, removed from view |
| Scroll behavior | Frozen rows never scroll | Hidden rows take no space |
| Data safety | Data unchanged | Data unchanged |
| Undo path | View, Freeze, No rows | Click the arrows to unhide |
| Best use | Header and label rows | Old or helper rows |
5 Mistakes That Make You Lose Your Headers
These five mistakes cause most freezing problems, and each one is easy to avoid once you know it. Most of them come from rushing the first step of how to freeze rows in Google Sheets, so slow down there. Read the list before your next long sheet, and your headers will stay where they belong.
- Freezing rows in the middle of the sheet. Sheets only freezes from row 1 down, so a freeze that starts at row 5 is impossible. If you need a middle row visible, move the labels to the top rows first, then freeze them.
- Freezing too many rows on a phone. The mobile app only freezes the first row, and a tall frozen zone eats the small screen. Keep it to one row on mobile, and set a taller freeze on a computer instead.
- Freezing without edit access. A view-only file blocks the freeze menu, and the option simply does not appear. Ask the owner for edit access, or make your own copy of the sheet before you freeze.
- Hiding the header instead of freezing it. A hidden header vanishes from view, which looks like the data is gone. Unhide the row first, then freeze it with View, then Freeze, then 1 row.
- Forgetting the freeze is saved in the file. A freeze you set stays set for everyone who opens the sheet, so a teammate may see frozen rows you forgot about. If the sheet looks odd to someone else, check the freeze and clear it with No rows.
How to Freeze Rows in Google Sheets FAQ
How do I freeze the top row in Google Sheets?
Click View in the menu bar, then point to Freeze, then choose 1 row. A thick gray line appears under row 1, and that row stays on screen while you scroll down. The same menu lets you pick 2 rows or Up to current row for a taller header.
How do I freeze more than one row in Google Sheets?
Click a cell in the last row you want to keep, then click View, then Freeze, then Up to row with that row number. Sheets freezes every row from the top down to the one you picked.
Can I freeze rows in the middle of a sheet?
No, Google Sheets only freezes rows from the top down, starting at row 1. You cannot freeze row 5 on its own while rows 1 to 4 scroll.
How do I freeze rows in the Google Sheets app?
On Android, touch and hold the row number and tap Freeze in the menu. On iPhone and iPad, tap the row number, tap the right arrow in the menu, then tap Freeze. The app only freezes the first row or the first column, so set a taller freeze on a computer.
How many rows can I freeze in Google Sheets?
On desktop, you can freeze up to 10 rows and up to 5 columns at the same time. The mobile app only freezes the first row or the first column.
How do I freeze rows and columns at the same time?
Click View, then Freeze, and choose the number of rows first, such as 1 row. Open the same menu again and choose the number of columns, such as 1 column. Both edges stay pinned while you scroll, and each one shows its own gray divider line.
Why is the Freeze option greyed out?
The most common cause is view-only access, because freezing counts as an edit to the file. Ask the owner for edit access, or make a copy of the sheet that you own.
Does freezing rows work when I print?
Yes, but freezing alone does not repeat the header on every printed page. Open the print settings and turn on Repeat frozen rows, which puts the frozen header at the top of each printed page.
Can I freeze rows with a keyboard shortcut?
No, Google Sheets has no dedicated keyboard shortcut for freezing rows. You can open the View menu with Alt and V in Chrome on Windows, or Ctrl, Option, and V on a Mac, then use the arrow keys to reach Freeze.
Will other people see my frozen rows?
Yes, the freeze is saved in the file, so everyone who opens the sheet sees the same frozen rows. Tell your team before you change a shared freeze.
What is the difference between freezing and hiding a row?
Freezing pins a row to the top of the screen so it stays visible while you scroll. Hiding removes a row from view entirely, so it takes up no space on screen.
How do I unfreeze rows in Google Sheets?
Click View, then Freeze, then No rows to unfreeze all frozen rows. If columns are frozen too, repeat the steps with No columns. On mobile, tap the frozen row number and tap Unfreeze. Our full guide is at how to unfreeze rows in Google Sheets.
Final Word
Freezing rows is a small habit with a big payoff, and once you know how to freeze rows in Google Sheets, you will use it in almost every sheet you open, because it keeps your headers in view on every long sheet. The View menu does the job in three clicks, the drag handle does it in one motion, and the mobile app does it with a tap on the row number. Pick one way, use it on every sheet with a header, and you will never type a price into the wrong column again.
If your frozen table needs a visual next, read our guide on how to create a chart in Google Sheets. It shows how to pick the right chart type and customize it, so the data you just organized turns into a chart your team can read at a glance.
Read more about Google Sheets on Wikipedia: https://en.wikipedia.org/wiki/Google_Sheets
