Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking A Formula In A Cell
Is there a way to lock a formula in a cell but still be able to delete the
result without deleting the formula? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking A Formula In A Cell
To delete the result of a formula, simply delete the data in the cells the
formula references. =A1 + B1 returns 34 Clear the contents of A1 and B1 To do this en masse, F5SpecialConstants. Uncheck what you want to keep and OK. EditClear Contents. Gord Dibben Excel MVP On Mon, 19 Dec 2005 11:45:03 -0800, "Altstatten" wrote: Is there a way to lock a formula in a cell but still be able to delete the result without deleting the formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions |