I’ve discovered that the formula auto fill function does not work when my workbook is using the R1C1 reference style, with numbers instead of letters in the columns.  It just copies the exact same formula into the next cell without updating the formula to apply to the next row/cell.  This simply copies the exact same value into all the the cells.  Switching back to labelling my columns with letters resolves the issue.

I don’t like using numbered columns, and generally keep all my workbooks in this format, but curious why this would be happening.

I have confirmed that Calculation in Formulas is set to Automatic.

​I’ve discovered that the formula auto fill function does not work when my workbook is using the R1C1 reference style, with numbers instead of letters in the columns.  It just copies the exact same formula into the next cell without updating the formula to apply to the next row/cell.  This simply copies the exact same value into all the the cells.  Switching back to labelling my columns with letters resolves the issue. I don’t like using numbered columns, and generally keep all my workbooks in this format, but curious why this would be happening. I have confirmed that Calculation in Formulas is set to Automatic.  Read More

​