How to Apply Title Cell Style in Excel (4 Suitable Examples)

Whenever working with Excel formatting is often needed. One can do the formatting easily by using the Cell Style feature. The main focus of this article is to explain how to apply title cell Style in Excel.

What Is Cell Style?

A cell style in Excel is a predefined format that enables you to change the color, cell borders, alignment, and number types to visually represent data. Cell style can combine multiple formats. One of the major benefits of using Cell Style is that if the formatting associated with a cell style is changed, all the cells that have that cell style applied will be automatically updated.

Here, I have taken a dataset. It contains 2 Columns and 3 Rows. I have not done any kind of formatting here. I will use this dataset to add Dataset Title, Column Title, and Row Title.

1. Using Cell Style Feature to Apply Title in Excel

In this method, I will explain how to apply title cell style in Excel using the Cell Style feature.

1.1. Applying Cell Styles in Dataset Title

Here, I will explain how you can add dataset title. Let’s see the steps.

Steps:

• Firstly, select the cell where you want the dataset title.

• Secondly, go to the Home tab.
• Thirdly, select Cell Styles.

Now, a drop-down menu will appear.

• After that, select the Style you want. Here, I selected Heading 2 from Titles and Headings. 

Finally, you will see that you have added the dataset title.

1.2. Using Cell Styles in Column Title

Here, I will explain how you can add a column title. Let’s see the steps.

Steps:

• Firstly, select the cell where you want the column title. Here, I selected cells C4 and D4.

• Secondly, go to the Home tab.
• Thirdly, select Cell Styles.

Here, a drop-down menu will appear.

• After that, select the Style you want. Here, I selected Heading 3 from Titles and Headings.

Now, you will see that you have finally added titles to your columns.

1.3. Using Cell Styles in Row Title

Here, I will explain how you can add a row title. Let’s see the steps.

Steps:

• Firstly, select the cell where you want the row title. Here, I selected cells B5 to B8.

• Secondly, go to the Home tab.
• Thirdly, select Cell Styles.

Here, a drop-down menu will appear.

• After that, select the Style you want for your row title. Here, I selected Heading 3 from Titles and Headings.

Finally, you will see that you have added the row title.

Now, I will remove the gridlines to get better visualization.

• Firstly, select the entire worksheet by clicking on the marked portion in the following image.

• Secondly, go to the View tab from the Ribbon.
• Thirdly, uncheck Gridlines to remove gridlines.

Here, in the following image, you can see my final dataset.

Read More: How to Put a Title Across Cells in Excel (With Easy Steps)

2. Modifying Cell Style Feature to Apply Title in Excel

In this method, I will explain how to apply title cell style in Excel by modifying the Cell Style feature.

Let’s see the steps.

Steps:

• Firstly, go to the Home tab.
• Secondly, select Cell Styles.

Here, a drop-down menu will appear.

• After that, Right-click on the Style that you want to modify.
• Next, select Modify.

Now, a dialog box named Style will appear.

• After that, select Format.

Here, the Format Cells option will appear.

• Firstly, go to the Alignment tab.
• Secondly, click on the drop-down option of Horizontal from Text Alignment.
• Thirdly, select Center.

• After that, click on the drop-down option of Vertical from Text Alignment.
• Then, select Center.

Now, I will change the Font.

• Firstly, go to the Font tab.
• Secondly, select the font you want. Here, I selected Calibri (body).
• Thirdly, select the font style you want. Here, I selected Bold.
• Next, select Font Size. Here, I selected 14.

After that, you can also change the color of your font.

• Firstly, click on the drop-down option of Color.
• Secondly, select the color you want. Here, I selected Black color. 

Now, I will edit the border for the title.

• Firstly, go to the Border tab.
• Secondly, select the Border you want. Here, I selected Bottom Border.

• Thirdly, select the drop-down option of Color.
• After that, select the color you want from the drop-down menu. Here, I selected the marked color in the following image.

• Next, go to the Fill tab.
• After that, select the color you want for Fill. Here, I selected the marked color in the following image.
• Finally, select OK.

After that, you will see the Style dialog box again.

• Now, select OK.

Now, I will add this modified Heading 2 as my Dataset title.

• Firstly, select the cell where you want your dataset title.

• Secondly, go to the Home tab.
• Thirdly, select Cell Styles.

Now, a drop-down menu will appear.

• After that, select the modified Style. Here, I selected the modified Heading 2.

Finally, you will see that you have added the dataset title.

Now, in the same way, I have added column title and row title.

Finally, I removed gridlines and added borders for better visualization. In the following image you can see my final dataset.

Read More: How to Make a Title Row in Excel (5 Easy Methods)

Similar Readings

• How to Change Legend Title in Excel (2 Easy Methods)
• Title a Column in Excel (5 Easy Methods)
• How to Change to Title Case in Excel (4 Easy Ways)

3. Making Duplicate Cell Style to Apply Title in Excel

In this method, I will explain how to apply title cell style in Excel by making duplicate Cell Styles.

Let’s see the steps.

Steps:

• Firstly, go to the Home tab.
• Secondly, select Cell Styles.

Here, a drop-down menu will appear.

• After that, Right-click on the Style that you want to make a duplicate of.
• Next, select Duplicate.

Now, a dialog box named Style will appear.

• Firstly, write the Style name as you want. Here, I wrote Column Title.
• Secondly, select Format.

To begin with, I will change the Font.

• Firstly, go to the Font tab.
• Secondly, select the Font you want. Here, I selected Calibri (body).
• Thirdly, select the Font style as you want. Here, I selected Bold.
• Next, select Font Size. Here, I selected 12.
• Then, select the color you want. Here, I selected Black.

After that, I will edit the Alignment.

• Firstly, go to the Alignment tab.
• Secondly, select the Horizontal Text alignment as you want. Here, I selected Center.
• Thirdly, select the Vertical Text alignment as you want. Here, I selected Center.

• After that, go to the Border tab.
• Then, select the Style you want. Here, I selected None.

• Next, go to the Fill tab.
• After that, select the color you want for Fill. Here, I selected the marked color in the following image.
• Finally, select OK.

After that, you will see the Style dialog box again.

• Now, select OK.

Here, you will see that a new Style named Column Title is added to your Cell Styles.

Now, I will add this new Style as my column title.

• Firstly, select the cell where you want your column title. Here, I selected cells C4 and D4.

• Secondly, go to the Home tab.
• Thirdly, select Cell Styles.

• After that, select the duplicated cell style. Here, I selected Column Title.

Here, you can see that I have added my column title.

Now, in the same way, I have also added the row title.

Finally, I removed gridlines and added borders for better visualization. In the following image, you can see my final dataset.

Read More: How to Add a Title to a Table in Excel (with Simple Steps)

4. Creating a New Style Feature to Apply Title in Excel

In this method, I will explain how to apply the title cell style in Excel by creating a Cell Style.

Let’s see the steps.

Steps:

• Firstly, go to the Home tab.
• Secondly, select Cell Styles.

Here, a drop-down menu will appear.

• Thirdly, select New Cell Style.

Now, a dialog box named Style will appear.

• Firstly, write the Style name as you want. Here, I wrote Row Title.
• Secondly, select Format.

To begin with, I will edit the Alignment.

• Firstly, go to the Alignment tab.
• Secondly, select the Horizontal Text alignment as you want. Here, I selected Center.
• Thirdly, select the Vertical Text alignment as you want. Here, I selected Center.

After that, I will change the Font.

• Firstly, go to the Font tab.
• Secondly, select the Font you want. Here, I selected Calibri (body).
• Thirdly, select the Font style as you want. Here, I selected Bold.
• Next, select Font Size. Here, I selected 12.
• Then, select the color you want. Here, I selected White.

• Next, go to the Fill tab.
• After that, select the color you want for Fill. Here, I selected the marked color in the following image.
• Finally, select OK.

After that, you will see the Style dialog box again.

• Now, select OK.

Here, I will add this style as my row title.

• Firstly, select the cell where you want the row title. Here, I selected cells B5 to B8.

• Secondly, go to the Home tab.
• Thirdly, select Cell Styles.

• After that, select the custom Row Title.

Now, you can see that I have added my row title successfully.

Finally, I removed gridlines and added borders for better visualization. In the following image, you can see my final dataset.

Read More: How to Add Title in Excel Graph (2 Quick Ways)

Formatting Cell Values Using Cell Styles Feature

Here, I will show you how you can format cell values using Cell Styles feature. Let’s see the steps.

Steps:

• Firstly, select the cells where you want to apply the formatting. Here I selected the values in the Sales column.

• Secondly, go to the Home tab.
• Thirdly, select Cell Styles.

• Now, select the Style that you want for your cells. Here, I selected the marked style from Themed Cell Styles.

Here, you will see that I have formatted the cell values for the Sales column.

After that, in the same way, I have formatted the cell values for the Profit column. In the following picture, you can see how my final dataset looks.

How to Remove Title Cell Style in Excel

Here, I will show you how to remove title cell style in Excel. Let’s see the steps.

Steps:

• Firstly, select the cells where you want to remove title cell style. Here, I selected cells B5 to B8.

• Secondly, go to the Home tab.
• Thirdly, select Cell Styles.

• After that, select Normal.

Now, you will see that the title cell style is removed.

Download Practice Workbook

Conclusion

To conclude, I tried to explain how to add title cell style in Excel. Here, I covered 4 different methods of doing it. I hope this was helpful for you. To get more articles like this, visit ExcelDemy. Lastly, if you have any questions, feel free to let me know in the comment section below.

Related Articles

• How to Merge and Center a Title in Excel (with Shortcuts)
• Insert Subtitle in Excel (2 Effective Methods)
• How to Make a Title Page in Excel (An Ultimate Guide)
• Center a Title in Excel (2 Quick Ways)