Summary
Keywords
Full Transcript
How To Protect Cells That Contain Formulas In Excel Hindi - Dont allow formula editing by protecting cells containing formulas, but allow other cells to be edited. 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.. My Channels : A to Z Excel : https://bit.ly/3hQCRiw Deepak Techworld : https://bit.ly/3qFrbl5 Deepak EduWorld :https://bit.ly/3zWWtIS Deepak Nehra : https://bit.ly/364SVGV #protectformulas #lockformula #deepakeduworld Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day. Deepak EduWorld Playlist's: POWERPOINT COURSE ► https://youtu.be/OekrBhNybP0 ADVANCED EXCEL ► https://goo.gl/A6LdZA ADVANCED EXCEL FORMULAS ► https://goo.gl/bbHYu2 EXCEL TIPS & TRICKS ► https://goo.gl/wAj1jh MS WORD ► https://goo.gl/B4TeSA HTML5 & CSS3 ► https://goo.gl/2PFgs8 COMPUTER TECHNICAL videos ► https://goo.gl/paZmpn AUTOMATIC INVOICE IN EXCEL ► https://goo.gl/dFhg54 PHOTOSHOP ► https://youtu.be/m4KNkHwcV48 Subscribe Deepak EduWorld ► https://www.youtube.com/deepakeduworld Instagram ► https://www.instagram.com/deepakeduworld Facebook page ► https://www.facebook.com/deepakeduworld LinkedIn ► https://www.linkedin.com/in/deepakeduworld Facebook Group ► https://www.facebook.com/deepakeduworld
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
