Hide text in formula bar

  • Thread starter Thread starter Billy Thomas
  • Start date Start date
B

Billy Thomas

I am using excel 97. I know it is possible to hide the edit or formula bar,
but I wan tit visible, just want the cell contents not to show up in it. I
konw that "hidden" option will work, but I don't want to protect the cells.
Is there anyway to have some cells not show up in the edit bar without using
protection?

thanks,

Billy
 
Billy,

If it's formulas you don't want shown, you can format the cells (Format -
Cells - Protection - Hidden). Then protect the worksheet (Tools,
Protection, Protect Sheet. If that isn't it, explain why you want a formula
bar, but don't want it to work sometimes.
 

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

Hiding Formulas in Formula bar 3
Displaying results in formula bar when cell is hidden 1
Formula bar 1
Formula Bar contents missing 8
Hiding Formulas and Being Able to Make Changes 2
invisible formula in formula bar 1
Formula Bar - display of content 4
Hide a Formula 3

Back
Top