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

(35% Sale Ends Jan. 26)

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 (35% Discount)

Tutorial Details
Excel VBA Course

(35% Sale Ends Jan. 26)

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 (35% Discount)