The thick gray bar in a Google Sheets spreadsheet is a freeze line. It marks rows above it or columns to its left that stay in place while you scroll. To remove it, select View > Freeze > No rows (and No columns if there’s a vertical bar). You can also drag the bar back to the top-left corner.
A thinner gray bar with a + or − button next to the row or column headers is something else: a group. The table below helps you tell them apart.
Quick Answer
Select View > Freeze > No rows and View > Freeze > No columns.
Remove the Freeze Line
- Open the spreadsheet.
- Select View in the menu bar.
- Point to Freeze.
- Choose No rows to remove a horizontal bar, and No columns to remove a vertical bar.
Drag method: Point to the gray bar until the cursor turns into a hand, then drag it up to the top-left corner of the sheet.
Which Gray Bar Is It?
| What you see | What it is | How to remove it |
|---|---|---|
| Thick gray line between rows or columns | Freeze line | View > Freeze > No rows / No columns |
| Gray bar beside row or column headers with + or − | Row or column group | Right-click the group bar > Remove group |
| Gray-filled cells | Fill color or conditional formatting | Fill color > Reset, or Format > Conditional formatting |
| Light gray grid | Gridlines | View > Show > Gridlines |
| Gray area past the last row or column | End of the sheet | Add rows or columns if you need more space |
Freeze Rows or Columns on Purpose
- Click a cell in the last row or column you want to keep visible.
- Select View > Freeze and choose 1 row, 2 rows, or Up to row X (the same options exist for columns).
Freezing the header row keeps labels visible in long lists. For more, see how to lock a column in Google Sheets.
For a cleaner header row, center data in Google Sheets.
Troubleshooting
- “Can’t freeze: merged cells”: Unmerge cells that cross the freeze line, then try again.
- The bar is still there on mobile: In the Sheets app, tap a row number, tap the three dots, and choose Unfreeze.
- A filter’s gray header: Filtered sheets show a green or gray header row. Select Data > Remove filter. See filtering columns in Google Sheets.
Printing? Freeze lines don’t print, but gridlines can; see how to print with gridlines.
Frequently Asked Questions
Does removing the freeze line delete data?
No. It only changes what stays visible while scrolling.
Does everyone see the freeze?
Yes. Frozen rows and columns are saved with the sheet for all collaborators.
Summary
- The thick gray bar is a freeze line.
- Remove it with View > Freeze > No rows or No columns.
- Thin bars with +/− are groups; remove them with Remove group.
Kermit Matthews is a freelance writer based in Philadelphia, Pennsylvania with more than a decade of experience writing technology guides. He has a Bachelor’s and Master’s degree in Computer Science and has spent much of his professional career in IT management.
He specializes in writing content about iPhones, Android devices, Microsoft Office, and many other popular applications and devices.