AutoFill w/formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three columns of data B1, C1, D1 which I concatenate into a fourth
column E1. Then I need to use the autofill function in the fourth column do
autofill the formula on all rows below the initial cells.

What is happening is that on each subsequent row, it is actually copying the
data in cell E1 down through each cell. However, when I click on one of the
cells and look in the formula bar, the formula is correct but the resulting
data is not.

Am I doing something here?
 
Maybe you have calculation set to manual under tools>options>calculation,
set it to automatic

--
Regards,

Peo Sjoblom

(No private emails please)
 
Back
Top