Cell Editing (Fomatting)
 

Please help!

I would like to be able to have have a cell formated with held text see
examples of cell A and B. I would like this text to allways be here even
when I delete.

A B
PLEASE ENTER QUANTITY HERE TOTAL USD

I would also like the following to show when I would enter the following in
to the above cells

A B
3 EACH 300 USD

Can this be done?

Cell Editing (Fomatting)
 

Sean,
Try this, select all the cells on the sheet by pressing the button to the
left of the 'A' column heading and above the '1' row heading. Go to
Format|Cells|Protection Tab and un-tick the Locked box. then select the two
cells you want to lock and repeated the above process but re-tick the locked
tab. Then go to Tools|Protection|Protect Sheet and press OK. Now you will not
be able to alter the two cells you have protected.

To make 300 USB appear in a cell when you enter 3 each in other use this
formula in the cell where you want the 300 USB to appera;

=IF(A2="3 EACH","300 USB",""), where A2 is the cell that you will enter 3
EACH.

"Sean DeBruler" wrote:

Please help!

I would like to be able to have have a cell formated with held text see
examples of cell A and B. I would like this text to allways be here even
when I delete.

A B
PLEASE ENTER QUANTITY HERE TOTAL USD

I would also like the following to show when I would enter the following in
to the above cells

A B
3 EACH 300 USD

Can this be done?