AutoFill
i have a formula in cell A2 =Trim(C2)
and i want to propagate it to the rest of column A For Example: A3 =Trim(C3) A4 =Trim(C4) ....etc the problem is when i am drag cell A2 down ,using the handle, i am getting the copy of the value from cell A2 and when i click on cell A3 it shows formula =Trim(C3) but it has the value of A2 cell. Please advice...thank you please advice...thank you |
AutoFill
Toolsoptionscalculation set to automatic
Regards, Peo Sjoblom "Student" wrote: i have a formula in cell A2 =Trim(C2) and i want to propagate it to the rest of column A For Example: A3 =Trim(C3) A4 =Trim(C4) ...etc the problem is when i am drag cell A2 down ,using the handle, i am getting the copy of the value from cell A2 and when i click on cell A3 it shows formula =Trim(C3) but it has the value of A2 cell. Please advice...thank you please advice...thank you |
AutoFill
thank you very much this was very useful
"Peo Sjoblom" wrote: Toolsoptionscalculation set to automatic Regards, Peo Sjoblom "Student" wrote: i have a formula in cell A2 =Trim(C2) and i want to propagate it to the rest of column A For Example: A3 =Trim(C3) A4 =Trim(C4) ...etc the problem is when i am drag cell A2 down ,using the handle, i am getting the copy of the value from cell A2 and when i click on cell A3 it shows formula =Trim(C3) but it has the value of A2 cell. Please advice...thank you please advice...thank you |
All times are GMT +1. The time now is 03:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com