Formula bar

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

Billy Thomas

I am using XL 97. i know that i can hide the cell entry by using the ;;;
format, but the entry still displays in the formula bar. Is there a way to
allow data entry in a cell, but have the entry not show in the formula bar.
I want the formula bar itself to be visible.

thanks

Billy
 
First make the cell invisible by using the ";;;" format.
Then choose the "protection" tab in the same dialog and select "hidden"
checkbox. You can uncheck the "Locked" checkbox if you want to allow the
user to enter data in the cell. Then protect the sheet using
Tools-Protection-Protect Sheet.

Regards,
Ram
 

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

Notepad status bar missing even after Registry entry 1
Help needed 0
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1
Cell shows the last typed text, no matter where it is typed 0
Formula Bar - display of content 4
invisible formula in formula bar 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel 2002: How to make the date format uniform ? 1

Back
Top