Excel 2003

[Teresa]

I have protected an excel document, but not all of the cells. However, I run
into a problem when I try and add additional text to a field...I lose the
original text...HELP me please

 

[Wade]

A couple of things...
1. Are you sure the original text is gone or is it just not viewable due to
the cell not being big enough.
a. Try resizing the cell - both vertical and horizontal
b. Try turning on word wrap in the cell (Format/Cells/Alignment Tab) -
or even Shrink to Fit
2. If when you add text to the cell, is the entire cell activated
(typically blue) just before you start entering text? If so, as soon as you
type your first character, everything that was originally in that cell is
overwritten. A way to prevent this is to click on the cell, if the entire
cell is blue, click inside the cell again and you should just see your
cursor blinking inside the cell and the cell is no longer blue. Now you can
use your arrow keys to move around in the cell to the point where you want
to add your text. (Tip: if you want to add a carridge return (or multiple
lines) inside a cell, use "Alt" "Enter" key combination)

 

[Teresa]

It is not the size of the cell, the word wrap, or Shrink to fit. I have
looked at all of those and that isn't it. The actual issue is that once you
have made a large field, consisting of several cells for a 'notes' section in
a form, and you enter text into it, you can not go back and add additional
text to the field. Is this a flaw in a protected sheet? or is there something
I am not doing right. Please help this frustrated woman!!