PDA

View Full Version : How to stop displayig a cell text in the formula bar?



megtoma
08-20-2014, 02:37 AM
Hello,

Does anyone know how to stop displayig a cell text in the formula bar? I would like to still see and be able to alter the text in the cell.

I would appreciate your help.

Aflatoon
08-20-2014, 02:55 AM
You can set the Hidden property of the cell to True and the Locked property to False, then protect the sheet.

megtoma
08-20-2014, 03:31 AM
Hello,
I tried it and when I try to change the text in the cell, it disappears.

Aflatoon
08-20-2014, 05:24 AM
True - you have to re-type it. There isn't a way around that that I know of.