Тёмный

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

Data Untelligence
Подписаться 6 тыс.
Просмотров 86 тыс.
50% 1

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

 

4 окт 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 74   
@peterklemenc3094
@peterklemenc3094 5 месяцев назад
I have been looking everywhere for a simple tutorial on this. And you explained it it 3 mins. Fantastic job.
@datauntelligence
@datauntelligence 5 месяцев назад
Great. I use this feature all the time. I'm happy this helped.
@MK-tj2xu
@MK-tj2xu 4 месяца назад
OMG straigt to the point. Thank you!!!
@countduckula9977
@countduckula9977 2 года назад
All the ways you can freeze panes; each explained very well.
@datauntelligence
@datauntelligence 2 года назад
Glad it was easy to understand. Thanks for the comment.
@lifelineg4279
@lifelineg4279 2 года назад
Works. Fast and easy to understand. Wonderful job.
@datauntelligence
@datauntelligence 2 года назад
Thanks for the comment. I always try and make my videos quick and simple to understand.
@iitomo0807
@iitomo0807 Год назад
As always your explanation is clear. Thanks!
@virat82
@virat82 10 месяцев назад
this was just what I wanted...very few people understood this requirement..thanks
@datauntelligence
@datauntelligence 10 месяцев назад
Yeah, it's hard sometimes to find exactly what you are looking for
@claudianajera3500
@claudianajera3500 Год назад
Just what I needed: quick clear instructions. Many thanks. Regards from Mexico.
@datauntelligence
@datauntelligence Год назад
Hi there. Great to see the video was able to help.
@NorthFloridaLiving
@NorthFloridaLiving 4 месяца назад
Good explanation, just what I was looking for.
@datauntelligence
@datauntelligence 4 месяца назад
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.
@mooresey1980
@mooresey1980 Год назад
Thank you. I couldn't figure out how to freeze just the top two rows 👍
@datauntelligence
@datauntelligence Год назад
Yeah, I understand. Happy you now know how to do it. :)
@kailapiazza
@kailapiazza 5 месяцев назад
Flipping a,asking I kept trying to highlight the spreadsheet but this was so simple thank you
@datauntelligence
@datauntelligence 5 месяцев назад
Happy you got it to work. Thanks for watching
@annad.-j.1849
@annad.-j.1849 Год назад
Thanks, great short format as well!🎉😊
@datauntelligence
@datauntelligence Год назад
Thanks. I'm happy that it was useful for you.
@lameckmanishimwe3037
@lameckmanishimwe3037 Год назад
I really Thank you for this amazing skills we got in few minutes.
@datauntelligence
@datauntelligence Год назад
You're very welcome!
@DaimeanN
@DaimeanN Год назад
Just what I was looking for. Thanks!
@datauntelligence
@datauntelligence Год назад
Glad you found it. Thanks for the comment
@Ezinma88
@Ezinma88 Год назад
You little beauty. I'd been trying and failing for a while before accepting defeat and opening RU-vid.
@datauntelligence
@datauntelligence Год назад
Yep. Been there before. Thanks for watching
@kristakelley5481
@kristakelley5481 Год назад
Many thanks! This was so helpful!
@datauntelligence
@datauntelligence Год назад
Great. I love when my videos help.
@terryw5656
@terryw5656 6 месяцев назад
Thanks so much! Exactly what I needed. I subscribed as well.
@datauntelligence
@datauntelligence 6 месяцев назад
Great to hear that you got what you needed. Excellent. Thanks, and welcome to the channel.
@tatymaira
@tatymaira Год назад
reaallly clear and easy thanks
@datauntelligence
@datauntelligence Год назад
Nice. Thanks for the message
@mylibrary43
@mylibrary43 Год назад
Really helpful. Thanks a lot.
@datauntelligence
@datauntelligence Год назад
No worries... thanks for the comment
@illusionno6619
@illusionno6619 2 года назад
Thanks, explained very well.
@datauntelligence
@datauntelligence 2 года назад
Thanks for the comment. I try and make my videos clear and quick to view
@dawncoffinberry1469
@dawncoffinberry1469 8 месяцев назад
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
@datauntelligence 8 месяцев назад
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.
@intellichem
@intellichem Год назад
soooo easy! thank you!
@datauntelligence
@datauntelligence Год назад
Hey, nice. Thanks for the message
@jose15091509
@jose15091509 Год назад
Thank you very much 👍
@datauntelligence
@datauntelligence Год назад
You are very welcome. Thanks for the comment
@AllYourBaseAreBelongToU5
@AllYourBaseAreBelongToU5 Год назад
This was perfect! Just what I needed!
@datauntelligence
@datauntelligence Год назад
Great to hear.
@alanavonemmenis703
@alanavonemmenis703 Год назад
I struggled so much.... thank you.
@datauntelligence
@datauntelligence Год назад
Cool. Glad it was helpful for you
@mom2peaches
@mom2peaches 8 месяцев назад
Success! Thank you!
@datauntelligence
@datauntelligence 8 месяцев назад
Yes!! Good to hear!
@moustaphaheiba3301
@moustaphaheiba3301 8 месяцев назад
Thank you
@datauntelligence
@datauntelligence 8 месяцев назад
No worries. Thanks for writing a comment!
@luluaroaro
@luluaroaro 2 года назад
Thanks you . very clear
@datauntelligence
@datauntelligence 2 года назад
Great. Happy to assist.
@Jamie-559
@Jamie-559 2 года назад
Excellent thanks 🙏
@datauntelligence
@datauntelligence 2 года назад
No problem. Thanks for the feedback
@moisesbengochea6236
@moisesbengochea6236 8 месяцев назад
gracias amigo, fue de mucha ayuda
@datauntelligence
@datauntelligence 8 месяцев назад
ningún problema. gracias por el comentario
@Aritul
@Aritul Год назад
Thank you!
@datauntelligence
@datauntelligence Год назад
Nice, thanks for the comment.
@TonyBranken
@TonyBranken 6 месяцев назад
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.
@hmingthanarivung6765
@hmingthanarivung6765 Год назад
Thanks man
@datauntelligence
@datauntelligence Год назад
No worries Mate, thanks for the comment
@ArenMAeCandia
@ArenMAeCandia 8 месяцев назад
nice explanation but i waht to know how to freez a middle column , :)
@blackswan5251
@blackswan5251 Год назад
Thank u
@datauntelligence
@datauntelligence Год назад
No worries, thanks for the comment
@ADJJ
@ADJJ 2 года назад
Thanks!!
@datauntelligence
@datauntelligence 2 года назад
No worries, glad it helped
@nitishamishra5461
@nitishamishra5461 9 месяцев назад
Now in 2023 Freeze option is showing under Window tab in Google sheet... Hope it helps
@lasbaraprehs5818
@lasbaraprehs5818 7 месяцев назад
Your video Qality also forze.
@tomatojuices5340
@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
@van281189
@van281189 Год назад
🙏🏼👍🏼✌🏼
@datauntelligence
@datauntelligence Год назад
Ha, nice. Thank you
@tompots2
@tompots2 Год назад
doesn't work for me
@aashleeselvan3852
@aashleeselvan3852 10 месяцев назад
thank you
@datauntelligence
@datauntelligence 10 месяцев назад
Hi there, thanks for the comment
Далее
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
这位大哥以后恐怕都不敢再插队了吧…
00:16
Highlight Active Row & Column in Excel (7 Levels)
22:56
6 COOLEST  Excel formulas in 2024
7:57
Просмотров 7 тыс.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Tips - Don't Use Formulas! Use Ctrl + E Instead
2:53
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
2-Way Xlookup with multiple criteria in EXCEL
4:46
Просмотров 4,4 тыс.