| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Dave
EditGo To(or F5)SpecialConstants. Tickmark what you want selected then OK your way out. EditDelete what is highlighted. Gord Dibben Excel MVP On Sat, 1 Jan 2005 20:15:03 -0800, "Dave" wrote: I can delete data, but it delets the formula. Is there any way to lock a formula, but can still clear data? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extend data range format and formulas | Excel Worksheet Functions | |||
| how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
| Formulas in source data | Charts and Charting in Excel | |||
| Help with large amounts of data and formulas | Excel Worksheet Functions | |||
Threaded Mode
