How to Name a Column in Excel (3 Easy and Effective Ways)

If you are looking to Name a Column in Excel in an easy way, this article is for you. Here, we will demonstrate to you several ways to do the task.

There are 3 easy ways to Name a Column in Excel. Here, we will show you how each method works effectively.

1. Using Table Title to Name a Column in Excel

In the following table, we can see that the column is represented by the English letters A, B, C, and this goes on. Now, we want to change the Column Name in Excel, and instead of these English letters, we want to see the heading of the table as a Column.

Column Name in Letters

➤ To begin with, we have to select the File option, which is at the left top of our Excel sheet.

➤ After that, we have to select Options.

➤ Then, we have to click on the Advanced option.

➤ Then, we have to scroll down the mouse until we find Display options for this worksheet. There we will see a marked Show row and column headers box.

➤ Now, we have to unmark the Show row and column headers box and click OK.

Unmarked Show row and column header

➤ Finally, we will see that the Column Name appears as the title of the table, and the English Letters do not appear.

Column Name as the Title of a table

Read More: How to Name a Group of Cells in Excel

2. Naming a Column in Excel With Number

In the following table, we want to Name the Column in Excel with Number.

Column Name with Letters

➤ First of all, we have to go to the File option.

➤ After that, we have to select Options.

➤ Then, we have to select Formulas.

➤ After that, we will see an unmarked R1C1 reference style box.

➤ Now, we have to mark this R1C1 reference style and click OK.

Selected R1C1 reference style

➤ Finally, we will see the Column Name as numbers.

Column Name as Number

3. Renaming a Column Name in Excel

Sometimes, for various purposes, we need to rename the column in Excel. We will show you how to do so. In the following picture, we can see that when we select Column 3, it shows the Column Name as R1C3. We want to rename this R1C3.

selected column name R1C3

➤ First, we have to select column 3, and then, select the Column Name R1C3. 

➤ And after that, we have to delete the Column Name R1C3.

Deleted Column Name

➤ Then, we will type the Column Name according to our choices. Here, we typed Employee. After that press ENTER.

➤ Finally, we will see that when we select Column 3, we can see the name Employee.

Column 3 Name Change to Employee

Read More: How to Edit Named Range in Excel

Download Practice Workbook


Here, we tried to show you some easy ways that will help you to Name Columns in Excel. We hope you will find this article helpful. If you have any queries or suggestions, please feel free to know us in the comment section.

Related Articles

<< Go Back to Named Range | Excel Formulas | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF