Why doesn't autofill work in Excel?

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

Guest

I have the following formula in cell C1:
=concatenate(A1," ", B1)
This results in getting the person's first name (A1) next to the person's
last name (B1) in cell C1.
I get the correct answer, but when I autofill the formula down, it just
repeats the first answer (Mary Smith) over and over again. Any suggestions
would be appreciated.
 
I would suggest you turn on Automatic Calculation at Tools>Options>Calculation.


Gord Dibben MS Excel MVP
 
Back
Top