• + Install App
  • हिन्दी
  • Search
  • Close
    Looking For Something?
  • Kumari Rajnigandha
  • Editorial, 27 Jan 2022, 18:58 IST

How To Change Column Names In An Excel Sheet

Here's an easy guide on how to change column names in MS Excel.
  • Kumari Rajnigandha
  • Editorial, 27 Jan 2022, 18:58 IST
Excel column

MS Excel is a spreadsheet application which helps you to store data in an organized form. Using MS Excel you can arrange your data in rows and columns. If you are new to using MS Excel, you might find it challenging to use the application to its full potential. 

When you are able to use Excel smoothly, you’ll find that it’s easier to store data in Excel than in any other way. In fact, you can make various calculations with the help of excel. In fact, the application is equipped with data analysing tools so as to make it easier to comprehend a large set of data. 

What Is A Column In MS Excel?

MS Excel

The format of MS Excel is based on grid structure. In an MS Excel worksheet, the grid which runs vertically are known as the columns whereas the grid which runs horizontally are known as the rows. In MS Excel vertical columns are named in alphabetical order such as A, B, C, D and so on. Excel files contain a maximum of 16,384 columns. 

Naming A Column In Excel Sheet

Custom naming the columns becomes imperative in MS Excel so as to organize any form of date. In fact, naming the columns makes it easier to make formulas that are easier to understand. Ideally, one should choose a column name that does not include special characters like brackets and double quotes etc. Moreover, it also helps you to perform audits and updates in a seamless manner.

Don't Miss: 4-Day Work-Week Part Of New Labour Codes To Be Implemented Soon; Know All About The New Labour Codes

Changing The Default Column Names

MS Excel column

First and foremost, open your Excel file. Start out by removing the actual header’s name and then change the name of the first row of the column that you wish to change. Then, click on the first row of the Microsoft sheet and then insert a new row. After having created the column title row and labelling your columns you can choose to not show the default header names. Subsequently, click on ‘File’ and then the ‘Options’ button. After having chosen the Options button, click on the ‘Advanced’ button on the left hand side. Don’t forget to uncheck the box for ‘Show Row and Column Headers’ In order to make the default column header appear again you can check mark the box once again.

Don't Miss: 4 Easiest Tips To Reduce PDF File Size

Changing Column From Names To Numbers

change column names

You can change the column header from names to numbers. All you have to do is open click on ‘Excel’ and then choose ‘Preferences’. After that, click on ‘File’, and then click on ‘Options’. Click on ‘General’ or ‘Formulas’ icon on the window that comes up. Click beside the ‘R1C1’ Reference Style and then click on ‘OK’, Doing this procedure helps you to change all the headers from letters to numbers as per your convenience. If you liked reading the article, you might also want to know the 5 simple steps for staying safe online.

If you wish to ask anything about basic MS Excel skills, do let us know by commenting on our Facebook and Instagram page. 

Stay tuned to HerZindagi to read more such stories!


Your skin and body like you are unique. While we have taken all measures to ensure that the information provided in this article and on our social media channels is credible and expert verified, we recommend you consult a doctor or your dermatologist before trying a home remedy, quick hack or exercise regime. For any feedback or complaint, reach out to us at compliant_gro@jagrannewmedia.com