Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
mass cell data editing | Excel Worksheet Functions | |||
in cell editing macro | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |