AutoFill w/formulas

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?
 
P

Peo Sjoblom

Maybe you have calculation set to manual under tools>options>calculation,
set it to automatic

--
Regards,

Peo Sjoblom

(No private emails please)
 

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

relative offset to a named cell 3
split range address into individual cell addresses 4
autofill results appear as "$ -" with no error, why? 2
Autofill Formula 6
Autofill only copying initial value, not filling formula 2
Baffeling IF statement 7
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
autofill down won't work!!!! 3

Top