Google Sheets Beginners: Freeze Rows and Columns(11)

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:

1. What Freeze does in a Google Sheets spreadsheet.
2. How to freeze single or multiple columns and rows by using the menu bar.
3. How to freeze using right-click on columns and cells.
4. Some common issues you may face with freeze.

Did you enjoy the tutorial? Want to upskill and get a solid step-by-step course to become a pro at Google Sheets? Check out my course, Google Sheets: Learn the Essentials with Three Detailed Projects. Sign up today.

 

Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.