How to Protect formula in excel in Hindi by Abhay Excel

In this video we will learn about how to protect formulas in excel. we can easily restrict user to edit in formulas. use this trick in excel 2007 2010 2013 2016 and peoples cant play with your formulas. By default, all cells on a worksheet are locked; however, this has no effect unless worksheet protection has been applied. Here is a very easy way to apply worksheet protection so that only formula cells are locked and protected. To handle cell protection differently then you have change the default settings for the required cells. Here is a scenario to protect formula cells but allow access to data cells: 1. Select all cells in the worksheet by clicking on the top left corner or using [ ctrl + a ] of the sheet. 2. Right click anywhere in sheet and select format cell option. 3. Click on the Protection tab. 4. Uncheck the Locked and Hidden check boxes, then click OK. 5. Now select all cells that contain formulas.. you can select multiple range of cells by pressing CTRL key. 6. Right click on any selected cell and select Format cell option again. 7. Go to review tab.. select protect sheet option... put any password... save file... 8. all the selected cells is locked . and protected.. For protect Formulas /watch/UADRqHsPV_fPR In my channel you can also watch video related to PowerPoint, HTML, TALLY, Internet etc. So here I would appeal for to visit my channel and if you like this Video then I beg you to subscribe my channel... #abhayexcel #protectformulasinexcel #protectformula #formulasprotect #howtoprotectformulas #protection #exceltricks #exceltips #protectformulascellsinexcel #tricksandtips #functions #exceltutorial #tutorials #tips #tricks For CCC exam Preparation /playlist/PLPar9wB3f8YcHF23O4A1Wr3xZEwlxcS2p --------------------------------------------------------------------- To Subscribe my channel:- /AbhayExcelCom ... --------------------------------------------------------------------- --------------------------------------------------------------------- For M.S.Word videos /playlist?list ... --------------------------------------------------------------------- --------------------------------------------------------------------- For Basic Excel videos :- /playlist?list ... For Excel Magical Trick /playlist/PLPar9wB3f8Ydy0bP7gF4Q6Q5_K9N27iOJ For Advance Excel /playlist/PLPar9wB3f8Yf-M412AAKbVSbkzv4YAd9Q --------------------------------------------------------------------- --------------------------------------------------------------------- For Powerpoint Videos /playlist/PLPar9wB3f8Ye8-uNCErhZYb42j9aDlQR6 --------------------------------------------------------------------- --------------------------------------------------------------------- Online Income Videos /playlist/PLPar9wB3f8YfxSkDtgHA6BVoggN35Xp37 --------------------------------------------------------------------- --------------------------------------------------------------------- For Computer Tricks Change login password without old password /watch/ob-UptT2Cct2U --------------------------------------------------------------------- --------------------------------------------------------------------- Our Top 6 videos /watch/Yi8D0gEOh1nOD /watch/8bfmUpAauAjam /watch/kJw3l09AKA_A3 /watch/oYpPnJhJxgBJP /watch/gnjcJnwlmCwlc /watch/sALuW4ofIZHfu Follow me on Facebook. https://www.facebook.com/Abhayexcelco ... --------------------------------------------------------------------- --------------------------------------------------------------------- FOLLOW ME ON GOOGLE+ https://plus.google.com/1107860104906 ... --------------------------------------------------------------------- --------------------------------------------------------------------- Visit our Blog https://successwaywithabhay.blogspot.com --------------------------------------------------------------------- --------------------------------------------------------------------- Visit Our Website https://newexcelcomputer.wordpress.com/ --------------------------------------------------------------------- --------------------------------------------------------------------- Thanks for watching my video. --------------------------------------------------------------------- --------------------------------------------------------------------- #abhayexcel दोस्तों मै उम्मीद करता हु आपको मेरा ये विडियो पसंद आया होगा | दोस्तों अगर आपको कंप्यूटर या इस विडियो से सम्बंधित किसी प्रकार की कोई समस्या आ रही है तो आ

Category