Hide Formula

[Joe]

Hi,
Can I hide the formula in an excel cell?

Thanks
Joe

 

[Ragdyer]

Yes !

Select the cell(s) containing the formula(s) that you wish to hide, then:
<Format> <Cells> <Protection> tab,
Place a check in the "Hidden" box.

Now, you must protect the sheet for this to take effect.

If this hinders the functionality of some of the other cells on the sheet,
you must *unprotect* those particular cells beforehand.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Paul B]

Joe, Format, cells, protection, check hiden, locked or unlocked and then
protect the sheet. You will then not see it in the formula bar

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Max]

Either press F5 > Special > Check "Formulas" > OK
(this will select all formula cells in one swoop)

or select the particular formula cell(s)

Click Format > Cells > Protection tab
Check "Hidden" > OK

Click Tools > Protection > Protect Sheet
Apply password (optional) > OK