The default column name in Excel, denoted by the alphabet, does not represent the actual data that the column contains. So we need to change the column name and rename the column in Excel according to our needs. In this article, we will talk about how to rename columns in Excel.
Download Practice Workbook
3 Easy Ways to Rename Column in Excel
In this discussion, we will learn 3 ways to rename columns in Excel. Firstly, we will use Excel Advanced option to rename the column. Then, we will use the Formulas option to rename the column. Finally, we will use the display bar to accomplish the task. We will use the following sample dataset to illustrate the methods.
1. Using Advanced Option
In this method, we will hide the default column and row names and set our dataset heading as the column name. In the process, we will use the Advanced option in Excel.
Steps:
- Firstly, go to the File tab.
- From there, select Options.
- Consequently, the Excel Options window will pop up.
- Then, select the Advanced option in the window.
- Then, hoover down to the Display options for this worksheet option.
- After that, uncheck the box beside the option Show row and column headers.
- Finally, click OK.
- Consequently, you will find that the dataset header is also the column name.
Read More: How to Name a Column in Excel (3 Easy and Effective Ways)
2. Utilizing Formulas Option
In this method, we will rename a column in excel with numeric values. We will use the Formulas option to do that.
Steps:
- Initially, select the File tab.
- After that, choose Options.
- Thus, the Excel Options window will appear.
- Then, choose Formulas.
- Following that, lower the cursor down to Working with formulas.
- You will find that the R1C1 reference style box is unchecked.
- Then, check the box.
- Finally, click OK.
- Consequently, you will find the columns renamed in numeric format.
Similar Readings
- How to Edit Name Box in Excel (Edit, Change Range and Delete)
- How to Change Excel Column Name from Number to Alphabet (2 Ways)
- Excel VBA to Create Named Range from Selection (5 Examples)
- How to Set Value to a Named Range with Excel VBA (3 Methods)
- How to Delete All Named Ranges in Excel (2 Ways)
3. Using Display Bar
In this final method, we will resort to the display bar to rename the columns. Follow the ensuing steps to do that.
Steps:
- If we click on the B column, the display bar will display B1.
- But this is ambiguous. Because we can know little about the data the column contains from that name.
- So, we will erase the name B1.
- Then, we will rename it as Employee.
- After that, we will hit Enter.
- Consequently, we will find that Excel has renamed the column from B1 to Employee.
Rename Column in Power Query
In this additional method, we will rename a column using excel Power Query. In the process, we will use the Power Query Editor.
Steps:
- Firstly, select any data from the dataset.
- Then, go to the Data tab in the ribbon.
- After that, select From Table/Range.
- Consequently, a prompt will appear on the screen.
- Then, in the prompt, select the dataset range as the table range.
- Finally, click OK.
- As a result, the Power Query Editor will be opened.
- In the Power Query Editor, first, go to the Transform tab.
- Then, select the Rename command.
- This will take us to the column header.
- Rename the column from “Employee” to “Employee Name.”
- Then, hit Enter.
- Consequently, the column will be renamed.
- Repeat the same process for the rest of the columns.
Conclusion
In this article, we have talked about how to rename a column in Excel. These methods will allow users to rename the columns according to their needs and manage the data more efficiently.
Related Articles
- How to Delete Named Range Excel (3 Methods)
- How to Remove Named Range in Excel (4 Quick Methods)
- Dynamic Named in Range Excel (Both One and Two Dimensional)
- How to Edit Named Range in Excel
- How to Edit Defined Names in Excel (Step-by-Step Guideline)
- [Fixed!] Name Manager Delete Option Greyed out in Excel (3 Reasons)