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 : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : 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 ►
• MS Power Point Tutoria...
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 IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld
Негізгі бет How To Protect Cells That Contain Formulas In Excel HINDI
Пікірлер: 234