Skip to content
Back to template gallery
Google Sheets
Google Sheets

How to Unfreeze Columns in Google Sheets

In this guide, you will learn how to unfreeze columns in a Google Sheets spreadsheet to improve your data viewing experience. By navigating the menu options in the Dataset document, you will quickly disable column freezing and restore standard scrolling to your sheet.

Accounting & Finance
5 steps 2 min Community template
1

Navigate to your Google Sheet

Navigate to the specific Google Sheets document where you want to unfreeze the columns.

docs.google.com/spreadsheets/d/1BUSfI2-kY68iwwOcDrnrD2mY9tqO72UtAepeJUhs5SM/edit
Navigate to your Google Sheet
2

Click on the column you want to unfreeze

Click on the column you want to unfreeze

docs.google.com/spreadsheets/d/1BUSfI2-kY68iwwOcDrnrD2mY9tqO72UtAepeJUhs5SM/edit
Click on the column you want to unfreeze
3

Click the View menu

Click the View menu in the top toolbar to access the freeze options.

docs.google.com/spreadsheets/d/1BUSfI2-kY68iwwOcDrnrD2mY9tqO72UtAepeJUhs5SM/edit
Click the View menu
4

Select the Freeze option

Click the "Freeze" option in the dropdown menu to reveal the freezing settings.

docs.google.com/spreadsheets/d/1BUSfI2-kY68iwwOcDrnrD2mY9tqO72UtAepeJUhs5SM/edit
Select the Freeze option
5

Select the No columns option

Click "No columns" in the submenu to unfreeze all columns in your spreadsheet.

docs.google.com/spreadsheets/d/1BUSfI2-kY68iwwOcDrnrD2mY9tqO72UtAepeJUhs5SM/edit
Select the No columns option

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.