How to freeze a column in Google Sheets
Click View → Freeze and choose 1 column or 2 columns, or freeze up to the selected column. You can also drag the vertical freeze handle to the right of column A. Frozen columns stay visible while you scroll sideways through wide sheets.
Steps
-
1
Select the column that should stay visible (optional).
-
2
Open View → Freeze.
-
3
Pick 1 column, 2 columns, or Up to column …
-
4
Drag the freeze bar beside the column letters for a custom freeze.
Related tutorials
These videos might help you go deeper on this topic.
Create an Internal Google Sheets Add-on
How To Add Columns in Google Sheets
Related blog posts
Written guides that go deeper on this question.
4 Ways to Resize Columns, Change the Column Width in a Google Sheet
Adjusting column width is crucial for enhancing the readability and functionality of spreadsheets. Properly sized columns ensure that all data is visible without unnecessary scrolling or cutting off information, which can lead to errors or misinterpretations.
Read post →10 Simple Ways to Make Your Spreadsheets Better
Here's a few things you can do very simply and in no time at all, to make your spreadsheets better. Make better spreadsheets for you to spend time in. And better for other people who have to use your spreadsheets.
Read post →5 More Fixes For Your Spreadsheets
Hi, Andrew Kamphey here with Better Sheets, dedicated to helping you improve your Google Sheets every single day. Last time, I shared five ways to fix your sheets. So now, I've got five more tips to make your sheets even better. Let's dive right in! Change the Background Color Let's start by talking about color. While changing the font color is important, altering the background color can make a significant difference too, just follow these steps: 1. Select the entire background. 2. Hit...
Read post →Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
No exact channel match cached for “How to freeze a column in Google Sheets” yet. Search Better Sheets on YouTube.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Related questions
How to freeze row and column in Google Sheets
Click View → Freeze and choose 1 column or 2 columns, or freeze up to the selected column. You can also drag the vertical freeze handle to the right of column A. Frozen columns stay visible while you scroll sideways through wide sheets.
Get the answer →How to freeze column in Google Sheets
Click View → Freeze and choose 1 column or 2 columns, or freeze up to the selected column. You can also drag the vertical freeze handle to the right of column A. Frozen columns stay visible while you scroll sideways through wide sheets.
Get the answer →How to freeze column in google sheet
Click View → Freeze and choose 1 column or 2 columns, or freeze up to the selected column. You can also drag the vertical freeze handle to the right of column A. Frozen columns stay visible while you scroll sideways through wide sheets.
Get the answer →How to freeze column Google Sheets
Click View → Freeze and choose 1 column or 2 columns, or freeze up to the selected column. You can also drag the vertical freeze handle to the right of column A. Frozen columns stay visible while you scroll sideways through wide sheets.
Get the answer →How to freeze columns in Google Sheets
Click View → Freeze and choose 1 column or 2 columns, or freeze up to the selected column. You can also drag the vertical freeze handle to the right of column A. Frozen columns stay visible while you scroll sideways through wide sheets.
Get the answer →How to use linest in Google Sheets
For use linest in Google Sheets, start from the cell or range you care about, then use the menu that matches the job (Format, Data, Insert, or View). Prefer a small test range before changing a whole tab. Search the menus for “use linest” if you are unsure which command applies. Linked glossary terms and formula pages below go deeper when this is function-related.
Get the answer →Need more than a quick answer?
Membership unlocks 636+ tutorials, unlimited generators, and every template.