How to LOCK Scroll Area in Excel | Limit Scrolling in the Worksheet

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

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

50% 1

In this video, I will show you how to lock the scroll area in a worksheet in Excel so that the user can not select and specific outside of a range.
This can easily be done by changing the properties of the worksheet. Also, since the scroll area property resets when you close and reopen the workbook, I will also show you how to make sure the only a specific area is allowed for the user and rest all are locked.
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week:
ru-vid.com...
#Excel #ExcelTips #ExcelTutorial

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

3 июн 2020

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@DedManWarKing 4 года назад

Thank you Sumit for a great tip and also for the free access to your courses. I am working my way through the VBA one right now. Very easily followed and professionally presented. Thanks again.

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel."Nepalese:Tai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen true.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Gee tao?Ture look lung lung char?True look gar they ho?Dollar bo got lai so may ho.Gee tao?Must dar lee.More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho bar lish hei.Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see dean dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee hoo,Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee.Ah shan hei?Bo ho man gar hei,single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.

@Righteous628 3 года назад

Thank you Sumit for this video, you are THE ONLY person who identified the flaw in the initial scrolling solution (Specifically that when you close the sheet and then reopen the lock restriction disappears) I don't know if the other people who do these videos are too lazy to give a thoroughly informative video, or they just aren't knowledgeable enough) I am glad you are knowledgeable enough and I will be using you exclusively for my excel questions Thanks again.

@trumpexcel 3 года назад

Thank you so much for the kind words. Glad you found the video useful

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then almost 50 years of internal power struggle of civil war and northern troops from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.

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

Thank you! This was super quick and easy. Worked right away!

@xeroxo7210 3 года назад

YOU ARE THE BEST .EVERYTHING YOU TEACH IS SO USEFUL

@su.mu.kh. 3 года назад

Thank you sir, keep making such videos 🙏🏻🙏🏻🙏🏻

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

Very well explained. Loved the learning

@prakashs6569 3 года назад

Thank you for your help ❤️

@shahzadsami5613 3 года назад

Thanks Dear for your kindness

@nadermounir8228 4 года назад

Great video. Thank you very much for also offering the courses :))))

@keithau8159 3 года назад

@Khalnayak_sanju143 4 года назад

Nice information given thanks

@kaesuma 4 года назад

thank you for your lessons. u have showed me many solutions to work around my excel data analysis.

@keithau8159 3 года назад

@suneetjindal7171 Год назад

Thanks for this video, it's useful for me

@parmeshwarcctv 4 года назад

Awesome Tips....! It's lots help me...specially dashboard page, Thanks for Sharing

@keithau8159 3 года назад

@zaq8148 Год назад

Thank you for your video..

@meetkcs 4 года назад

Very Simple & But Most Useful trick. Thumbsup

@keithau8159 3 года назад

@anilthakkar2372 Год назад

very helpful .....thanks

@uzairashraf213 11 месяцев назад

❤Excellent explanation

@shantakumarmath2297 Год назад

Thank you Bro

@wayneedmondson1065 4 года назад

Hi Sumit.. great tutorial. For a quick solution, I hide all the columns to the right and the rows below the range I want to restrict my user from using or seeing. By default then, the area of scrolling is limited to the visible range. I guess the approach depends on the situation and the end user. Thanks for sharing your techniques. Thumbs up!! PS - Thanks for your generosity in sharing all your courses for free.. very much appreciated!!

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel."Nepalese:Tai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen true.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Gee tao?Ture look lung lung char?True look gar they ho?Dollar bo got lai so may ho.Gee tao?Must dar lee.More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho bar lish hei.Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see dean dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee hoo,Kee lee ho?Sai dee all dee hei?but chat hei?Bo ho man gar hei,single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.

@जिंदगी_ए_सफर Год назад

Thanks a lot very useful

@asimali5820 4 года назад

Great Work!

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

@rahulg9245 4 года назад

Excellent Tutorial, short video with bunch of information. Good one bro 👌

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel."Nepalese:Tai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen true.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Gee tao?Ture look lung lung char?True look gar they ho?Dollar bo got lai so may ho.Gee tao?Must dar lee.More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho bar lish hei.Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see dean dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee hoo,Kee lee ho?Sai dee all dee hei?but chat hei?Bo ho man gar hei,single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.

@helenbradshaw6822 4 года назад

many thanks Sumit

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

@sekiondowarema1786 4 года назад

Nakukubali sana Mr Sumit Basal. You help me so much.... God bless u.😍

@keithau8159 3 года назад

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

This worked for me with Ms office 2007

@yurd563 3 года назад

Thank you very much!

@trumpexcel 3 года назад

Thanks for commenting Nadir... Glad you found the video useful!

@randymartin9876 4 года назад

very helpful. thanks.

@keithau8159 3 года назад

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

Thanks for your very generous offer. Is it possible to limit the scroll to two non-contiguous areas in the same sheet?

@user-tl5lw7rc3m 4 года назад

Many thanks Mr. Sumit

@keithau8159 3 года назад

Hello my friend?Ah so mao ah lee kung?Sai bar lai hei?Man sai ha lai hei?Key fun lai hung car?Men ah be hei.Were are/nt.Ma east smoker.So car lung.Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel."Nepalese:Tai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen true.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Gee tao?Ture look lung lung char?True look gar they ho?Dollar bo got lai so may ho.Gee tao?Must dar lee.More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho bar lish hei.Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see dean dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee hoo,Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee.Ah shan hei?Bo ho man gar hei,single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.

@mohamedgenidy1901 3 года назад

thank u very very much .. u solve me a great problem .. thank u again

@stephenmascarenhas1987 3 года назад

Good explanation

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.No wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

@mbayembengue6902 4 года назад

Thanks 🙏🏽

@keithau8159 3 года назад

@shahulhameed-dc2fz 3 года назад

Nice.keep it up.congratulation

@_KING_SHADOW 4 года назад

Thank you.

@keithau8159 3 года назад

@JaspreetSingh-it2ny Год назад

Awesome

@krishnamurthyramanathan1795 4 года назад

Thanks

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.No wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

@kamlabimla 4 года назад

Thanks Sumit

@keithau8159 3 года назад

@manishahanavate2613 4 года назад

Thanks bro for free courses

@keithau8159 3 года назад

@TrueBits 3 года назад

Thank u Somuch for this, :

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel."Nepalese:Tai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.Du lee du lee Nepalese kar ha chen true.Bolly judy ho?Judy we ho car jan lee,kar num bus lai,ah lai got na.More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu:Kee sai ho?Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho bar lish hei.Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing see hung kar.Bar hei bo ho man gar hei,easy kar jar kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see dean dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar lai du ,So lai ha tai alarm kar lai ha tar.Ah cha hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.

@Jerrel.A 4 года назад

Mast! Thx, very useful.

@keithau8159 3 года назад

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

you're the best

@Faazz01 Год назад

Legend ❤

@mustakimgauri509 3 года назад

Thank you dear....

@keithau8159 3 года назад

@GreatGamblingGuru 3 года назад

You're a legend 🔥

@trumpexcel 3 года назад

Thanks for the kind words :

@tariqulislam6291 3 года назад

Nice too

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.No wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

@PaulaWeb3andCrypto 4 года назад

Excellent video Sumit

@trumpexcel 4 года назад

Thanks Paula! Good to see you here :)

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.

@MoppieDun 3 года назад

Sub, thank you for the generosity

@keithau8159 3 года назад

@yeraldo05 3 года назад

Hi TrumpExcel, thank you very much for the information. I have a question, is there a way to make the scroll area dynamic? Let´s said that I only want to have two cells for the user to play around (B2:B3), but if data is added to Row 2 & 3 I want to have the scroll area to be B4:B5.

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

Use named ranges, then reference the named range in your code instead of the cell address; of course this would only work if they add the row between row 2 and 3, and would not work if they add the row between 1 and 2 or 3 and 4. It basically has to be in a sandwich, otherwise it will not be included into the named range.

@karthikrajgopal8627 4 года назад

Nice video..

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.

@justjaionly 4 года назад

Nice one

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

@JamesBond-qg5gx 4 года назад

Thanks, if we wanna lock the whole sheet than what will be the vba

@nadermounir8228 4 года назад

Will certainly buy u a coffee :) my pleasure

@keithau8159 3 года назад

@parveendhawan9040 3 года назад

Supb......... Very nice

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.No wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

@khowajaghulamsakhisediqy1563 4 года назад

Very nice trick, I have a question, I extracts login/logout report of all staff and I need a code or trick to show or filter the first login and last logout record.

@keithau8159 3 года назад

@TBsThaiBoxing 4 года назад

You could just use 'Protect Sheet' option.. make sure the cells you want to be edited are 'Unlocked' via 'Format Cells' and then when you 'Protect the sheet' Untick the top box called "select locked cells" will essentially do the same thing :)

@muhammadzeeshan9089 Год назад

What the hell are you saying, it's not working

@kjj367 Год назад

nah this method for locking formula

@binakumar7273 4 года назад

Thanks Sumit. Do you have any training material on retaining the format of the Pivot table especially after it is refreshed. I have pivot table conditional formattin but when ever new data is added and refreshed, the formtting is lost for new data.

@kaesuma 4 года назад

www.contextures.com/excelpivottableconditionalformat.html i found that to be helpful to retain the cond format in my pivot table

@keithau8159 3 года назад

@charlyRoot 3 года назад

Now I can keep my mom from trashing my shared spreadsheets. This is awesome. No more passwords to edit cells. She doesn’t even know vba exists.

@ivanpap634 4 года назад

Great video! (P.S. the Free Dashboard Course link doesn't works)

@alamgirrubelmusicgallery7135 4 года назад

Hello Sir, You are too good in Excel Teaching but we need excel file what you are taught in every Tutorial. If you provide a link of Excel datasheet that will be helpful for us to learn & revision of your totorials. Hopefully you will do that. Tnx. Alamgir_Dhaka, Bangladesh

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

Dear Sumit can you also explain the command for Google Sheets?

@niravvaniya777 4 года назад

Bro your video are simply amazing. I start watching day by day. I have 1 query. == I try to extract data from nse web site but my data in text format. When I try data import by web link. It's give me so much table in table and I can't found my perticular data. If any solution plz suggest me. Tnx.

@keithau8159 3 года назад

@pritikane4448 3 года назад

Can you post the actual vba code also in the description . It will be helpful to write from there.

@vikaasb2016 4 года назад

Can we do this by working on protect worksheet tab without using VBA?

@keithau8159 3 года назад

@Engineering786 Год назад

Let say in workbook, 100 nos sheets are there, then moving from sheet 1 to Sheet 100 is very difficult. Then is there any provision in excel, to freez Or fix the position of the sheet 1. So that any data of sheet 2 to sheet 100 can be inserted / linked in sheet 1

@sevenhenson3926 3 года назад

What if the user disables the vba? Ie save this file as normal excel. The scroll limit will be lost right?

@SerdarYazicioglu Год назад

thanks for your video I built my spreadsheet in Excel 2013 and it works. It also works in Excel 2016. But in Excel 2019 it doesn't work! The scroll area is simply not adopted in Excel 2019, why? Google can't help me either! Anyone have an answer?

@trumpexcel 4 года назад

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.

@hajajahirhussain6814 4 года назад

Dear Sumit, Your courses are very helpful to me. Thanks to give the courses for free. I have one request please upload videos about VBA class module. Thanks.

@rodneyking2936 4 года назад

Awesome Tips. Can you do few videos on Power Pivot and advanced Pivot concepts ?

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

Is there a way to restrict user on adding a new sheet?

@giveonlyhappiness1628 4 года назад

Sir ,is it possible to do same in Mobile also, as we have already uploaded no. of WPS app in our Mobile??? And I don't have Laptop.

@keithau8159 3 года назад

@reechatimilsina5640 4 года назад

😍😍😍🇳🇵free free

@keithau8159 3 года назад

@manuelz1508 3 года назад

How do I disable AUTOFIT in tables?

@redhaakhund1271 3 года назад

👍👍👍👍👍

@sekhar6106 4 года назад

Sir, If the file containing this macro is shared, then how to restrict that person from editing the VBA.

@keithau8159 3 года назад

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

Dear what if the sheet has a futmula to be main page activated, I did tried to do this way in new private sub but dose not work, please help on this I need to stop scrolling the main page also I need this main page to be opened directly when I open the project Thank you in advance

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

So I am unable to change the sheets by two fingers touch scrolling instead of ctrl+page up and down

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

👍

@pinoyapollo9637 Год назад

It is working i did it but i want my files to have passin it and when i do have a password then the scroll area will be open again, is there any solution to this please thank you

@jello714 3 года назад

Not all heroes wear capes

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.No wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

@tier1athlete829 8 месяцев назад

This doesn't work if a user is using a mouse to scroll in Excel & are able to scroll past the locked area. So how can this be truly locked regardless if the user uses a mouse to scroll within workbook?

@HeyZenMei 8 месяцев назад

I have a Developer tab, but there is no "Properties" option.

@prasanthsambasivan2926 3 года назад

my arrow keys up and down not scrolling instead it just moving sideways

@mohit8460 3 года назад

Hello sir Still I can't lock the scroll area in my excel sheet

@raj8119 3 года назад

Hi Sumit, excellent video! But please help on one issue to fix, I need to put scrolling function and selected worksheet to open in one workbook together which is not happening. please help on same. can i have your number please

@keithau8159 3 года назад

@ThierryRocksTV Год назад

Doesn't work for me. Says "Run-time error 9"

@SanjeevKumar-jn2pt 4 года назад

Our excel warns: macros may contain viruses and disables macros by default and asks to enable macros. My question is: will this method work if I send a file to my client and his macros are diabled.

@trumpexcel 4 года назад

If the macros are disabled, it won't work.

@TBsThaiBoxing 4 года назад

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

@lovelychantigaduu 3 года назад

Run time error 9

@keithau8159 3 года назад

Don/t do that,only a small mistake===Human league===I am only human born to make mistake,excellent song,musics and mixing,really touching down English speaking and listening audience even it is 80's ,the song with proverbs,prophecy and apocalypse as excellent as Overjoy,Hands to heaven@@@@@Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.No wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

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

It blows my mind that Excel can't do this sort of thing natively and without hassle since it's literally the first thing I'd wish to set up when I start a new spreadsheet. Google spreadsheets can do it and Apple Numbers can do it as well. Maybe I'm just OCD or something but the fact that there are hundreds of active cells around my work area (just being there for no reason) annoys the crap out of me.

@harryvala36 3 года назад

Budhhi bahot tez he aapki.......

@keithau8159 3 года назад

Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got na.Bar kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee kee.Au bag dai bar kar kar hei,easy art dee hei.Bo ho men sai ha hei.Bar hei bo ho got me hei ,kam beer jar dar "Ban lee"b lai.Bar hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung kar.Bar hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he hei.Bar mei link it.Mei ban lee.So kar lee ah.Care ah luck ah.Ug lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha hei.Bo ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple.No wonder draw tourists come to Holly Khilasa temple to vist at all@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all.Google ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

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

Bhai एक तो कुछ भी video बना हिन्दी में बोल अमरीकन थोड़ी न हो तुम.. दूसरा scroll मै खाली scroll option नहीं जो एरिया में काम करना है उतना ही दिखे बाकी दिखे ही नहीं वो कैसे करे वो बताओगे तो कुछ मजा आए