| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data series conversion
I need to multiply a complete column of data. I don't need to keep to
original data only the results. I've been using a new column and then cutting and pasting the data back to it's original position. Is there a method of doing this that will just overwrite the original data without the need for all the cutting and pasting? Many Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Data series conversion
Hi,
Put the multiplier in a call and copy it. Select the colmn to multiply and then Edit|Paste Special Select Multiply and click OK Delete the multiplier. Mike "barney633" wrote: I need to multiply a complete column of data. I don't need to keep to original data only the results. I've been using a new column and then cutting and pasting the data back to it's original position. Is there a method of doing this that will just overwrite the original data without the need for all the cutting and pasting? Many Thanks |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Data series conversion
Many thanks, easy when you know how!
Thanks again. "Mike H" wrote: Hi, Put the multiplier in a call and copy it. Select the colmn to multiply and then Edit|Paste Special Select Multiply and click OK Delete the multiplier. Mike "barney633" wrote: I need to multiply a complete column of data. I don't need to keep to original data only the results. I've been using a new column and then cutting and pasting the data back to it's original position. Is there a method of doing this that will just overwrite the original data without the need for all the cutting and pasting? Many Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| chart with two data series and two colors for each data series | Charts and Charting in Excel | |||
| 2nd Axes - primary series data of only 1 series disappears! | Charts and Charting in Excel | |||
| how do I plot a data series against two series | Charts and Charting in Excel | |||
| Displaying single and multiple data series.Single data series | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
Hybrid Mode
