View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Brettjg Brettjg is offline
external usenet poster
 
Posts: 295
Default 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.