Google Sheets: Freeze
Have you ever wanted to lock those pesky rows of headers or columns so that when you scroll the titles are still there? In Google Sheets, this is done easily.
You can either got to View > Freeze and select your preferred depth of freeze. Or you can do my favourite approach, click and drag that thick line just above and to the left of cell A1 and drag it to your preferred location.
Easy as that.
Check out the video tutorial below for more tricks on using Freeze in Google Sheets. It will cover:
- What Freeze does in a Google Sheets spreadsheet.
- How to freeze single or multiple columns and rows by using the menu bar.
- How to freeze using right-click on columns and cells.
- Some common issues you may face with freeze.
I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*
*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.