locking text in a cell, but allowing new text to be added

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sorry for such a newbie question. I have created a form and in some cells, I
have text that I want to lock, but allowing others to add to the text in the
cell. For example, if I put "Resolution Suggestions: " I would like that
to be locked, but enable others to add their suggestions. Is there a way to
do this, without having that particular text being in a separate cell? Thank
you
 
One way, not necessarily a good way, but it will work:

Enter a space into the cell, then use format, custom, and use the format string

;;;"Resolution Suggestions: "@

Which will show as

Resolution Suggestions:

(But you must have a space or else the cell will be blank)

Then when they type over the cell, it will show

Resolution Suggestion: What they typed here.

HTH,
Bernie
MS Excel MVP
 
Back
Top