| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell contents in formula bar
Hi there, my formula bar is displayed, and usually the contents (value or
formula) is displayed there. However, in another workbook that I did not create, the contents of the cell does not display in the formula bar. I can't seem to find anything in options to change this. Thankyou for any help that comes my way. Brett |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell contents in formula bar
Choose Format, Cells. In the Format Cells dialog box, click the Protection tab.
There will be a check box against Hidden. With this setting you can not see the formula, only its result. You need to unprotect the Workbook (you need the password which was used to protect it) and then clear the check box. "Brettjg" wrote: Hi there, my formula bar is displayed, and usually the contents (value or formula) is displayed there. However, in another workbook that I did not create, the contents of the cell does not display in the formula bar. I can't seem to find anything in options to change this. Thankyou for any help that comes my way. Brett |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell contents in formula bar
Sounds like the sheet is protected,
with the setting for formulas to be hidden If you're looking to do likewise, the basic sequence is, with the cells selected: 1. Format Cells Protection tab Check "Hidden" OK 2. Tools Protection Protect Sheet OK -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Brettjg" wrote: Hi there, my formula bar is displayed, and usually the contents (value or formula) is displayed there. However, in another workbook that I did not create, the contents of the cell does not display in the formula bar. I can't seem to find anything in options to change this. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell contents in formula bar
Is the sheet protected? You can set cells to be locked and hidden, and
when protection is applied the cells behave as you have described. Hope this helps. Pete On Jan 30, 11:42*pm, Brettjg wrote: Hi there, my formula bar is displayed, and usually the contents (value or formula) is displayed there. However, in another workbook that I did not create, the contents of the cell does not display in the formula bar. I can't seem to find anything in options to change this. Thankyou for any help that comes my way. Brett |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell contents in formula bar
Perfecto, thankyou.
"Pete_UK" wrote: Is the sheet protected? You can set cells to be locked and hidden, and when protection is applied the cells behave as you have described. Hope this helps. Pete On Jan 30, 11:42 pm, Brettjg wrote: Hi there, my formula bar is displayed, and usually the contents (value or formula) is displayed there. However, in another workbook that I did not create, the contents of the cell does not display in the formula bar. I can't seem to find anything in options to change this. Thankyou for any help that comes my way. Brett |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell contents in formula bar
Perfecto, thankyou
"Max" wrote: Sounds like the sheet is protected, with the setting for formulas to be hidden If you're looking to do likewise, the basic sequence is, with the cells selected: 1. Format Cells Protection tab Check "Hidden" OK 2. Tools Protection Protect Sheet OK -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Brettjg" wrote: Hi there, my formula bar is displayed, and usually the contents (value or formula) is displayed there. However, in another workbook that I did not create, the contents of the cell does not display in the formula bar. I can't seem to find anything in options to change this. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell contents in formula bar
Perfecto, thankyou
"Sheeloo" wrote: Choose Format, Cells. In the Format Cells dialog box, click the Protection tab. There will be a check box against Hidden. With this setting you can not see the formula, only its result. You need to unprotect the Workbook (you need the password which was used to protect it) and then clear the check box. "Brettjg" wrote: Hi there, my formula bar is displayed, and usually the contents (value or formula) is displayed there. However, in another workbook that I did not create, the contents of the cell does not display in the formula bar. I can't seem to find anything in options to change this. Thankyou for any help that comes my way. Brett |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell contents in formula bar
You're welcome.
Pete On Jan 31, 12:10*am, Brettjg wrote: Perfecto, thankyou. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell contents in formula bar
welcome
-- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Brettjg" wrote in message ... Perfecto, thankyou |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell contents in formula bar
.. can set cells to be locked and hidden
Its independent. The settings can be for cells not to be locked but hidden only, and it'll still work to hide the formulas when sheet protection is applied. Albeit I do believe that the 2 features, ie: locked and hidden are meant to be applied together. -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using cell contents in a formula | Excel Worksheet Functions | |||
| How do I use cell contents as an address in a formula | Excel Worksheet Functions | |||
| Using cell contents within a formula | Excel Worksheet Functions | |||
| Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
Linear Mode
