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

If you are looking for how to make a title in Excel, then you are in the right place. In our practical life, we have to deal with Excel worksheets where giving titles is a must. We have to use both column title and row title. In this article, we’ll try to discuss how to make a title in Excel.


Download Practice Workbook


2 Methods to Make a Title in Excel

There are some easy ways to make a title in Excel. To show this, firstly, we have made a dataset named Dataset to Make a Title. We have blank Row 4 where we’ll try to add titles. The dataset is like this.

how to make a title in excel

Let’s see how we can add titles to this Excel sheet.


1. Using Cell to Make a Title in Excel

We can use cells to make a title directly and it is the most suitable method to make titles. To apply this method we need to work on the following dataset of Using Cell to Make a Title.

how to make a title in excel using cell

We need to follow the two steps described below.


Step-01: Making Title

Firstly, double-click on the B4 cell. Now, the cell is ready to write anything here.

how to make a title in excel using cell

Secondly, give a proper name of the cell according to the database of Column B. Here, we have written the Name of Month.
Thirdly, press ENTER.

how to make a title in excel using cell

Similarly, do the same thing for the cells C4 and D4 and name them Temp in London (deg C) and Temp in Newyork (deg C).
Eventually, the titles are added to the 4th Row.

how to make a title in excel using cell

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


Step-02: Formatting Title

After adding titles, the most important thing is to format the titles. Because without formatting it is difficult to use in bigger databases. We need to format the titles in the 4th Row of the dataset below.

 formatting

Firstly, select the titles i.e. cells B4:D4.
Secondly, go to Home > select the Center and Middle alignment like shown in the picture below > click B on the Font group or press CTRL + B to make the titles bold.

how to make a title in excel, formatting title

Consequently, the alignment and font of the title will be like this.

how to make a title in excel, formatting title

Additionally, we can select any alignment from the Alignment box and make the title to Italic form or add Underscore by selecting I or U from the Font group according to our requirements.
Thirdly, we’ll add a background to the cells of the title.
To do this, select the cells from B4:D4 > go to Home > select the background color icon like shown in the picture > choose any color options (Here, we have selected Light Blue color)

how to make a title in excel, formatting title

Eventually, the titles will look like this.

 formatting title

Fourthly, we need to change the font size.
To do this, select cells B4:D4 again > go to Home tab > select Font size option > choose any font size you want to add (Here, we have added font size as 12)

 formatting title

Finally, our formatted titles will look like this.

Read More: How to Center a Title in Excel (2 Quick Ways)


2. Utilizing Formula Bar to Make a Title in Excel

We can simply use Formula Bar to make titles. We need to work on the following dataset of Utilizing Formula Bar to make titles in the cells B4:D4.

 using Formula Bar

Firstly, select the B4 cell with one click > click on the Formula Bar.

using Formula Bar

Secondly, write the required title in the Formula Bar. Here we have written Name of Month.
The title in the B4 cell is automatically added like this.

how to make a title in excel using Formula Bar
Repeatedly, do the same thing for C4 and D4 cells by writing Temp in London ( deg C) and Temp in Newyork ( deg C) respectively in the Formula Bar.
This statement is shown for the D5 cell in the picture below.

how to make a title in excel using Formula Bar

Finally, following the Step-02 of Method 1, we need to format the titles and get the output like this.

using Formula Bar

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


Similar Readings


Centering Title with Appropriate Cell Style

We need to format titles in a way such that their cell style and placing is different from others. The main title for the following dataset is Centering Title. We just need to format it with the appropriate cell style and positioning.

how to make a title in excel, centering title

Firstly, select the B2 cell and stretch it to the D2 cell by sliding the cursor to the right.

Secondly, go to Home > select Merge & Center.

how to make a title in excel, centering title

Consequently, the title will be merged in the center of B2:D2 cells like this.

how to make a title in excel, centering title
Thirdly, select the merged cell > go to the Home tab > click on the Cell Styles option.

 centering title
A Cell Style bar will appear.
Fourthly, select Heading 2. We can choose any type of option from the Titles and Headings group according to our requirements.

 centering title

Eventually, our title will be like this.

how to make a title in excel, centering title

Fifthly, to align the title in the center, select the title cell > go to Home > select the Center and Middle alignment options from the Alignment box.

centering title

Finally, we’ll have our desired title with the appropriate cell style and positioning.

centering title

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


Using Transpose Option to Convert Column Title to Row Title

We can convert column title to row title or vice versa by using a simple method which is using Transpose Command. We need to apply that method in the following dataset of Using Transpose Command.

transpose command

Firstly, select the whole dataset > go to Home > select Copy from the Copy icon or press CTRL+C.

transpose command

Secondly, select a cell from where the transposed titles will place. We have selected the B12 cell here.
Thirdly, go to Home > Select Paste by Transpose icon shown in the picture below from Paste option

transpose command

Consequently, we’ll get the output like this.
Here, all the Column Titles are now converted to Row Titles and the whole dataset is transposed.

transpose command

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


Things to Remember

  • While following Method 1 we need to make sure that the cells should be double-clicked. One-click will not prepare the cell for writing and editing rather it will just select the cell.
  • We can change the Font Type, Color of the font, and create Borders of different types to the titles from the Font box in the Home ribbon.

Conclusion

We can make any kind of title very effective if we study this article properly. Please visit our official Excel learning platform Exceldemy for further queries.


Related Articles

Towhid
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo