Excel - Switch to R1C1 reference style

June 2017


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


Published by jad05. Latest update on July 4, 2012 at 10:43 AM by jad05.
This document, titled "Excel - Switch to R1C1 reference style," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).