Swapping column labels between letters and numbers

This evening I thought I'd post a quick tip related to the column labels.

Some people prefer to work in excel with the columns numbered, instead of lettered. It is fairly simple to change this setting.

Go to Tools -> Options. Click on the tab "Formulas", and check the box that says "R1C1 Style".

Some things to know.
Your formulas will no longer use the letters either. A1 becomes R1C1. Also, if you are using cell references in a formula, you will not see "absolute" references by default. Instead, cells will be referred to by their relative position to the first cell..

So if in B1, I had the formula =A1, in R1C1 mode
R1C2's formula would be RC[-1]

The R with no number means the same row, and the C[-1] means one row to the right.

Enjoy