Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clearing formulations
How do i remove a formulation from a cell leaving the result?
I did copy, paste, then value but i need to copy down a column to do the same thing to all the cells. When i dragged down the column it just copied the first symbol instead of doing each individually. How can i get it to change each cell individually? -- Susan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clearing formulations
Copy the column, *then* Edit/ Paste Special/ Values.
-- David Biddulph "Sue" wrote in message ... How do i remove a formulation from a cell leaving the result? I did copy, paste, then value but i need to copy down a column to do the same thing to all the cells. When i dragged down the column it just copied the first symbol instead of doing each individually. How can i get it to change each cell individually? -- Susan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clearing formulations
Highlight all the cells in the column and then do copy - paste special - values
"Sue" wrote: How do i remove a formulation from a cell leaving the result? I did copy, paste, then value but i need to copy down a column to do the same thing to all the cells. When i dragged down the column it just copied the first symbol instead of doing each individually. How can i get it to change each cell individually? -- Susan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
clearing a cell | Excel Discussion (Misc queries) | |||
Clearing #N/A's in one go? | Excel Worksheet Functions | |||
Formulations? | Excel Discussion (Misc queries) | |||
Clearing #VALUE | Excel Worksheet Functions | |||
Clearing Links | Excel Discussion (Misc queries) |