Forum Discussion

Jack Gaines's avatar
Jack Gaines
Copper Contributor
May 11, 2018

Excel

All of sudden my column are numbers and not letters. So it is column 1,2,3,etc. instead of A,B,C,etc. Can anyone tell me what happened and how to change it back to letters? Thanks
office 365
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
May 11, 2018

You are seeing R1C1 references.  In order to turn them off do this:

 

 

  1. Click the File tab to access Backstage view.
  2. Click Options.
  3. The Excel Options dialog box will appear. Click Formulas on the left side of the dialog box.
  4. Uncheck the box next to R1C1 reference style, then click OK. Excel will now use the A1 reference style.
Jack Gaines's avatar
Jack Gaines
Copper Contributor
May 13, 2018

Thanks! That fixed it. I must have inadvertently hit a keyboard shortcut that caused the problem. Is there a keyboard shortcut for this?

Resources