Everything you need to know about FREEZING rows, columns, and multiple combinations

Learn how to Freeze multiple rows and multiple columns in excel.
In this Video:
- Freeze the Top Row
- Freeze the Top 4 rows
- Freeze the first column
- Freeze multiple columns
- Freeze a combination of rows and columns

Other Excel Video Tutorials :

2 MINUTE EXCEL FORMULA TUTORIALS

PIVOT TABLE TUTORIALS

[MK-tjxu]

OMG straigt to the point. Thank you!!!

[peterklemenc]

I have been looking everywhere for a simple tutorial on this. And you explained it it 3 mins. Fantastic job.

[lifelineg]

Works. Fast and easy to understand. Wonderful job.

[countduckula]

All the ways you can freeze panes; each explained very well.

[iitomo]

As always your explanation is clear. Thanks!

[virat]

this was just what I wanted...very few people understood this requirement..thanks

[claudianajera]

Just what I needed: quick clear instructions. Many thanks. Regards from Mexico.

[NorthFloridaLiving]

Good explanation, just what I was looking for.

[annad.-j.]

Thanks, great short format as well!🎉😊

[mooresey]

Thank you. I couldn't figure out how to freeze just the top two rows 👍

[terryw]

Thanks so much! Exactly what I needed. I subscribed as well.

[lameckmanishimwe]

I really Thank you for this amazing skills we got in few minutes.

[kailapiazza]

Flipping a, asking I kept trying to highlight the spreadsheet but this was so simple thank you

[dawncoffinberry]

First thank you for sharing . You did an excellent job of explaining how to do it. When I try to freeze the first column and the heading, I selected the column and row to freeze the heading and first column but it doesn't freeze the column, only the heading. What is my problem? why isn't it working?

[Ezinma]

You little beauty. I'd been trying and failing for a while before accepting defeat and opening YouTube.

[TonyBranken]

That's great. However, I would like to know how to do this in Page layout view. If I select Page layout after I have frozen my cells, it gives me a message that it will disable freeze panes. This is not good from Microsoft. Is there a way around this please? A challenge for you.

[ArenMAeCandia]

nice explanation but i waht to know how to freez a middle column, :)

[nitishamishra]

Now in 2023 Freeze option is showing under Window tab in Google sheet... Hope it helps

[tomatojuices]

How do i freeze different row... Let's say row 5 and 17..if i scroll past row 5 it will froze the row 5 until i scroll past row 17, then row 17 will froze if i keep scrolling down