Why We freeze or Lock Ranges | Table | Cell in Excel Formula | Absolute Reference in Excel in Hindi
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- Why We freeze or Lock Ranges | Table | Cell in Excel Formula | Absolute Reference in Excel in Hindi - Doston apne aksar dekha hoga jab bhi hum excel mein ko formula lagate hai to usme Cell, Ranges, Table, Data ko freeze ya lock kar dete hain. Ise hum Excel mein absolute reference kehte hai. Microsoft Excel mein iska benefit ye hai ki hum kisi range | table | data | cell ko freeze or lock kar sakte hain aur jab bhi us formula ko copy karke kahin aur paste karenge to jo Range or Cell or Table reference hai wo change nahi hoga.
An absolute reference in Excel refers to a reference that is "locked" so that rows and columns won't change when copied.
🔥🔥हमारा कंप्लीट एक्सेल कोर्स खरीदने के लिए इस विडियो को देखें 👉bit.ly/3aeYouY
Download Practice file - drive.google.c...
❤Show your LOVE by “ LIKE COMMENT & SHARE this video ”
❤Don’t forget to “SUBSCRIBE & PRESS THE BELL ICON”
Please support me on
Like us on Facebook - / mylivesupport
Website - mylivesupport.in/
Follow us on Twitter - / mylivesupport
Follow us Instagram - / mylivesupport
Facebook Myself - / chandankumar926
TH-cam - / mylivesupport
▶️WATCH ALL VIDEOS FROM BELOW PLAYLIST :
▶️All Video for MS Excel Magic Trick Series - goo.gl/qS296Q
▶️Top 10 Excel Video in Hindi - goo.gl/McEe53
▶️All Videos of Excel in Hindi - goo.gl/boUo8C
▶️All Videos of Technology in Hindi - goo.gl/E9VyCA
▶️All Videos of MS Excel VBA in Hindi - goo.gl/W4pb5t
▶️All Videos for Tally.ERP9 GST in Hindi - goo.gl/CbsFhr
#Excel #FreezeorLock #Ranges #Table #Cell #ExcelinHindi
Most Useful Videos of Our Channel - Must Watch
▶️How to Convert Handwritten Notes in MS Word using Google Drive | Hindi Tutorial • How to Convert Handwri...
▶️How to Maintain Attendance Register and Salary Sheet in Excel | Step by Step Tutorial in Hindi • How to Maintain Attend...
▶️Make Fully Automatic GST Invoice | Bill in Excel | Auto Save Each Invoice | Multi Items & GST Rate • Make Fully Automatic G...
▶️🔥How to Recover Unsaved MS Office Files | Excel | Word | PowerPoint without any Software 🔥 • 🔥How to Recover Unsave...
▶️Excel में किसी भी Sheet को Print करो Expert की तरह | Become MS Excel Expert • Excel में किसी भी Shee...
▶️Ms Word में Expert बनना है तो इन 5 Magical Tricks का USE करना सीखलो • Ms Word में Expert बनन...
▶️Excel की इन 20 Shortcut Key का Use करना सीख लो | Become Excel Expert | My Live Support • Excel की इन 20 Shortcu...
▶️ऑफिस में बनना है सबसे Smart तो MS Word की इन 20 Magical Tricks का Use करना सीखलो • ऑफिस में बनना है सबसे ...
▶️4 Super Cool Tricks for MS Excel | Excel Magic Trick Part 13 • 4 Super Cool Tricks fo...
▶️बॉस को करना है Impress तो Excel में ये 4 Super Tricks जरुर सीखें | Excel Magic Tricks Part 6 • बॉस को करना है Impress...
▶️How to Convert any Image to Excel | MS Excel New Feature Tutorial in Hindi • How to Convert any Ima...
Our aim behind making this channel to make you expert in Microsoft Excel, Microsoft Word, Tally.ERP9, Computer and Technology. You can easily learn Excel, Word, Tally, Internet, Computer in Hindi language. So don’t forget to Subscribe Our Channel.
learn excel in hindi,excel formulas in hindi,excel in hindi,advanced excel in hindi,ms excel tutorial in hindi,learn ms excel in hindi,excel,excel course in hindi,free excel training,learn excel online,advanced excel,advanced excel formulas,microsoft excel,ms excel 2007,ms excel 2016,ms excel 2019,excel for beginners,excel function in hindi,ms excel tutorial,excel tutorials,freeze cell,Absolute Reference in excel,freeze formula,freeze ranges,freeze table,lock cell,lock table,lock data in excel,mylivesupport,excel absolute reference
---------------- Chandan Kumar ----------------
दोस्तों वीडियो को लाइक और चैनल को सब्सक्राइब जरूर करें 🙏🤗🥰
Thanku so much for your nice explanation
your detail explaination is deserved to like your channel
Thank you so much bro omg i literally searching this badly ...❤
Finally I understand the criteria and range meaning in excel.
बहुत ही सुन्दर से समझाए हैं। बहुत धन्यावाद
हर किसी टीचर में ऐसा समझाने की कला नही होती है,आप जैसे लोग बहुत कम होते है
बहुत प्यारा समझाते हो भाई थैंक्स
Thanks a lot
hi bhi viedo acha laga , like kar diya hai
Lot of Thanks..!
thanks bro
Solved my data
Thanks alot bhai🙏🙏🙏
Thanks a lot sir 🙏👍👍
Excellent Wow Good
Very nice 👍
Nice and thank you
Zaberdast
Thank you sir, Video bahut hi informative hai 😊😊😊👏👏👏
Thank you so much sir
Thank you Sir🙏
Bahut good h
Very informative video...I guess this is the only video available on internet on this concept...and you explained brilliantly bro....
Thanks 🥰😄
Nice explanation bro...
Good Explain
Nice video sir
It's very useful thankyou so much
Very good
thnks
Thanks sir❤️
It's very helpful video Thanks bro.
Thank u sir
Thanks
शानदार जानकारी जो काम कि है
Very good explanation
bahi aap ki awaj bilkul new repoter jaisi hai app ko news repoter hona chaiye
Thnk u sir
Thank you. Lot sir 🙏👍👍 superb.... God bless you
Most welcome 😃😃
Wow what an explanation...😃😃👌
Very useful. Thanks for the video.
very use full👏👏
Thank you sir for your great efforts
Stock ke bare me khuch batiye sir inwoard outward net stock
wow! super explanation...👍
bhai jo aapnay range ki selection hai woh kaisay ki hai. yeh btadain please.
Good
Wow wonderful explained
Namaste chandan
Good teacher
Thanku very very much
Good example
Sir, please see if we have a solution for, to copy one column in sheet1 to sheet2 in a excel file, condition is sheet 1 data is being refreshed after every 15 minutes in the same column and overwriting the previous data, and we need to capture that sheet 1 column in sheet two keeping the old data as well.
Very good presentation
Thanks
Happy new year sir ji
f4 key kam nai kar raha hai
Hello sir your video nice
thanks
Chandan Sir,
रोज़मर्रा के office-work में काम आने वाला video है | ; )
Ms-excel में मेडिकल स्टोर पर कैसे कार्य किया जाता है दवा का बिल पर्चा कैसे बनाते हैं उसके बारे में वीडियो बना दीजिए सर प्लीज
Wow!! Your explanation is so simple and easy to understand. Happy new year 2020
Happy New Year to you and your family
Thank you sir!
Nice bro
Happy New year
Sir hm har formula ko freeze kr skte hai kya
Nice vdo
Sir freezing kaha 2 baar kare kaha 3 baar kre kyu kare plz ispe video banaye
Sir what are the other ways to freeze the range? I am unable to do it with f4.
i am too facing problem
Sare farmula me ye f4 lgane pdege or kewal sumif me
Nice vedeo
How to lock in laptop ..cause when I try to lock the formula in my laptop press f4 that time showing different thing lock r not happening..Pl help
Same hare 🙁
HAVE YOU ANY LINK FOR MS OFFICE 2019 OR ONWARDS
Nyc sir
Sir select krne ke baad aapke table ke cell highlight kaise hote hain
Sir ye problem Excel 2013 me nahi ho raha hai
My F4 function is not working in formula so what is the solution
Maan gaye sir u r awesome.
Sir y batao humne criteteria kyu nhi freeze kiya plzz batao
🥰🥰
Excel se massage kaise bhejte hai video class chahiye
Sir F4 se range freeze nahi ho rhi kya reason ho skta h or kaise resolve kre..
Same problem
@@sunilpatel-sq7px press F4 with Fn key
@@pankajverma-bd8bf thank you so much finally ab freez hua hai thank you 🙂🙏
Mere laptop me F2 and F4 kaam nhi kr rha hai..kuch setting kr na hoga kya?
Fn button daba ke rakho uske baad F2 or F4 button press karna
@@MyLiveSupport bro F4 kaam nhi kr raha
Mere me bhi F4 kaam nhi krn raha aapko koi solution Mila kya
@@littleeyes077 nhi mila
Laptop me f4 kaam ni ker reha hai
For laptop press fn+f4 button
When I press F2, simply reduce brightness instead of showing formula
Fn+F2 for laptop keyboard
@@MyLiveSupport I was searching for this onlyyyyyy.... Thanks man
I ALSO WANT THIS SOLUTION
Laptop me kaise lagaye
fn+f4
Ser excel me 0 age kaise lagay batao please
Select Cell / Cells where you want a zero before the number. Go to format cells > Number > customize > below Type there is a box 0.00 > delete it > if there are 3 number then enter 000 > go to excel and tnow if you type 1 in the selected cell / cells you will get 001. Thanks to My Live support where I have learnt many new things.
bhai f4 press krne se brightness ka show horra hai or freeze ni hora
Fn+F4 button dabao
@@MyLiveSupport ok
એક્ષલ માં એવું થઈ શકે કે માસ્ટર ફાઈલમાંથી VBA koding દ્વારા અલગ ફોલ્ડર માં સેવ થઈ શકે દશ કંપની ના employees Hoy to darek કંપની વાઈઝ એમનાં કર્મચારી નો ડેટા કંપની નું ફોલ્ડર બની એમાં save thai jay
To bhaiya ( DELHI )
सर क्या आप अपना नंबर दे सकते हैं मुझे आपसे बात करके कुछ सवाल पूछना है
Lekin laptop me f4 button kaam nhi kar rhi hai
Fn + F4 button ek sath press karo
Thanks
@@MyLiveSupport thank you so much 👍
As we freeze the cell by pressing F4 key in excel formula In the same way, in VBA code How to freeze cell Range
When we insert a cell in a table, the macro code does not run because the cell range changes when we insert cell how do we correct it?
Thanks a lot sir 🙏👍👍
Good
Thanks a lot sir 🙏👍👍