R1C1 Referencing Style: Switch Column Letters To Numbers Using ALT + FTF Shortcut

Welcome to Excel Jet Consult blog post. In this blog post, we will learn how to switch spreadsheet columns alphabet letters to numbers using R1C1 referencing. Let’s get started

Open an Excel workbook and execute the command: ALT + FTF

In the Excel Options dialogue box, check the R1C1 reference style

Click OK

In the caption above, we can see that the column is showing as numbers; not as letters. Also, in the name box, we can see the cell reference style which is R13C10. This means that, I am currently in Row 13 and Column 10

 

Posted in Blog.

One Comment

Leave a Reply to Olajide Ahmed Cancel reply

Your email address will not be published. Required fields are marked *