Adding Columns, Then deleting old columns

M

May

I want to add 240 to each cell in Column A (Column A + 240). Then I want the
new data to be the new Column A.

Right now I did: added Column B. Formulated 'Sum of Column A + Column B =
Column C' So, I wanted to make Column C to replace Column A. And delete
Column B. But the data keeps pulling the formula.

Please help! Thank you!
 
T

T Tipsy

Select your new numbers in column C and then edit/copy/paste special/values
in column A. Then delete columns B and C.
 
J

John C

Instead, type 240 in a blank cell, copy it (CTRL+C)
Then select your data in column A (the entire range)
Paste Special (ALT+E, S, V) ... choose ADD under operation
and voila.
 

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

Having Blank Cells, etc. ? 1
summing data in multiple columns 4
counting blank cells within two columns 2
averaging data in multiple columns 6
SUM - IF - AND 7
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Subtotals - show all columns? 2
Multiple criteria question 1

Top