Why doesn't autofill work in Excel?

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.
 
G

Gord Dibben

I would suggest you turn on Automatic Calculation at Tools>Options>Calculation.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fonts and Cells 4
Autofill column values in formulas 4
Subtraction of 2 numbers/cells 3
Autofill equations 4
Autofill Problem 2
How to set the formula? 4
Running Balance in a row 1
Autofill issue... 2

Top