Excel - Change the columns index from letter to number

April 2018

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 (https://ccm.net/).
Excel - Change the default action assigned to the Enter key
Excel - Insert the path and file name in a cell