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.


Download Practice Workbook


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.


4 Easy Ways to Apply Title Cell Style in Excel

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.

Using Cell Style Feature to Apply Title in Excel

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

Using Cell Style Feature to Apply Title in Excel


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.

Using Cell Style Feature to Apply Title in Excel

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.

Using Cell Style Feature to Apply Title in Excel


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.

Using Cell Style Feature to Apply Title in Excel

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

Using Cell Style Feature to Apply Title in Excel

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.

Using Cell Style Feature to Apply Title in Excel

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

Using Cell Style Feature to Apply Title in Excel

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.

Modifying Cell Style Feature to Apply Title in Excel

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.

Modifying Cell Style Feature to Apply Title in Excel

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.

Modifying Cell Style Feature to Apply Title in Excel

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.

Modifying Cell Style Feature to Apply Title in Excel

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

Modifying Cell Style Feature to Apply Title in Excel

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

Modifying Cell Style Feature to Apply Title in Excel

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

Modifying Cell Style Feature to Apply Title in Excel

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.

Modifying Cell Style Feature to Apply Title in Excel

Read More: How to Make a Title in Excel (2 Useful Methods)


Similar Readings


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.

Making Duplicate Cell Style to Apply Title in Excel

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.

Making Duplicate Cell Style to Apply Title in Excel

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.

Making Duplicate Cell Style to Apply Title in Excel

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

Making Duplicate Cell Style to Apply Title in Excel

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

Making Duplicate Cell Style to Apply Title in Excel

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.

Making Duplicate Cell Style to Apply Title in Excel

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

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

Making Duplicate Cell Style to Apply Title in Excel

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.

Making Duplicate Cell Style to Apply Title in Excel

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.

Creating a New Style Feature to Apply Title in Excel

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.

Creating a New Style Feature to Apply Title in Excel

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.

Creating a New Style Feature to Apply Title in Excel

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

Creating a New Style Feature to Apply Title in Excel

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

  • After that, select the custom Row Title.

Creating a New Style Feature to Apply Title in Excel

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.

Creating a New Style Feature to Apply Title in Excel

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.

Formatting Cell Values Using Cell Styles Feature

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

Formatting Cell Values Using Cell Styles Feature

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.

Formatting Cell Values Using Cell Styles Feature


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.

How to Remove Title Cell Style in Excel

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


Practice Section

Here, I have provided a practice sheet for you to practice how to add title cell style in Excel.


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

Mashhura

Mashhura

Hey! Welcome to my profile. Right now, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo