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.

Download Workbook

3 Easy and Effective Ways to Name a Column in Excel

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


Method-1: Name a Column in Excel with Table Title

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 (3 Methods +1 Bonus)


Similar Readings


Method-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

Read More: How to Name a Range in Excel (5 Easy Tricks)


Method-3: Rename 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 Defined Names in Excel (Step-by-Step Guideline)


Conclusion

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

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo