Excel - Change the columns index from letter to number

September 2017

When you open a spreadsheet by defautl the columns are indexed by letters:

But if you want to change the format and put the index in numbers, here's how:
  • 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


Published by aakai1056. Latest update on March 6, 2012 at 08:22 AM by aakai1056.
This document, titled "Excel - Change the columns index from letter to number," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).