How to Title a Column in Excel (5 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

Looking for ways to know how to title a column in Excel? Then, this is the right place for you. Here, you will find 5 different step-by-step explained ways to title a column in Excel.

Here, we have a dataset containing the data of Sales Person, Product, and Sales of a store. Now, we will use this dataset to show you how to title a column in Excel.

Ways to Title a Column in Excel


1. Title a Column Through Cell in Excel

Here, we have Blank Cells in Cell range B4:D4. In the first method, we will show you how to title a column through a Cell in Excel. Follow the steps given below to do it on your own dataset.

Title a Column Through Cell in Excel


Step-01: Title a Column

Here, you will find step-by-step ways how to title a column through a Cell.

  • First, select Cell B4.
  • Next, double-click on the cell.

  • Then, type your desired title for your column. Here, we will type Sales Person as column title.

Title a Column Through Cell in Excel

  • After that, press ENTER.

  • Similarly, add column titles for the rest of the columns. Here, we will set Product as title in Cell C4 and Sales as the title in Cell D4.

Title a Column Through Cell in Excel


Step-02: Formatting Column Title

Now, we will show you how to Format your title column in Excel. Go through the steps given below to do it on your own.

  • In the beginning, select Cell range B4:D4.
  • Then, click on the Increase Font Size button.

Title a Column Through Cell in Excel

  • After that, click on Bold button to bold the texts.

  • Next, click on the Fill Color button to change the color of the Cells.

Title a Column Through Cell in Excel

  • Afterward, select any color of your choice. Here, we will select Blue, Accent 1, Darker 50%.

  • Then, click on the Font Color button to change the font of the Cells.

Title a Column Through Cell in Excel

  • Now, select any color of your choice. Here, we will select White, Background 1.

  • After that, select the Center for text Alignment.

Title a Column Through Cell in Excel

  • Finally, you will get your column title for your dataset through Cell in Excel.

Read More: How to Create Column Headers in Excel


2. Using Formula Bar to Title a Column in Excel

We can also use Formula Bar to title a column in Excel. Now, we will add or change column headings in Cell range B4:D4 Follow the steps given below to do it on your own.

Using Formula Bar to Title a Column

Steps:

  • First, select Cell B4.
  • Then, go to the Formula Bar.

  • After that, type your desired title for your column. Here, we will type Sales Person as column title.

  • Next, press ENTER.

Using Formula Bar to Title a Column

  • Similarly, add column titles for the rest of the columns. Here, we will set Product as title in Cell C4 and Sales as title in Cell D4.

  • Then, format the dataset by going through the same steps in Method 1.
  • Finally, you will get your column title for your dataset using Formula Bar in Excel.

Using Formula Bar to Title a Column

Read More: Remove Column Headers in Excel


3. Title a Column with Excel Name Box

Now, we will show you how to change/rename a column title via Name Box in Excel.

By using the COUNTIF function, we will count particular Sales.

  • Type the following formula in cell C13.
=COUNTIF(D:D,D5)
  • Next, press ENTER to get the result.

Here, in the dataset, we have counted the number of Sales values as $540 in Cell C13.

Follow the steps given below to do it on your own.

Steps:

  • In the beginning, select the Entire Column D.
  • Now, you can see D1 in the Name Box.

  • Then, type Sales as the column name.

Title a Column via Name Box in Excel

  • After that, press ENTER to change the column name.

  • Finally, you will get a renamed column name via Name Box in Excel.

Title a Column via Name Box in Excel


4. Using Power Query Editor to Title a Column in Excel

In the fourth method, we will show you how you can use Power Query Editor to title a column in Excel. Using the Power Query Editor, you can get data from text/CSV, web, or table and then edit the data according to your preference.

Go through the steps given below to title a column in your own dataset.

Steps:

  • First, go to the Data tab >> click on From Table/Range.

Use of Power Query Editor to Title a Column

  • Now, the Create Table box will open.
  • Then, insert Cell range B4:D11 in the box.
  • Next, press OK.

  • After that, the Power Query Editor box will appear.
  • Then, click on Use First Row as Headers to set the first row as the column title.

Use of Power Query Editor to Title a Column

  • Now, you can see that the column titles have been selected.

  • Next, click on Close & Load >> select Close & Load.

Use of Power Query Editor to Title a Column

  • Finally, you will get your column title for your dataset using Power Query Editor in Excel.


5. Using Table to Title a Column

Finally, you can also title column headers in Excel using Table. Follow the steps given below to do it on your own dataset.

Steps:

  • In the beginning, select Cell range B4:D11.
  • Then, go to the Home tab >> click on Format as Table >> select Light Blue, Table Style Light 2.

Using Table to Title a Column

  • Now, the Create Table box will open.
  • After that, insert Cell range B4:D11 in the box.
  • Next, turn on My table has headers option.
  • Then, click on OK.

  • Finally, you will get your column title for your dataset using Table in Excel.

Using Table to Title a Column

Read More: How to Create Excel Table with Row and Column Headers 


Showing Row Numbers and Column Headers

Sometimes, the row and column headers might be hidden in your Excel workbook.

You can add the row and column headers by going through the following steps.

Showing Row and Column Headers

Steps:

  • First, go to the File tab.

  • Then, click on Options.

Showing Row and Column Headers

  • Now, the Excel Options box will appear.
  • After that, go to the Advanced tab.
  • Next, turn on the Show row and column headers option.
  • Then, click on OK.

  • Finally, you can see that the row and column headers have been added.

Showing Row and Column Headers


Download Practice Workbook


Conclusion

So, in this article, you will find 5 ways to title a column in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. Thank you!


Related Articles


<< Go Back to Rows and Columns Headings | Rows and Columns in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Arin Islam
Arin Islam

Anowara Islam Arin, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Arin exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Besides, she is also interested in Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo