Dont show formula in formula bar
Re-read Steve's instructions for hiding the formula in the formula bar using
sheet protection.
Gord Dibben MS Excel MVP
On Thu, 14 Sep 2006 22:22:06 -0700, Excel_Learner
wrote:
Thanks for your quick reply Steve.....my question is that I dont want to show
my formula in formula bar that is there in cells...
for example if
a1 b1 c1
in c1 i have a formula =sum(A1:b1) and the value is there. but when i come
to cell c1 formula appears in formula bar...i dont want to show that in
formula bar...
hope u know now what i need...please help
Hitesh
"Steve Jones" wrote:
If you still want the formula bar displayed and just your formulas hidden
you can FORMAT, CELLS, PROTECTION, HIDDEN.
You will need to protect worksheet (TOOLS,PROTECT, PROTECT SHEET)
Steve
"Excel_Learner" wrote in message
...
I do not want to show my formula in formula bar.
can anybody help????
|