Excel won't fill formulas

G

Guest

Hi,
When I create a formula in a cell, then use the fill handle to copy the
formula down a column, the formula uses the data from the original cells
referenced instead of the cells in the rows down from the original cell. And
the weird thing is, when I click on one of the filled cells, the formula
shows up correctly. Example, in Cell I2 I created CONCATENATE G2,H2 and
pulled down to fill down to row 52. Row 52 shows CONCATENATE G52,H52, but
the data is from cells G2 and H2. Strange.
 
G

Guest

well, that did the trick. I wonder how that got switched? Never happened to
me before.
Thanks very much!
Jeff
 

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

Help getting 2 formulas into one 2
Nested ifs within a row 0
Excel 2007: Insert Row into Defined Area & Inherit Above Formulas 4
Easier way to concatenate a row? 8
Help Writing a SUM Formula 5
Excel A CountIF question... I think 2
Copying formulas - problem with the sum 1
Percentage Formula 2

Top