Afia Kona
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.
➤ 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.
➤ Finally, we will see that the Column Name appears as the title of the table, and the English Letters do not appear.
Read More: How to Name a Group of Cells in Excel (3 Methods +1 Bonus)
Similar Readings
- How to Paste Range Names in Excel (7 Ways)
- Remove Named Range in Excel (4 Quick Methods)
- How to Edit Named Range in Excel
- Delete Named Range Excel (3 Methods)
Method-2: Naming a Column in Excel With Number
In the following table, we want to Name the Column in Excel with Number.
➤ 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.
➤ Finally, we will see the Column Name as numbers.
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.
➤ 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.
➤ 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.
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.
