Forum Discussion
Fill Formula function not working when using R1C1 reference style for columns
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 fo...
this is probably because R1C1 reference is the absolute version and R[1]C[1] is the relative notation and even then the formula won't change since that relative aspect is built in so R[1]C[-1] means the row below and column to the left of that cell and it doesn't need to change as you copy down.
- Wow...so translation is "be glad you can just keep using letters" 🙂
- actually RC format may feel weird but can be very useful. It is just a matter of getting used to it.
another useful format is structured references for referring to tables (e.g. TABLE1[NAME]). It is also a little different and takes some getting used to but also very useful.- I struggle to see how the R1C1 reference is useful for the average user. It is more complicated, involves typing in longer formulas and renders the formula fill-in non-functional. In what circumstances would the R1C1 reference be preferred or useful? Genuinely curious.
