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
Thanks for this stuff Sir Abiola