| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding Columns, Then deleting old columns
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Columns, Then deleting old columns
Select your new numbers in column C and then edit/copy/paste special/values
in column A. Then delete columns B and C. "May" wrote: 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Columns, Then deleting old columns
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. -- ** John C ** "May" wrote: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Columns, Then deleting old columns
THANK YOU! And fabulous response time! I'm extremely grateful! Have a great
day! "John C" wrote: 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. -- ** John C ** "May" wrote: 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding Columns, Then deleting old columns
THANK YOU T TIPSY!
"T Tipsy" wrote: Select your new numbers in column C and then edit/copy/paste special/values in column A. Then delete columns B and C. "May" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
| Deleting columns | New Users to Excel | |||
| deleting columns | Excel Discussion (Misc queries) | |||
| Disable Adding & Deleting Rows/Columns | Excel Discussion (Misc queries) | |||
| Disable Adding or Deleting Rows and Columns | Excel Discussion (Misc queries) | |||
Linear Mode
