deleting a column that is used in a formula
 

hey
i have a column (A) and a constant, for example 10. i add this constant
10 to each row of the column A and get a new column (B). how can i
delete the old column A (to which i added 10) but still have the
results saved in column B? since column B has the formula =A1+10 when
i delete column A i am left with 10 for column B because it is now
adding 0+10 for each row. thanks
kc


--
krcc
------------------------------------------------------------------------
krcc's Profile: http://www.excelforum.com/member.php...o&userid=36016
View this thread: http://www.excelforum.com/showthread...hreadid=558058

deleting a column that is used in a formula
 

Select column B
EditCopy
EditPaste special check Values

HTH
--
AP

"krcc" a écrit dans le
message de news: ...

hey
i have a column (A) and a constant, for example 10. i add this constant
10 to each row of the column A and get a new column (B). how can i
delete the old column A (to which i added 10) but still have the
results saved in column B? since column B has the formula =A1+10 when
i delete column A i am left with 10 for column B because it is now
adding 0+10 for each row. thanks
kc


--
krcc
------------------------------------------------------------------------
krcc's Profile:
http://www.excelforum.com/member.php...o&userid=36016
View this thread: http://www.excelforum.com/showthread...hreadid=558058

deleting a column that is used in a formula
 

copy column b,paste back into col b/pasre special/paste values
--
paul

remove nospam for email addy!



"krcc" wrote:


hey
i have a column (A) and a constant, for example 10. i add this constant
10 to each row of the column A and get a new column (B). how can i
delete the old column A (to which i added 10) but still have the
results saved in column B? since column B has the formula =A1+10 when
i delete column A i am left with 10 for column B because it is now
adding 0+10 for each row. thanks
kc


--
krcc
------------------------------------------------------------------------
krcc's Profile: http://www.excelforum.com/member.php...o&userid=36016
View this thread: http://www.excelforum.com/showthread...hreadid=558058

deleting a column that is used in a formula
 

You have a couple of responses that suggest paste specialvalues, which is the
way to go in your case.

For future you may want to try this method of adding the 10 to each cell.

Enter 10 in an unused cell.

Copy that cell.

Select your range in Column A and Paste SpecialAddOKEsc.

Clear the cell with the 10.

No need for a column B.


Gord Dibben MS Excel MVP

On Tue, 4 Jul 2006 02:47:16 -0500, krcc
wrote:


hey
i have a column (A) and a constant, for example 10. i add this constant
10 to each row of the column A and get a new column (B). how can i
delete the old column A (to which i added 10) but still have the
results saved in column B? since column B has the formula =A1+10 when
i delete column A i am left with 10 for column B because it is now
adding 0+10 for each row. thanks
kc