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

Подписаться 6 тыс.

Просмотров 83 тыс.

50% 1

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.co...

Опубликовано:

11 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 74

@peterklemenc3094 4 месяца назад

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

@datauntelligence 4 месяца назад

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

@countduckula9977 2 года назад

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

@datauntelligence 2 года назад

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

@lifelineg4279 2 года назад

Works. Fast and easy to understand. Wonderful job.

@datauntelligence 2 года назад

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

@iitomo0807 Год назад

As always your explanation is clear. Thanks!

@MK-tj2xu 3 месяца назад

OMG straigt to the point. Thank you!!!

@NorthFloridaLiving 3 месяца назад

Good explanation, just what I was looking for.

@datauntelligence 3 месяца назад

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.

@virat82 9 месяцев назад

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

@datauntelligence 9 месяцев назад

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

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

@kristakelley5481 Год назад

Many thanks! This was so helpful!

@datauntelligence Год назад

Great. I love when my videos help.

@terryw5656 6 месяцев назад

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

@datauntelligence 6 месяцев назад

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

@lameckmanishimwe3037 Год назад

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

@datauntelligence Год назад

You're very welcome!

@mylibrary43 Год назад

Really helpful. Thanks a lot.

@datauntelligence Год назад

No worries... thanks for the comment

@tatymaira Год назад

reaallly clear and easy thanks

@datauntelligence Год назад

Nice. Thanks for the message

@AllYourBaseAreBelongToU5 Год назад

This was perfect! Just what I needed!

@datauntelligence Год назад

Great to hear.

@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. :)

@intellichem Год назад

soooo easy! thank you!

@datauntelligence Год назад

Hey, nice. Thanks for the message

@moustaphaheiba3301 7 месяцев назад

Thank you

@datauntelligence 7 месяцев назад

No worries. Thanks for writing a comment!

@mom2peaches 7 месяцев назад

Success! Thank you!

@datauntelligence 7 месяцев назад

Yes!! Good to hear!

@illusionno6619 2 года назад

Thanks, explained very well.

@datauntelligence 2 года назад

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

@Ezinma88 Год назад

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

@datauntelligence Год назад

Yep. Been there before. Thanks for watching

@jose15091509 Год назад

Thank you very much 👍

@datauntelligence Год назад

You are very welcome. Thanks for the comment

@Aritul Год назад

Thank you!

@datauntelligence Год назад

Nice, thanks for the comment.

@Jamie-559 2 года назад

Excellent thanks 🙏

@datauntelligence Год назад

No problem. Thanks for the feedback

@kailapiazza 5 месяцев назад

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

@datauntelligence 5 месяцев назад

Happy you got it to work. Thanks for watching

@moisesbengochea6236 7 месяцев назад

gracias amigo, fue de mucha ayuda

@datauntelligence 7 месяцев назад

ningún problema. gracias por el comentario

@luluaroaro 2 года назад

Thanks you . very clear

@datauntelligence 2 года назад

Great. Happy to assist.

@blackswan5251 Год назад

Thank u

@datauntelligence Год назад

No worries, thanks for the comment

@ADJJ 2 года назад

Thanks!!

@datauntelligence 2 года назад

No worries, glad it helped

@hmingthanarivung6765 Год назад

Thanks man

@datauntelligence Год назад

No worries Mate, thanks for the comment

@alanavonemmenis703 Год назад

I struggled so much.... thank you.

@datauntelligence Год назад

Cool. Glad it was helpful for you

@dawncoffinberry1469 7 месяцев назад

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 7 месяцев назад

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.

@TonyBranken 5 месяцев назад

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 7 месяцев назад

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

@nitishamishra5461 9 месяцев назад

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

@lasbaraprehs5818 6 месяцев назад

Your video Qality also forze.

@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