| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting the text without deleting the formula
I have input formulas into 4 worksheets in 1 workbook. For example in
worksheet 1 I have it so D4 automatically populates into D100 and D175, not only in the 1st worksheet but also in the2nd, 3rd and 4th worksheets. The problem, maybe with my formula, is if someone where to delet the text in the 2nd worksheet in D100 it'll delete the formula. I need to make sure that if they delete the text the formula will not be deleted. Is there a way to make sure that doesn't happen? Or is my formula wrong? Maria |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Text | New Users to Excel | |||
| is it possible to enter in text over a formula without deleting the formula? | Excel Discussion (Misc queries) | |||
| Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
| deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
| how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
Threaded Mode
