MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Don't show the data on the formula bar

Posted by rebecca on December 10, 2001 12:27 AM

Does anybody know how to made cell value to be hidden on the formula bar but can show in the active cell ?

Posted by Bruno on December 10, 2001 12:39 AM

You can always hide the formula bar...

Posted by Ampleford on December 10, 2001 5:06 AM

Protect the cell, using "Format Cells", and also click on the HIDE button in the protect tab, then protect the spreadsheet.....