How to Freeze Columns in Google Sheets

Learn how to freeze columns in Google Sheets to keep important data visible while scrolling. This quick tutorial covers multiple methods to achieve this functionality.

So you're trying to freeze columns. The issue is, if we scroll over to the right, the first column is totally unseen. Maybe there's different names here, and you want to see all the people's different names, statuses, whatever you have in the first column, you want to see that all the time. One way to freeze columns is go right next to the A column over on the left side, scroll for a little bit, and the cursor turns into a hand. Click and drag that over to, between the A and the B column, and now we have a frozen column here. There is one other way to do this, go up to View, Freeze , and select one column. The interesting thing about this is that we can click and drag this as many columns as we want, We can also go up to View, Freeze , and notice that it says Hacks You Might Not Know 10 Simple Ways to Make Your Spreadsheets Better How to UnFreeze Columns in Google Sheets

No Columns, One Column, or Two Columns. But, if we go over to the F column and our cursor is selecting the F column, let's look at View again and see Freeze . Up to F column. So now we can go any column we want. However, if you do go past the view area like this, it'll say the current window is too small and you'll need to adjust your, either your browser window or you need to adjust where your frozen rows are. You can just zoom out a little bit. If you want to stay zoomed in, just go up to view, freeze , and maybe only Freeze one column. There you go. That's how to freeze columns in Google Sheets . If you're trying to get more out of your Google Sheets than you ever have before, consider subscribing here on YouTube to BetterSheets. I guarantee it'll help you do Google Sheets better. How To Add Columns in Google Sheets 4 Ways to Resize Columns, Change the Column Width in a Google Sheet How to UnFreeze Columns in Google Sheets