7 Clever Excel Custom Formatting Tricks (Advanced)

Рет қаралды 224,316

3 жыл бұрын

In this video, I cover some amazing Excel Custom Formatting tricks that you can use in your day to day work.
Custom formatting allows you to show the cell content in a specific way, while at the same time, it doesn't change the value in the cell. It only changes the way a value is being displayed in the cell.
** Download file: bit.ly/38RuHC9
-------------------------------------------------------------------------------------------------------------------------------------------------
00:00 Intro
00:12 Excel Custom Formatting Overview
01:06 Hide Cell Values in Excel
03:38 Hide Zeros (or replace 0's with text)
05:50 Conditional Custom Formatting (Show Text Based on Cell Value)
07:55 Showing Dates in different formats (Month name or Day name)
10:53 Show Negative Numbers in Red
13:19 Show numbers in Millions or Billions
15:59 Automatically Add Checkmark or Bullets before Text
-------------------------------------------------------------------------------------------------------------------------------------------------
☕ 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-course
✅ 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: kzfaq.info
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 309

@sansnomnull2799 3 жыл бұрын

Finally someone clearly explained the custom formatting, not just how but also why. Thank you!

@trumpexcel 3 жыл бұрын

Thanks for commenting... 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 @t 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 @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t 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 @t bag dai bar kar kar @t 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 @t 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 @t mei link it.Mei ban @t kar lee @t ah luck @t 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 @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t 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 @t 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 @t ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century@@@@@

@keithau8159 3 жыл бұрын

Hello,my dearest Indian Friend,how are you.Happy new year 2021 to you and to your family."Tai chi?Num ma stair?Kee sai ho?T-Cool.Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek du.Can/t lai lee kai ho can/t lai nei he?Can/t lai nei he,kai ah mei two mei key lai dar hung.Au bag dai bar kar kar hei.Bo ho ma sai he hei.Mei Hindi,Hindo,Nepalese art dee hei.Mei India kam kee hei.Au bag dai bar kar kar hei,easy art dee hei.Bo ho ma sai he hei.Eight lai jar dar kam ho dar hei,kar jar kee,saw jar dar hung bo ho tek kee hung.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar hung.Bar mei link it ,mei ban lee.So kar lee ah.Ug ly hip see dai mei link it."

@Itsmuhdd 10 ай бұрын

One of the few people has the clear and awesome way to explain and deliver the information & knowledge! Thank you sir!

@ravindrakunwar4847 3 жыл бұрын

you are one of two youtubers for whom I have hit the bell icon. Bro you are king of formatting

@billminckler6550 Ай бұрын

This is FANTASTIC! Clearly communicated and demonstrated. So helpful. Thank you! 👏👏👏

@supplychainsys Жыл бұрын

I have been using custom formatting for years but your explanation was the best explanation I have seen on the subject. Provides insights on how to combine multiple formatting techniques. Great stuff! Thanks

@ianodonoghue7299 9 ай бұрын

This is an incredible video. This really helped me in work as an accountant I wanted my excel workings to match exactly the figures in the PDF without effecting others. Thank you so much

@quduslawal2591 3 жыл бұрын

Sumit Bansal is an Excel Sage. Hats off

@sanjaybetme 3 жыл бұрын

Yes indeed 👍🏻👍🏻👍🏻🔥🔥🔥

@ethiohelptube794 3 жыл бұрын

Thanks for giving us a new and important knowledge!!! You have no idea how much that’s important to me!!!

@jennydrumm7223 3 жыл бұрын

Oh, you're simply amazing! Before lunch I watched another of your videos and it was so great and now this one? I've been doing things like this the hard way forever! You're a terrific instructor; thanks!

@keithau8159 3 жыл бұрын

@sanjaysrivastava9671 3 жыл бұрын

Your deliberation and presentation are just excellent. Just by watching your videos, I have been able to learn it to a respectable level. It may be noted that I am from mini drafter and calculator era. Hats off

@trumpexcel 3 жыл бұрын

Thanks for the kind words Sanjay... Glad you found the video useful!

@jamesthomas8249 3 жыл бұрын

Was just finishing a profit margin review for 2020. These formats really made an impressive report. Thanks for your hard work.

@keithau8159 3 жыл бұрын

@SndfOmar 3 жыл бұрын

I've seen this custom format (hide) ;;; but kept forgetting it after months of not using it. Your explanation at ~ 3:30 will make it stick to my head forever. Thanks a lot! 🙏

@IvanCortinas_ES 3 жыл бұрын

Excellent explanation. The magic is back. Thank you very much for these tutorials Sumit!

@trumpexcel 3 жыл бұрын

Thanks for commenting Iván... Glad you found the video useful :)

@tlim1945 3 жыл бұрын

Very good tips. Delivered clearly and concisely. Easy to follow. Very few videos are like that. Your videos are one of the best.

@vijayarjunwadkar 3 жыл бұрын

Great video with really smart tips for custom formatting! Thanks a lot for sharing! 😊👍

@rashiedasuliman4138 3 жыл бұрын

Thank you for tutorial, it is very helpful. Always appreciate your tutorials.

@shahzadsami5613 3 жыл бұрын

100% having a worth to watch, High Quality Information

@venkatraj5491 Жыл бұрын

good video with best knowledge

@pchatterjee4150 2 жыл бұрын

Very well explained! Thank you so much.

@stanlomas 3 жыл бұрын

Very useful. Thank you. Will be using them today.

@deepaky129 11 ай бұрын

Great explained with concept. Watched so many videos about custom cell formatting but the way you explained is amazing.

@motalibcomputer6278 2 жыл бұрын

Finally I find a good thing which is truly helpful for us

@Littleboy_Bill 3 жыл бұрын

Amazing! Thank you for sharing this!

@monirhossain9850 3 жыл бұрын

Thank you for sharing amazing tips in Excel.

@trumpexcel 3 жыл бұрын

Glad you found the video useful!

@vikaasb2016 3 жыл бұрын

Simply sublime !!

@MostofaKamal-ll5dx 2 жыл бұрын

It's so much helpful indeed. Thank you very much.

@dhapumdhap 3 жыл бұрын

Simply Too Good and Simple! 👌👏👏👏

@Jack-er2uj 2 жыл бұрын

Thank you very much for sharing your knowledge.

@askulasaatwik8thc644 3 жыл бұрын

Thank you Awesome Excel tricks!

@xyclos Жыл бұрын

Very well explained. Thanks a lot!!

@pathakprathamesh 3 жыл бұрын

Super like ALL your videos. Your difference lies in the innovative application of the same function for which there are 100 other videos on how to use it.

@jdsingh8189 3 жыл бұрын

beautifully explained

@mrmusicloverable 3 жыл бұрын

Some powerful stuff. Thank you very much!

@trumpexcel 3 жыл бұрын

Glad you found the video useful!

@ramamohanpathapati7694 3 жыл бұрын

Thank you for clear explanation

@vijaykishan8649 3 жыл бұрын

Your explanation is superb Sumit. I always appreciate your work. Thank You.🙏🙏🙏🙏🙏

@musajuma7374 3 жыл бұрын

Simple and Excellent way to teach Thanks for your efforts you did for us,

@drjaganmohanraomeda615 2 жыл бұрын

excellently explained, thank you

@user-kd4rq4mr7u 5 ай бұрын

Great way to present. Thanks a lot. You're deserve to subscribe. I subscribed.

@trumpexcel 5 ай бұрын

Thanks for the sub! Glad you found the video helpful 🙂

@adnanali3971 2 жыл бұрын

Really great. Thank you very much. Keep sharing such insights. Many prays from Pakistan.

@wayneedmondson1065 3 жыл бұрын

Hi Sumit. Excellent custom formatting tips! Thanks for sharing :)) Thumbs up!!

@GosCee Жыл бұрын

Very well presented! This is the best Custom Number formatting explanation I have seen. Thank you very much, Sumit.

@rashidfaridkhan2664 2 жыл бұрын

Simple & Excellent way..Thanks Sumit

@keishrich 3 жыл бұрын

Helpful video. Thank you.

@vinaykhadilkar 3 жыл бұрын

I liked the video. Very well explained and to the point.

@HarpreetSingh1991 2 жыл бұрын

Your videos best than the short videos I watch. You have explained the reason behind why we write this or that . Thank u & I subscribed and liked the video.

@AlejandroMora29 3 жыл бұрын

Sumit, you are a wizard!

@Lalit_4166 2 жыл бұрын

Wonderfully explained

@kendrewt 3 жыл бұрын

Appreciated! I learned a lot from you!

@smitapatwardhan975 3 жыл бұрын

Your videos are very interesting and to the point

@thiyakup7333 3 жыл бұрын

Very Nice teaching, it's very useful

@phey6304 3 жыл бұрын

he knows perfectly what he is doing, a real guru in excel.. awesome presentation very brief clear and concise

@trumpexcel 3 жыл бұрын

Thanks for commenting Penny... 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 @t 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 @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t 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 @t bag dai bar kar kar @t 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 @t 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 @t mei link it.Mei ban @t kar lee @t ah luck @t 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 @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t 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 and no wonder draw tourists come to Holly Khilasa temple to vist at all,as long as modification of all kinds of hotels,motel facilities of all classes,definitely make big money globally at all,particularly from Europe,North America,Japan,Korea@@@@@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 flourish in 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 ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century,if not famous geologist,cosmology and archeologist not interested to visit the greatest nation of India.Last century 80-2 thousand ,movies as Fly and Lara Croft: Tomb Raider still have good memory in 21th@@@@@

@marynelrocero8092 Жыл бұрын

So useful, thank u so much!

@bluesage1528 3 жыл бұрын

Very helpful, thank you

@mayur7673 Жыл бұрын

thanks buddy .. last one was really good

@israelaguilera9613 2 жыл бұрын

Amazing work!

@mdks1012 3 жыл бұрын

Awesome! Very informative. Learnt a lot. Thanks so much.

@trumpexcel 3 жыл бұрын

Glad you found the video useful!

@srmchinni3 2 жыл бұрын

Really, your work is awesome and I see that all your videos are with extraordinary content. I will surely buy a coffee for you, soon.

@Mao-ze-dong Жыл бұрын

thanks man much needed

@swathic1621 3 жыл бұрын

Wisely explained ..worth watching bro.. keep it up👍

@raziajeena9861 3 жыл бұрын

been using excel for a while and learned lots. thanks

@trumpexcel 3 жыл бұрын

Glad you found the video useful!

@SndfOmar 3 жыл бұрын

Thank you for this awesomely usueful vid. Please make more vids of custom formatting tricks.

@trumpexcel 3 жыл бұрын

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

@rachitthakur3779 3 жыл бұрын

You have been an amazing trainer❤️🙏 #respect

@sushilnoatia6076 3 жыл бұрын

@@rachitthakur3779 v

@karthikiyer9502 3 жыл бұрын

Hi sumit. Needless to say, you are doing a great job. Keep it up. Your videos are very useful. Presentation is crisp and clear. I calculate more in excel like many of us. Just wondering if there is any option that would pop up instead of save your file when we are done calculation in that file. Pop up like, " Did you cross check your calculations" reminding to verify the sheet once again and then close the sheet. Kindly make a video or let me know if there is way out like that. Thank you Karthik.

@w.a.schull1357 3 жыл бұрын

Excellent explanations of these very useful techniques.

@trumpexcel 3 жыл бұрын

Glad you found the video useful!

@richardcharles9270 3 жыл бұрын

Thanks Great tips, looking forward to use them...

@trumpexcel 3 жыл бұрын

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

@jbcosta51 3 жыл бұрын

Very good explanation.

@mariabc9815 3 жыл бұрын

Thank you. Love your videos.

@trumpexcel 3 жыл бұрын

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

@alfredoas9635 2 жыл бұрын

WoW new trick... Thank You 🙏🏽

@mail2vj574 3 жыл бұрын

This is Gold.

@gregorytaylor2749 3 жыл бұрын

Fantastic tips! Thanks!

@trumpexcel 3 жыл бұрын

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

@jawaidiqbal945 2 жыл бұрын

Nice way to make understand Well done

@pratikbante2711 2 жыл бұрын

Thank you Sirji 🙏😊

@saifdogar8376 3 жыл бұрын

Good one. I even i knew m9st of them but new learning by very easy and descriptive methods

@Froilan355 Жыл бұрын

Great, very educational

@ramk1969 3 жыл бұрын

excellent tips sir...Thanks....

@jarna555 2 жыл бұрын

very nicely explained,Good job

@user-tl5lw7rc3m 3 жыл бұрын

Always with you new and useful

@trumpexcel 3 жыл бұрын

Glad you found the video useful!

@kprakashsha 3 жыл бұрын

Its explained very very very excellent

@jiajiaphotography 3 жыл бұрын

Very clearly explained and easy to apply to daily work

@trumpexcel 3 жыл бұрын

Glad you found the video useful!

@nitinparmar5117 3 жыл бұрын

Your all videos are very useful for us thanks for such an amazing videos.

@trumpexcel 3 жыл бұрын

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

@trendingpublic1069 2 жыл бұрын

Thanks for the information sir ❤️

@hubertg7100 2 жыл бұрын

Great Tutorial!

@dipankarbiswas033 3 жыл бұрын

Awesome 👍

@Adi-jk2ef 3 жыл бұрын

Amazing tricks 👍

@Jobin.Thomas 3 жыл бұрын

Nice topics and presentation. Subscribed

@tribhuvanmehta3162 3 жыл бұрын

Thks u so much, it is very helpful

@h33t18 2 жыл бұрын

Thanks for the tips!! I needed to hide non numerical data and this will help. No matter what I do my cells remove the negative sign - ??

@MrDhunpagla 3 жыл бұрын

Thanks for these useful tips 👍

@trumpexcel 3 жыл бұрын

Glad you found the video useful!

@alialbayati9368 3 жыл бұрын

Thanks Sumit for making this video.

@trumpexcel 3 жыл бұрын

Glad you found the video useful!

@PankajKumar-tr7bg Жыл бұрын

Amazing Video

@user-hy7vu6gc5n 4 ай бұрын

Best explanation on this subject

@trumpexcel 4 ай бұрын

Thanks 😊 Glad you found the video helpful!

@jeaniminerales5578 3 жыл бұрын

VERY USEFUL SIR

@sajanoberoi4018 3 жыл бұрын

Good to know.. thanks

@uolaod 2 жыл бұрын

Really it so an amazing explanation even though if you done a mistake during the tutorial still we learn. Mush thankful

@vijaykishan8649 3 жыл бұрын

Good Explanation. I really appreciate all your videos Sumit. Keep up the good work for us. Thank You.

@trumpexcel 3 жыл бұрын

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

@osamaboubou8134 3 жыл бұрын

thank you .. it is useful video

@mohanv3614 3 жыл бұрын

Very well explained with reasons

@trumpexcel 3 жыл бұрын

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

@debopomsaha8694 5 ай бұрын

thanks for clear explaination

@trumpexcel 4 ай бұрын

Glad you found the video helpful 🙂

@shibilsnoopy3973 3 жыл бұрын

Finally i found the excel king

@MohammadEkram-hm9ug Жыл бұрын

Absolutely worked it

@gvinodnair 3 жыл бұрын

Wow! That's a lots of unknown tricks and techniques. Thanks for sharing @TrumpExcel