Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Adjusting the Freeze Bars

Google Sheets: Adjusting the Freeze Bars
YouTube video

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”


© 2024 All Rights Reserved.