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.
Want a fast track to boost your Spreadsheet efficiency? Grab one of these handy Google Sheets Shortcuts mousepads that I created from my store.