# How to Change Column Headings in Excel (2 Ways)

Here’s a sample dataset containing PC parts, prices, and available quantities. We’ll change the column headings in the file from letters to numbers.

## Method 1 – Using the R1C1 Reference Style to Change Column Headings in Excel

Steps:

• Calculate the total prices in the data set.

• Apply the following formula to determine the total price per product.
=C5*D5
• In the formula, the cell references contain column letters in them, which are C5 and D5.

• Press Enter and AutoFill the formula into the cells below.

• Go to the File tab of the ribbon.

• Select Options.

• You’ll get the Excel Options dialog box.
• Go to the Formula tab of the box and check the option R1C1 reference style.
• Select OK.

• Go back to your worksheet.
• The column labels in the worksheet will turn into numeric values.

## Method 2 – Applying Excel VBA to Change Column Headings

Steps:

• Calculate the total price again by using the following formula.
=C5*D5
• The column labels are in alphabetical order.

• Go to the Developer tab of the ribbon.
• Choose the Visual Basic command from the CodeÂ group.

• The VBA window will appear.
• Select ModuleÂ from the Insert tab.

• Copy the following code into the module of the VBAÂ window.
'Set the name of the function
'Altering Reference Style from Letter to Number
Application.ReferenceStyle = xlR1C1
End Sub

• Save the code and press the play button or F5 to run the code.

• After running the code, the reference style of column headings will turn into the R1C1 reference style.
• This reference style will transform the column headings from letters to numbers.

## Related Articles

<< Go Back to Rows and Columns Headings | Rows and Columns in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Araf Bin Jayed

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF