Tag Archives: Settings

You might know that Excel has two different reference styles for formulas: A1 (default) R1C1 But why should you care? You might think the default A1 reference style is sufficient for you, but that would leave opportunities only the R1C1 reference style allows. Let’s first see the difference between both reference styles Reference Type A1 Style R1C1 Style Relative =A1 =R[ ± x ]C[ ± [...]