How & when to freeze cell reference in Excel (हिंदी में)

👉 FREE Excel Webinar. REGISTER NOW
event.webinarjam.com/register...
In this video, we will talk about How to Freeze cell reference in Excel (in Hindi).
=========================================================
Download Excel Workbook: learn-with-lokesh-lalwani.thi...
=========================================================
For any training requirement - [e-mail], [e-mail]
Or
Visit: www.nurturetechacademy.in/
=========================================================
The beauty of Excel is that we just need to apply a function for only one record in the entire database and the moment we copy and paste it down it applies to the complete data. Sometimes we need to change this property of Excel, as we can’t, so Excel has given us an option of freezing any cell reference by adding a “$” before the cell reference. For any Excel user, it's very important to know where to put the “$” sign. Excel facilitates 3 types of cell references. Let’s understand them one by one.
1). Relative Reference: This is a default reference in Excel. Whenever we refer to a cell and copy the same reference and paste it in any other cell, the cell reference changes accordingly. This is the heart of Excel.
2). Absolute Reference: Putting “$” sign before column and row is known as an absolute reference e.g. “$A$1”. At times we would like to keep a cell reference or a range static, there we use such reference.
3). Mixed Reference: Putting “$” sign either before a column or before row termed as mixed reference. When we would like to deliberately want the reference to be changed either side then this reference is to be used.
===================================================
LIKE, SHARE, COMMENT, SUBSCRIBE TO MY CHANNEL, PRESS THE BELL ICON
For more such videos subscribe our channel: / @learnwithlokeshlalwani
Follow me on my Instagram for the latest updates: learnwithlo...
#learnwithlokeshlalwani
#nurturetechacademy

[@learnwithlokeshlalwani]

Learn Excel from my in-depth course: hi.switchy.io/ExcelMasterclass 🔥🔥

[@landenfrancisco4481]

I know im randomly asking but does someone know of a method to get back into an instagram account..?
I was dumb lost the login password. I would appreciate any assistance you can offer me!

[@ericklevi9735]

@Landen Francisco Instablaster ;)

[@landenfrancisco4481]

@Erick Levi i really appreciate your reply. I got to the site through google and I'm trying it out now.
I see it takes a while so I will get back to you later with my results.

[@landenfrancisco4481]

@Erick Levi it did the trick and I actually got access to my account again. I'm so happy:D
Thanks so much you saved my ass!

[@ericklevi9735]

@Landen Francisco glad I could help xD

[@noumanihsan2439]

well, I've to be honest with you Lokesh, I found many tutors but you are the one which taught us the significance and logic of this topic. Impressive. I really appreciate that.

[@neelkamal5274]

Truly said...

[@ravichandra5763]

👍

[@panachenoida3595]

Had been taught while financial modeling course but forget during course of time.
Suddenly I required mixed reference but thanks to your video I remember everything

[@xlntchoice]

Thank you Lokesh bhai for sharing this very informative video which is really helpful in understanding the advance part of excel.

[@milindianx]

Well explained !! So finally I understand the matter of Dollar sign 🤗😇

[@prateekkamboj908]

Lokesh, this was perhaps the best and simplified tutorial i have came across.
Great.! 👍🏻

[@sundeep841]

great technique and easiest way of understanding.....outstanding sir.

[@24MovieMasala]

Since beginning I never commented any of on tutorials, the way you explain clearly and simple to know the process which is very important to apply on work time.
So first time I feel to comment on your session.
Great effort sir, I wish you endless joy in your life.

[@learnwithlokeshlalwani]

Glad it was helpful!

[@manwarhossain3296]

Awesome !!

[@theabhishekshaww]

loved this tutorial

[@piyushsharma2829]

Very well explained, Best explanation ever.

[@sirajali8403]

Thank you so much sir,,,,for this, very useful video...
Your explanation is amazing...
I have cleared all my doubts.
I have never seen before this type of explanation ❤️
Thanks Thanks a lot Sir.... 😊

[@fctknowldge2023]

Very well explained....its appreciated...thanks for explain very easier way

[@learnwithlokeshlalwani]

You are most welcome

[@Loveforyou1987]

Way of explaining the topic is unbeatable.

[@dhirendranegi293]

Ati sunder Lokesh ji

[@sujatapadol1830]

Owesome sir.... Thanq so much... Mene bhot video dekhe refferance ke pr isme bhot ache se smj aya... Thanq sir

[@learnwithlokeshlalwani]

I'm delighted to hear that you found the videos helpful for your reference.

[@lukumonikalita7027]

Beautiful explanation sir..... No one can match with u

[@afridishaikh6425]

Mza aagya shaandaaar jabardast jindabad 🤪🤪🤪 you explained very well

[@arnabsaha33]

This was the best way to teach this topic. Thank you.

[@AmanSharma-bf8ot]

Explained in a lot easier way.. Hatsoff..

[@kirtipatwa3273]

Thanks alot for this lovely explanation 😊

[@SunShine-ew4ru]

Very well explained.. a big thanks!!!

[@shailendrasoni3881]

I am very impressed to learn work deeply

[@vijeshpoolakkil978]

thank you so much. how crisp and Clear !!!

[@vinaykumarpandey7540]

Bhai apki har video super se uper hai ...

[@shwetapatidar856]

Your explanation is too good ...thank you 🙏☺️

[@Dhirendarkumar]

Great sir...simple explain

[@suhaswaingankar]

You covered a really helpful topic

[@aayushkhazanchi7770]

crystal clear,thanks

[@soniyayadav1102]

Thanks a lot ☺️i would really thankful 🥰After watching this video i am very clear this $ system.😃

[@09rohitgoel]

Nicely explained, great help

[@hemantashrestha589]

Best teaching style❤

[@learnwithlokeshlalwani]

Thanks

[@mahith266]

Wow wow wow wow just wow what a perfect way to explain this absolutely brilliant

[@learnwithlokeshlalwani]

Glad you liked it!

[@kksuryani]

Very Apt & very good explanation. Thanks

[@sikandaralishah9767]

Thank you so much Sir, Love from Pakistan. You explained so beautifully.

[@yashwantkumarpatel5558]

शानदार!

[@helloworld2041]

Bahut achi video bhaiya

[@GauravKumar-rs4rx]

bhut acha smjaya

[@luckysaini8530]

Great Learning

[@SAM-dq2qe]

Nice explanation...thank you.

[@kunalaggarwal3551]

easy to understand explanation sir 👍 keep uploading your videos.

[@Playkhan8940]

Sir maza aagaya

[@dipakpapu]

Thanks I was so confused but you make so easy

[@kirankoli1188]

Thanks sir to clear my concept

[@ashleyohsosurreal]

Tysm lokesh

[@VikramSinghKhalsa1998]

Thank u so much sir
Excellent work

[@Pawanmotivational1995]

THANKS SIR YE CONSPECT CLEAR KARNE KE LIYE

[@Accounts.sharemarket]

Thank you so much introducing this trick

[@Rhythm_of__life]

kya samjhaya apne sir ................. 🙏🙏🙏

[@rajusil3904]

Very nice

[@neelkamal5274]

Thank you for explaining in a very clear way.
Also, your voice is very nice and Crystal clear in the video.
Once again thanks.

[@learnwithlokeshlalwani]

Glad it was helpful!

[@user-hq5gr9hk1j]

Very very well explained

[@aakashpriyadarshi3645]

Very very Important.

[@bankimtailor678]

Best teaching

[@narendervannam4345]

Dear Lokesh, very nice explanation & good pronunciation..
It was very interesting to hear..

[@noorirfan4886]

Thank you sir ,aapne Mera bahut bara problem clear kar diya.

[@learnwithlokeshlalwani]

Most welcome.

[@anapplemango9464]

Hello genious, your way of instruction are so good, please make more sensitive ms.excel tutorials near about practical office work, thanks a lot.

[@kamaldeep8682]

Thnks sir apka Samjane ka tarika best h thnku sir

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@janusinha1322]

Thank you so much sir

[@amitkumarjayant4884]

Very nice work

[@amitkumargautam8754]

Bahut behtreen explain kiya.

[@learnwithlokeshlalwani]

Thank you so much.

[@naeemulhassan1426]

Mr. Lokaish sb. Your teaching style is very nice . I want see some tutorial on sales report at ms excel and some if , someifs. Topic.

[@shriidharkulkarni6648]

Very very impressive. Even a nut like me could understand this. Thanks a lot.🙏👌

[@learnwithlokeshlalwani]

Glad it was helpful!

[@omparkashjoshi6504]

Excellent. Easily understand, Thanks lot
Please make ghant chart, I want to learn.

[@fitnesscreator8317]

Nice one
I was was interested to learn
But u make me the master

[@vikasdwivedi3159]

Thank you ❤️

[@zaibaparveen2153]

Well explained thnkuh

[@sudhanshuyadav4441]

Wow sir amazing😍😍😍👍👍👍👍

[@Satyarathgupta]

Thanks 👍

[@surendrasinghchawla8762]

Thanks sir very nice

[@mukeshsinghrawat8660]

Thank u very much sir

[@user-hq5gr9hk1j]

Amazing explanatim

[@divyarani2747]

Thanku sir actually maine pura course kar liya tha par mujhe fix karna nhi aaraha tha jiski wajha se problem ho Rahi thi.
Thanku sir itne ache se samjhane ke liye😊

[@ShaibulHoqueMozumder]

Thank you sir

[@purvimakwana4968]

Very clen explained.

[@user-hq5gr9hk1j]

Amazing expl

[@laxmankumarskd6030]

Apne bahot hi achhe se samjhaya

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@laxmankumarskd6030]

Sir, please microsoft dynamics navision aap pr video banaye

[@AabhasVerma]

Thank you so much.

[@afzaaliftikhar3497]

Zabardast

[@RahulJha-uk8pn]

Thanku so much sir ❣️❣️

[@MONUYADAV-ue8fm]

Thanks sir. These small things is very important things.

[@learnwithlokeshlalwani]

Thank you so much. Glad to hear it.

[@venkateshkapgate1676]

Thank you🙏

[@merajkhan7985]

Your teaching method is very very simple. Many many thanks for it, Sir.

[@learnwithlokeshlalwani]

Thank you so much for your comment.

[@MASHIR925]

Very very nice👍

[@arunmanjunath09]

👌👌 nice Sir

[@musicsang4882]

Excellent teaching Sir.

[@learnwithlokeshlalwani]

Keep watching

[@dheerendrakaibartta663]

Thanks video sir

[@gyanapipasuasmyaham2966]

Actually this is very useful video.
Thank you Sir

[@learnwithlokeshlalwani]

Glad to hear that

[@lasbaraprehs5818]

Wow
Super trick.
Thank you so much. Love you❤

[@learnwithlokeshlalwani]

Thanks you so much for your comment.

[@mahamudsujon2239]

You are really best teacher... Love u dada🥰

[@learnwithlokeshlalwani]

Thank you so much 😀

[@YashSharma-hf1vx]

thank-you sir

[@sainisneh7808]

nice teaching

[@kajalgupta79]

Impressive explanation

[@learnwithlokeshlalwani]

Glad you liked it

[@Umesh5878]

Tysm sir🙏

[@hsdhakad4865]

Thsnks sir

[@prachidwivedi3817]

Really really impressive sir, Thank you so much!❤️

[@learnwithlokeshlalwani]

Keep watching

[@rehanyusuf9406]

Thanks

[@kumarkailash7297]

Nice video sir

[@gyanapipasuasmyaham2966]

Love you Sir

[@noorirfan4886]

Thanks for clear my doubt

[@learnwithlokeshlalwani]

Happy to help