top of page

Freeze It!

Imagine you have been presented with a ton of data which extends beyond our vision and there's no one around to make sense of it and you just Freeze!

There's always a way to make data more presentable even if its for yourself. One way would be to freeze or lock the rows and columns which contains the details you want to view while you scroll through in any direction.


What is a row and what is a column?

Rows are the horizontal lines identified with the help of numbers such 1,2,3,4 and so on.

Columns are the vertical lines identified with the help of alphabets such A,B,C,D and so on.

Row 1 and Column A

Column B

Column C

Column D

Row 2

Row 3

Row 4

How To Freeze:


1. Go to View at the top of your Google sheets:

How To Freeze - Select the View Option
How To Freeze - Select the View Option

2. Hover over Freeze which is inside the view menu:



How To Freeze - Hover over Freeze option
How To Freeze - Hover over Freeze option

3. You can now review the options available to freeze the rows and columns:

How To Freeze - Inside the Freeze option
How To Freeze - Inside the Freeze option

In order to Practice freezing, you can use this practice sheet HERE and go to Practice.


Level 1 Freeze (Freeze Rows):


1. Select Row 1 by clicking on the number 1:

Level 1 Freeze- Select Row 1
Level 1 Freeze- Select Row 1

2. Go to View and then hover over Freeze and you should see something like the image below:


Level 1 Freeze- Hover over Freeze Option
Level 1 Freeze- Hover over Freeze Option

3. Click on Up to Row 1


Level 1 Freeze- Select Up to row 1
Level 1 Freeze- Select Up to row 1

You should see a grey border showing up underneath row 1 and now you can scroll down as much as you want but the row 1 will always be on top.



Level 1 Freeze - Grey Border under row 1 after it was frozen
Level 1 Freeze - Grey Border under row 1 after it was frozen

You can watch this video to understand the different steps:





Level 2 Freeze (Freeze Columns):

1. Select Column A by clicking on the alphabet A :


Level 2 Freeze - Select Column A
Level 2 Freeze - Select Column A

2. Go to View and then hover over Freeze and you should see something like the image below:


Level 2 Freeze - Go to View Option
Level 2 Freeze - Go to View Option

3. Click on Up to column A:


Level 2 Freeze - Click on Up to column A
Level 2 Freeze - Click on Up to column A

You should see a grey border showing up beside column A and now you can scroll sideways without worrying that column A is going to scroll away.


Level 2 Freeze - Grey Border beside Column A after it was frozen
Level 2 Freeze - Grey Border beside Column A after it was frozen

You can also watch this video to understand the different steps:




Please consider sharing your thoughts below:


Did you find this article helpful?

  • Yes

  • No

  • Don't know





Recent Posts

See All

Comments


DON'T MISS THE FUN.

Thanks for submitting!

FOLLOW ME ELSEWHERE

  • Facebook
  • Instagram
No tags yet.

POST ARCHIVE

bottom of page