EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

Excel COLUMN to Number

By Madhuri ThakurMadhuri Thakur

Home » Excel » Blog » Lookup & Reference Functions in Excel » Excel COLUMN to Number

Excel Column to Number

Excel COLUMN to Number (Table of Content)

  • Convert Column Heading to a Number
  • How to use the COLUMN function in Excel?
  • How to Change the Excel Reference Style?
  • What is the R1C1 Reference Style?

Excel COLUMN to Number

In Excel, column headings or labels are numbers instead of alphabets. This feature is called Excel reference style.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Convert Column Heading to a Number

Excel provides a built-in COLUMN function that falls under the Lookup/Reference function category. This function returns the column number for a given cell reference.

For Example: For finding the column number of Cell A10, we will use the formula like below:

=COLUMN (A10)

Which gives 1 as a result because column A is the first column.

Formula:

column formula

Where the passing argument reference is optional.

This function accepts only one argument, which is optional. It takes cell reference or a range of cells for which we want to find the column number. It returns the numeric value.

How to Use COLUMN Function in Excel?

Let’s take some examples to understand the usage of this function.

Popular Course in this category
Sale
Excel Training (21 Courses, 9+ Projects)21 Online Courses | 9 Hands-on Projects | 110+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.9 (10,662 ratings)
Course Price

View Course

Related Courses
Excel Advanced Training (16 Courses, 23+ Projects)
You can download this COLUMN to Number Excel Template here – COLUMN to Number Excel Template

Example #1

We have a list of some cell addresses and a range of cells.

column to number example 1.1

Now we will apply the COLUMN function here on the above cell address, and the Result is given below:

column to number example 1.2

Explanation:

As we can see above, in cell B7, we have passed a blank argument inside the COLUMN function; hence it returns the number 2 as the COLUMN function itself exists in Column B.

Example #2

We have given below a list of references.

column to number example 2.1

Now, after applying the COLUMN function, the final result is given below:

column to number example 2.2

In the same way, we can find out the list of all column labels in excel. Below is the list from Column A: Column Z for your reference:

column to number example 2.3

In an Excel spreadsheet named “Column A to Column ZZ”, we have provided you with the Column numbers from Column A to Column ZZ.

How to Change the Excel Reference Style?

Excel displays the column labels alphabetically, but we can change them with column numbers. This whole thing is called Excel R1C1 reference style.

For changing this reference style, please follow below steps:

  • Open a Microsoft Excel spreadsheet, then go to the FILE tab and click on the Options tab in the left pane window, as shown in the below screenshot.

changing excel reference option

  • It will open an Excel options dialog box and click on the Formulas tab in the left pane window, as shown in the below screenshot.

changing excel reference style 1

  • This will display some options in the right side window, as you can see in the above image. Tick on checkbox R1C1 reference style under the Working with formulas section. Refer to the below screenshot.

changing excel reference style 2

  • By clicking on this option, we enable the style of using numbers for both rows and columns. By default, Excel will display Column headings as Column alphabets. With this option, cells are referred to in this format: R1C1; click on OK.

As a result, Excel will convert the column labels into numbers. Refer to the below screenshot.

changing excel reference style 3

This R1C1 reference style option is disabled by default due to this Excel display column headings as alphabets.

What is the R1C1 Reference Style?

Excel, by default, uses the A1 reference style, which refers to Columns as letters. A is the column, and 1 in the row. Excel has a total of 256 columns and 65,536 rows.

i.e. 256 are the column headings, and 65,536 are the row numbers. For any cell address, we always start with a Column label followed by a Row number.

For Example, E65 refers to the cell where Column E and Row no. 65 intersect to each other.

We can convert the Column Labels into Column numbers by enabling the R1C1 reference style option under the FILE tab. This style is very useful when we are using rows and columns positions in macros.

In this R1C1 style, Excel refers to a cell position with “R” followed by a row a number and “C” followed by a column number.

Things to Remember About Excel Column to Number

  • Reference argument can be a single cell address or range of cells.
  • It is an optional argument, which means if we don’t pass any argument, it returns the column number of the cell where the column function exists.
  • This R1C1 reference style option is very useful when we are using row and column positions in macros.

Recommended Articles

This has been a guide to Excel Column to Number. Here we discussed How to use the COLUMN function in Excel with examples and a downloadable excel template. You may also look at these useful functions in excel –

  1. COLUMN Function in Excel
  2. Column Header in Excel
  3. Excel Sort By Number
  4. VBA Columns

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

2 Shares
Share
Tweet
Share
Primary Sidebar
Excel Functions
  • Lookup Reference Functions in Excel
    • VLOOKUP True
    • VLOOKUP Error
    • How to Match Data in Excel
    • Excel Match Function
    • Excel Lookup Function
    • ROWS Function in Excel
    • Excel INDEX Function
    • VLOOKUP Table Array
    • Excel OFFSET Formula
    • VLOOKUP For Text
    • IF VLOOKUP Formula in Excel
    • Mixed Reference in Excel
    • CHOOSE Formula in Excel
    • Excel COLUMN to Number
    • Excel Alternatives to VLOOKUP
    • HLOOKUP Examples
    • Excel VLOOKUP From Another Sheet
    • VLOOKUP with Sum
    • Fixing VLOOKUP Errors
    • Excel ROW Function
    • HYPERLINK in Excel
    • Address Excel Function
    • Excel COLUMNS Function
    • Excel REPLACE Function
    • OFFSET Excel Function
    • Excel GETPIVOTDATA Function
    • MATCH Function in Excel
    • VLOOKUP Function in Excel
    • HLOOKUP Function in Excel
    • LOOKUP in Excel
    • CHOOSE Function in Excel
    • TRANSPOSE in Excel
    • COLUMN Function in Excel
    • INDIRECT Function in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (23+)
  • Statistical Functions in Excel (58+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (21+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL COURSE
  • Online EXCEL ADVANCED Training
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

Download COLUMN to Number Excel Template

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Special Offer - Online EXCEL COURSE Learn More