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
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.
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 Edit 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 Find a Named Range in Excel
- How to Change Scope of Named Range in Excel
- How to Paste Range Names in Excel
- How to Display Named Range Contents in Excel
- How to Delete All Named Ranges in Excel
- How to Navigate to a Named Range in Excel
- How to Delete Named Range Excel
<< Go Back to Named Range | Excel Formulas | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
