Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dont show formula in formula bar
I do not want to show my formula in formula bar.
can anybody help???? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dont show formula in formula bar
Try this:
Tools Options Select the View tab and uncheck Formula bar. FloMM2 "Excel_Learner" wrote: I do not want to show my formula in formula bar. can anybody help???? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dont show formula in formula bar
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???? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dont show formula in formula bar
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???? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Formula to show zero if reference cell is zero? tricky! | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |