Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
question about tricky autofill for series | Excel Discussion (Misc queries) | |||
autofill | Excel Discussion (Misc queries) | |||
More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions | |||
Autofill: Need to autofill one week block, (5) weekday only into cells. | Excel Discussion (Misc queries) | |||
Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) |