Excel - Switch to R1C1 reference style

December 2016


If you want Excel to refers to cells (columns and rows) using numbers instead of using
  • Letters for columns
  • Numbers for Rows
  • Click on File > Options > Formulas
  • In the "Working with formulas" section, check "R1C1 reference style"
  • Click on OK to validate your changes


Related :

This document entitled « Excel - Switch to R1C1 reference style » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.