How To IMMEDIATELY Auto Lock Cells After Data Entered in Excel
#deepakeduworld #Excelinhindi #lockcells
दोस्तों इस एक्सेल के वीडियो में आप सीखोगे की डाटा एंट्री करते ही सेल ऑटोमैटिक लॉक कैसे होंगे ! एक बार सेल में एंट्री कर दी तो कर दी फिर उस सेल में एडिट नहीं होना चाइये ! तो बहुत आसान है ये एक्सेल में करना
in this excel tutorial you will learn How do you automatically lock a cell / protect cell after a value is entered? Once the data has been entered we wish to lock the cells in such a way that we requires a password to make any changes so This tutorial demonstrates how to automatically protect data immediately in excel after it has been entered in a cell.
is excel ke video me aap seekhoge ki cell me data entry kartey hi cell immediately automatic lock kaise ho to bahut sare offices me is Excel Magic Trick ki jarurat hoti hai ki 1 baar jo entry kar di to kar di fir usme koi change nahi hona chaiye to iske liye hum 1 magical VBA Macro ka use karangey
Download VBA Macro Code : drive.google.c...
Download Training File : drive.google.c...
MORE USEFUL EXCEL VIDEOS FOR YOU : -
1. SURPRISING Excel Formula 2020- Most Excel Users Don't Know ( Concatenate cells with line break ) • SURPRISING Excel Formu...
2. 3D Formulas in Excel • Why You Should Use 3D ...
3. Top 5 Excel Tips and Tricks 2020 - Excel Users Should Must Know • Top 5 Excel Tips and T...
4. Very Small Excel Formula ( NetWorkDays ) To Calculate Working Days Between Two Dates • How To Calculate Worki...
5. HIDDEN Excel Trick You Don't Know 2020 - You Never Miss To Use it • Excel Trick You Should...
Hope you will like the video. Thanks For Watching Friends.... Have A Nice Day...
Deepak EduWorld Playlist's:
ADVANCED EXCEL ► goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
Excel Tips & Tricks ► goo.gl/wAj1jh
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
COMPUTER TECHNICAL videos ► goo.gl/paZmpn
Automatic Invoice's in excel ► goo.gl/dFhg54
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepak__nehra
Facebook page ► / deepakeduworld
LinkedIn ► / deepakedu. .
Facebook Group ► / cse92
We Always Provide Useful & Helpful Content On The Deepak Eduworld RU-vid Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
14 окт 2024