how do I hide a cell formula from the formula bar

S

S. Shah

I want to enter a formula in a cell - but dont want it to appear in the
formula bar.
Please let me know - how to go about it. Thanks.
 
G

Gord Dibben

Format>Cell>Protection>Unlock the cell and enable Hidden

Tools>Options>Protect Sheet................sheet MUST be protected


Gord Dibben MS Excel MVP

On Sat, 6 Dec 2008 13:40:00 -0800, S. Shah <S.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Displaying results in formula bar when cell is hidden 1
Formula text in woorksheet cell 2
invisible formula in formula bar 1
Formula Bar - display of content 4
Extra characters appear in the formula bar but not in the cell 1
Configure Formula Bar 6
Cursor now appearing in formula bar, no longer in cell 2

Top