Make Column Headings Numbers instead of Letters - Make R1C1 Style References in Excel 2007

Add to Favorites
Author:

In Microsoft Excel you reference columns as letters by default - A1, B3, C5, etc. But you can also reference the columns by there number instead of letter. This is called a R1C1 style cell reference in Excel and it is undoubtedly more complicated. However, it does serve a purpose and is often needed for complex array formulas within macros in Excel.

Steps to change columns from letter to numbers - R1C1 style cell references in Excel 2007:

  1. Office Button
  2. Excel Options
  3. Formulas Tab
  4. Working with formulas section
  5. Check "R1C1 reference style."

 

Before:

A1 Style Cell References

 

After:

R1C1 Style Cell References

 

Excel Options Menu:

R1C1 Style Cell References


Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Tutorial Details
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course