Freezing Rows, Columns, and multiple combinations - Everything you need to know!

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
=XLOOKUP Basics - • EXCEL - XLOOKUP... For...
=IF(Contains) - • Excel If formula - If ...
=(Get First Word) - • Get first word or get ...
=(Get Last Word) - • Get last word in Excel...
=(add months) - • Add Months & Years in ...
=(count if) - • Countif formula in Exc...
=(rank unique) - • Rank Formula in Excel ...
=Multiple If Statements - • Excel IF function Mult...
=Sumif and Sumifs - • Learn the Sumifs & Sum...
=Countif and Countifs - • Countif formula in Exc...
PIVOT TABLE TUTORIALS
=PIVOT TABLE - The Very Basics - • Introduction to PIVOT ...
=PIVOT TABLE - Format Dates - • Group & Ungroup date f...
=PIVOT TABLE - Calculated Fields - • Excel Pivot Table Grow...
=PIVOT TABLE - show fields with no data - • Show all fields in Piv...
=PIVOT TABLE - replace blank cells - www.youtube.com/watch?v=sColD...

[@MK-tj2xu]

OMG straigt to the point. Thank you!!!

[@iitomo0807]

As always your explanation is clear. Thanks!

[@peterklemenc3094]

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

[@datauntelligence]

Great. I use this feature all the time. I'm happy this helped.

[@NorthFloridaLiving]

Good explanation, just what I was looking for.

[@datauntelligence]

Thanks for leaving a comment. I try to make my videos short and to the point, so I'm happy it gave you what you need.

[@claudianajera3500]

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

[@datauntelligence]

Hi there. Great to see the video was able to help.

[@lifelineg4279]

Works. Fast and easy to understand. Wonderful job.

[@datauntelligence]

Thanks for the comment. I always try and make my videos quick and simple to understand.

[@AllYourBaseAreBelongToU5]

This was perfect! Just what I needed!

[@datauntelligence]

Great to hear.

[@DaimeanN]

Just what I was looking for. Thanks!

[@datauntelligence]

Glad you found it. Thanks for the comment

[@annad.-j.1849]

Thanks, great short format as well!🎉😊

[@datauntelligence]

Thanks. I'm happy that it was useful for you.

[@terryw5656]

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

[@datauntelligence]

Great to hear that you got what you needed.
Excellent. Thanks, and welcome to the channel.

[@kristakelley5481]

Many thanks! This was so helpful!

[@datauntelligence]

Great. I love when my videos help.

[@countduckula9977]

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

[@datauntelligence]

Glad it was easy to understand. Thanks for the comment.

[@mom2peaches]

Success! Thank you!

[@datauntelligence]

Yes!! Good to hear!

[@mylibrary43]

Really helpful. Thanks a lot.

[@datauntelligence]

No worries... thanks for the comment

[@illusionno6619]

Thanks, explained very well.

[@datauntelligence]

Thanks for the comment. I try and make my videos clear and quick to view

[@virat82]

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

[@datauntelligence]

Yeah, it's hard sometimes to find exactly what you are looking for

[@intellichem]

soooo easy! thank you!

[@datauntelligence]

Hey, nice. Thanks for the message

[@lameckmanishimwe3037]

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

[@datauntelligence]

You're very welcome!

[@Jamie-559]

Excellent thanks 🙏

[@datauntelligence]

No problem. Thanks for the feedback

[@tatymaira]

reaallly clear and easy thanks

[@datauntelligence]

Nice. Thanks for the message

[@jose15091509]

Thank you very much 👍

[@datauntelligence]

You are very welcome. Thanks for the comment

[@luluaroaro]

Thanks you . very clear

[@datauntelligence]

Great. Happy to assist.

[@mooresey1980]

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

[@datauntelligence]

Yeah, I understand. Happy you now know how to do it. :)

[@Aritul]

Thank you!

[@datauntelligence]

Nice, thanks for the comment.

[@moisesbengochea6236]

gracias amigo, fue de mucha ayuda

[@datauntelligence]

ningún problema. gracias por el comentario

[@moustaphaheiba3301]

Thank you

[@datauntelligence]

No worries. Thanks for writing a comment!

[@ADJJ]

Thanks!!

[@datauntelligence]

No worries, glad it helped

[@aashleeselvan3852]

thank you

[@datauntelligence]

Hi there, thanks for the comment

[@hmingthanarivung6765]

Thanks man

[@datauntelligence]

No worries Mate, thanks for the comment

[@Ezinma88]

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

[@datauntelligence]

Yep. Been there before. Thanks for watching

[@blackswan5251]

Thank u

[@datauntelligence]

No worries, thanks for the comment

[@kailapiazza]

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

[@datauntelligence]

Happy you got it to work. Thanks for watching

[@alanavonemmenis703]

I struggled so much.... thank you.

[@datauntelligence]

Cool. Glad it was helpful for you

[@dawncoffinberry1469]

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?

[@datauntelligence]

Hi, thanks for watching. If your headers are in row 1 and your first column is column A, then select cell B2, go to the ribbon and click 'freeze panes'. Hopefully that helps, otherwise select the appropriate intersecting cell for your file.

[@user-dj8gh9vs6q]

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

[@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.

[@van281189]

🙏🏼👍🏼✌🏼

[@datauntelligence]

Ha, nice. Thank you

[@tomatojuices5340]

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

[@nitishamishra5461]

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

[@lasbaraprehs5818]

Your video Qality also forze.

[@tompots2]

doesn't work for me