When you open an Excel spreadsheet, by default the columns are indexed by letters. However if you'd like to change the format and have the index in numbers, follow the step-by-step guide below.
Change Excel Column Index From Letter to Number
Image: © 123RF.com
- Open your spreadsheet
- Click on the orb button
- Click on Excel Options and move to the Formula tab.
- Go to the "Working with formulas" section
- Check the "R1C1 reference style"
- Note that: Upon hovering your mouse cursor on it, you shall get all the information about this feature.
- Click on OK