This Excel tutorial explains how to use R1C1 reference style in Excel worksheet. Excel worksheet R1C1 reference style In R1C1, "R" refers to row, while "C" refers to column. Formula R1C1 allows you set formula for a cell, using relative row and column. For example, you want to set a formula in C2 to sum the two cells on the left, before that you should ask yourself a question: Do I want to sum the cell on left 1 and left 2 relative to C2, or Do I just want to sum A2 and B2, no matte...