Data series conversion

B

barney633

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
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Copying Portions of Data 0
Merging data from several Excel 2010 spreadhseets 5
newbie - how to paste into an occupied cell 5
add mergefields to exsting word 2013 2
Sharing Excel 365 Mac<->PC 0
How to copy every Nth column to a new sheet 0

Top