Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change a calculated cell to = the calculated value
I want to save a spreadsheet so that the values in the calculated cells are
changed to equal the calculated values so that the hidden data/formulas used to calculate the values can then be removed. Any suggestions? Seemed like there was such a technique in Lotus 123 days but I've slept way too many times since then! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change a calculated cell to = the calculated value
Hi CAM. If you just want the values and not the formulas select all the
calculated cells, copy and then paste special - values before you save. HTH -- Sincerely, Michael Colvin "CAM" wrote: I want to save a spreadsheet so that the values in the calculated cells are changed to equal the calculated values so that the hidden data/formulas used to calculate the values can then be removed. Any suggestions? Seemed like there was such a technique in Lotus 123 days but I've slept way too many times since then! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change a calculated cell to = the calculated value
CAM wrote:
I want to save a spreadsheet so that the values in the calculated cells are changed to equal the calculated values so that the hidden data/formulas used to calculate the values can then be removed. Any suggestions? Seemed like there was such a technique in Lotus 123 days but I've slept way too many times since then! ------------------------------- If I understand you correctly, what you need to do is simply mark the cells you want to change, copy them and then use PasteSpecialValuesOnly to paste the same data back into the same cells. At that point the cells will contain numbers rather than formulas. Bill |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change a calculated cell to = the calculated value
Awesome guys. That trick coupled with the Remove Hidden Data tool make it
really easy to cleanup and distribute worksheets. Thanks again Michael & Bill "Bill Martin" wrote: CAM wrote: I want to save a spreadsheet so that the values in the calculated cells are changed to equal the calculated values so that the hidden data/formulas used to calculate the values can then be removed. Any suggestions? Seemed like there was such a technique in Lotus 123 days but I've slept way too many times since then! ------------------------------- If I understand you correctly, what you need to do is simply mark the cells you want to change, copy them and then use PasteSpecialValuesOnly to paste the same data back into the same cells. At that point the cells will contain numbers rather than formulas. Bill |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change a calculated cell to = the calculated value
Your welcome, CAM. Thanks for the feedback.
-- Sincerely, Michael Colvin "CAM" wrote: Awesome guys. That trick coupled with the Remove Hidden Data tool make it really easy to cleanup and distribute worksheets. Thanks again Michael & Bill "Bill Martin" wrote: CAM wrote: I want to save a spreadsheet so that the values in the calculated cells are changed to equal the calculated values so that the hidden data/formulas used to calculate the values can then be removed. Any suggestions? Seemed like there was such a technique in Lotus 123 days but I've slept way too many times since then! ------------------------------- If I understand you correctly, what you need to do is simply mark the cells you want to change, copy them and then use PasteSpecialValuesOnly to paste the same data back into the same cells. At that point the cells will contain numbers rather than formulas. Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change event on specific cell rather than worksheet | Excel Discussion (Misc queries) | |||
How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Change cell color dependin on date ... | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions |