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.
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.
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.
- 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.
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.
- After that, click on Bold button to bold the texts.
- Next, click on the Fill Color button to change the color of the Cells.
- 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.
- Now, select any color of your choice. Here, we will select White, Background 1.
- After that, select the Center for text Alignment.
- 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.
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.
- 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.
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.
- After that, press ENTER to change the column name.
- Finally, you will get a renamed column name 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.
- 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.
- Now, you can see that the column titles have been selected.
- Next, click on Close & Load >> select Close & Load.
- 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.
- 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.
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.
Steps:
- First, go to the File tab.
- Then, click on Options.
- 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.
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
- How to Change Excel Column Name from Number to Alphabet
- How to Repeat Column Headings on Each Page in Excel
- How to Remove Column1 and Column2 in Excel
- How to Change Column Header Name in Excel VBA
- [Fixed] Excel Column Numbers Instead of Letters
<< Go Back to Rows and Columns Headings | Rows and Columns in Excel | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!