Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i multiply two columns | Excel Worksheet Functions | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula for a column | Excel Discussion (Misc queries) |