In this quick one-minute tutorial, I show you how to switch between the R1C1 and A1 formats in Excel.
Sometimes you may get an Excel spreadsheet where the columns are labeled with numbers instead of letters, and the formula will look different as a result. Where columns are labeled with numbers, we call that the R1C1 reference style.
When columns are labeled with numbers, we call that the A1 reference style.
There’s no real difference in what you can do with either R1C1 or A1, but if you’re used to working with one format or the other, it’s good to know how to switch between them in case you get a spreadsheet set to the format you don’t normally work with.