Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Saving a sum
I want to find the sum of a series of cell values, then delete those values
and just keep the sum. Is there a way to keep that sum then change the value of the cells included in the sum? |
#2
|
|||
|
|||
Hi Fishy,
With the sum cell selected: Edit Copy | Edit Paste Special | Values | OK. This will freeze the snapshot sum value and you can then change/delete the series cell values without altering the original sum.. --- Regards, Norman "fishy" wrote in message ... I want to find the sum of a series of cell values, then delete those values and just keep the sum. Is there a way to keep that sum then change the value of the cells included in the sum? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop Excel 2000 from saving file history from file that . | Excel Discussion (Misc queries) | |||
Saving shared Excel files | New Users to Excel | |||
how do I stop warnings when saving .xls as csv? | Excel Discussion (Misc queries) | |||
Opening and saving Excel 2003 file from Excel 97. | Excel Discussion (Misc queries) | |||
Error Message appearing when saving a file | Excel Discussion (Misc queries) |