How to Rename Column in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.

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.

how to rename column in excel


1. Using Advanced Option to Rename Column in Excel

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.

selecting file tab to rename column in excel

  • 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.

unchecking show row and column headers option to rename column in excel

  • Consequently, you will find that the dataset header is also the column name.

using advanced option to rename column in excel

Read More: How to Create Column Headers in Excel


2. Applying Formulas Option to Rename Column

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.

selecting options to rename column in excel

  • 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.

checking r1c1 reference style box to rename column in excel

  • Consequently, you will find the columns renamed in numeric format.

utilizing formulas option to rename column in excel

Read More: How to Change Excel Column Name from Number to Alphabet


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.

selecting display bar to rename column in excel

  • So, we will erase the name B1.

erasing default name to rename column in excel

  • Then, we will rename it as Employee.
  • After that, we will hit Enter.

setting new name in the display bar to rename column in excel

  • Consequently, we will find that Excel has renamed the column from B1 to Employee.

using display bar to rename column in excel

Read More: How to Change Column Headings in Excel


How to Rename Column in Excel 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.

turning data range into table to rename column in excel

  • 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.

selecting rename command in power query editor to rename column in excel

  • This will take us to the column header.

  • Rename the column from “Employee” to “Employee Name.”
  • Then, hit Enter.

renaming column in excel

  • Consequently, the column will be renamed.
  • Repeat the same process for the rest of the columns.


Download Practice Workbook


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

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel projects.
Adnan Masruf
Adnan Masruf

I am an engineering graduate. I graduated from Bangladesh University of Engineering and Technology(BUET), one of the top universities in Bangladesh from department of Naval Architecture & Marine Engineering with a major in structure. I am an avid reader of fiction especially fantasy. I also keep myself abreast of the recent developments in science and technology. I believe diligence will eventually pay off and luck tends to favor those who work hard.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo