Excel won't fill formulas

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

I am trying to create a formula 1
Excel A CountIF question... I think 2
Filling a formula down-need correct cell reference 13
Copying formulas - problem with the sum 1
Nested ifs within a row 0
SUM formula (sort of) 1
Help Writing a SUM Formula 5
Percentage Formula 2

Back
Top