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.
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.
➤ 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
Similar Readings
- How to Paste Range Names in Excel
- How to Navigate to a Named Range in Excel
- How to Edit Named Range in Excel
- Delete Named Range Excel
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 Find a Named range in Excel
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.
➤ 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 Change Scope of Named Range in Excel
Download Practice Workbook
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
- How to Display Named Range Contents in Excel
- How to Create Dynamic Named Range in Excel
- Create Dynamic Named Range with VBA in Excel
- How to Use Dynamic Named Range in an Excel Chart
- How to Use Named Range in Excel VLOOKUP Function
- Excel INDIRECT Function with Named Range
- Excel Reference Named Range in Another Sheet
- How to Ignore Blank Cells in Named Range in Excel
- How to Set Value to a Named Range with Excel VBA
- Excel VBA to Create Named Range from Selection
- How to Delete All Named Ranges in Excel
- How to Use Named Range in Excel VBA
- Excel VBA to Loop Through Named Range
- How to Check If Named Range Exists with Excel VBA
- Excel VBA to Delete Named Range
- Define Names with the Create from Selection Tool in Excel
