E
Excel_Learner
I do not want to show my formula in formula bar.
can anybody help????
can anybody help????
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
FloMM2
Try this:
Tools
Options
Select the View tab and uncheck Formula bar.
FloMM2
Tools
Options
Select the View tab and uncheck Formula bar.
FloMM2
S
Steve Jones
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
you can FORMAT, CELLS, PROTECTION, HIDDEN.
You will need to protect worksheet (TOOLS,PROTECT, PROTECT SHEET)
Steve
E
Excel_Learner
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
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
G
Gord Dibben
Re-read Steve's instructions for hiding the formula in the formula bar using
sheet protection.
Gord Dibben MS Excel MVP
sheet protection.
Gord Dibben MS Excel MVP