| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protect Sheet: clicking in cells removes all previous text
I protected a sheet because I have formulas on the sheet. So, I locked those
cells and left the rest of the cells unlocked. When the sheet is protected, if I click in a cell and try to add text to the cell, it deletes all the previous text. Is there any way to stop that from happening? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protect Sheet: clicking in cells removes all previous text
Rather than just clicking in a cell and typing, click in the cell and hit the
F2 key to add text to the end of the data in that cell -- ~Christine, CPA "Kristin" wrote: I protected a sheet because I have formulas on the sheet. So, I locked those cells and left the rest of the cells unlocked. When the sheet is protected, if I click in a cell and try to add text to the cell, it deletes all the previous text. Is there any way to stop that from happening? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect excel sheet and still copy text or object w/o unprotectin. | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Linked cells and text boxes | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Linear Mode
