HOW TO FREEZE MULTIPLE ROWS AND COLUMNS (EASY 2-STEP METHOD)

Use freeze panes to lock the top rows (or columns) of the Excel sheet to make them visible when scrolling. Learn how in 4 minutes.

🕒 TIMESTAMPS
0:00 Freeze rows and columns in Excel
0:22 Step 1: Select what rows you want to freeze
0:57 Step 2: Click to actually freeze the rows
1:21 How to freeze the top 1 row - quickly
1:35 Freeze multiple columns
2:07 How to freeze rows AND columns at the same time

👍 LIKE AND SUBSCRIBE
If you found this video helpful, hit 'Like' and 'Subscribe' to never miss our latest tutorials. Got a question or feedback? Write a comment!

🎁FREE COURSES

🏆PAID COURSES

🧑‍💻HIRE ME AND MY TEAM

[vasilistrg]

Wish more users were like you. No bs video. You helped me in 78 seconds to understand how to do what was needed. Thank you! Just subscribed!

[cfldriven]

Thank you for making this quick and clear.

[ayusumardi]

You are the best! You gave exactly the info I need. Thank you, guru!

[shafiqulhaque]

Thanks for showing easy short cut methods for simultaneously freeze both row and column. was searching for it.

[leondradimery]

Thank you so much for making this short, helpful video!

[IAmMrAcid]

Straight to the point. You save my life. Thanks

[charleseatley]

Nice lecture. please continue with these short, to the point, lessons

[FoxyladyVideo]

Short, easy and to the point. Thank you very much!

[charlesracette]

The solution was simpler than what I try to do to freeze both rows and columns at the same time.
Thank you for this video.

[wroi_theboy]

Straight to the point and very helpful and precise! Thanks! :)

[chrismaddox]

Watched 4 videos. Only yours explained how to do multiple rows and columns. I get it. Thanks so much! Excellent video!

[Rūdolfs-im]

Thank you, actually explained properly how to do the custom choice of rows/columns, unlike most other, including MS themselves XDDDD

[Mansuri]

Perfect, this is what i was looking for. Already knew about freezing colum and raw but not together, thanks.

[mohamedsadiqrajani]

Great... no waffling... straight to point 👉

[ghostyghost]

This was a miracle video for my online Excel class. Thanks a bunch!

[cherryescalada]

Thank you for this comprehensive tutorial. Now I understand how it works!

[tasakb]

Thanks so much for contributing to knowledge. It was helpful to me.

[dayupatmara]

Just subscribed, you saved my life! thank you!

[naomiwhite]

Thank you!! Been trying to figure this out for months

[hassanradalla]

Thank you very much for the useful and concise information