Google Sheets: Adjusting the Freeze Bars

Google Sheets: Adjusting the Freeze Bars

When using a Google Spreadsheet you will likely want to freeze the first row and maybe the first few columns. What this does for you is allows you to see the header row as you scroll down through the spreadsheet. If you are looking at student data it is likely you would want to freeze the students name so that when you scroll to the right in the spreadsheet you are able to clearly connect the data to the students name.

By default the first row is frozen in the spreadsheet of a Google Form.

Upper Left

Look in the upper left hand corner of the spreadsheet. The square to the left of the column indicators and above the row indicators. I incorrectly refer to this as the “awesome box.” If you click on it, you select all of the cells in the sheet.
freeze bars

On the edge of the “awesome box” are hatched lines. These are the freeze bars.

Grabby Hand

Hover your mouse over the edge of the “awesome box.” The cursor should change into a “grabby hand.”
grabby hand  grabby hand 2

Hold down your mouse and drag the freeze bar down. You can freeze multiple rows. You can also use the “grabby hand” to drag the vertical freeze bar to the right.

Once the freeze bars have been moved, you can use the “grabby hand” to move the freeze bars back if you need to. Note that sometimes in order to delete rows or columns or do other functions you need to return the freeze bars to their “resting” position back at the “awesome box”

 

Leave a Comment

© 2026 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday April 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for teaching with AI

Imagine having a team of teaching assistants who already know your syllabus and exactly how you like to give feedback. Join Google Certified Innovator Alice Keeler to learn how to use Google Gems to build a powerful collection of custom AI tools. We will explore how to engineer specific instructions so you can create a Grading Assistant or a Classroom Policy Manager that works for you. You will also learn how to leverage Gems shared by other educators to instantly expand your toolkit. This session is about super-powering your teaching by automating the routine tasks so you can focus on the students.

Exit this pop up by pressing escape or clicking anywhere off the pop up.