How to lock cells containing formulas and hide the formula in MS excel ? urgent Plz..?

Answer 1

Highligt the cells that contains the formula you want to hide, then press Ctrl+1, in the protection tab check both options, then go to Tools, protection, protect sheet.

before you do this highlight all cells, press ctrl+1 then go to protection tab and uncheck all option.

Answer 2

First you have to Protect Document

Goto >> Tools >> Protection >> Protect Sheet or Entire Workbook

Then

Right Click on Cell >> Format >> Goto Protection Tab >> here select which one you want Locked and Hidden

But still you cant hide formulas, so I sugges instead, first make one backup copy for yourself, now copy the formula cell and then goto Edit >> Paste Special >> And select "Values" in Radio button, over

Answer 3

Look under Format --- Cells --- Protection
There are two check boxes for Locking and Hiding the cell contents.
After Locking or Hiding the cell contents, remember to protect the worksheet, or else it wont work

Answer 4

For locking cells :
From Tools click Protection and then Protect Sheets. It will open various options from which you can chose.
For hiding formula :
From Tools click Options and then 'View' and in 'Show' deselect 'Formula Bar'. This will remove Formula Bar.

Answer 5

Ok you do your thing on Excel. then you click on Tools, go to Protection, and protect workbook. Just remember that the protection password is case sensitive and if you forget it you're pretty much stuffed. Then save the changes