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.
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.
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.
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.
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.
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.
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.
Consequently, the alignment and font of the title will be like this.
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)
Eventually, the titles will look like this.
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)
Finally, our formatted titles will look like this.
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.
Firstly, select the B4 cell with one click > click on the 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.
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.
Finally, following the Step-02 of Method 1, we need to format the titles and get the output like this.
- How to Add Title in Excel Graph (2 Quick Ways)
- Change Legend Title in Excel (2 Easy Methods)
- How to Change to Title Case in Excel (4 Easy Ways)
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.
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.
Consequently, the title will be merged in the center of B2:D2 cells like this.
Thirdly, select the merged cell > go to the Home tab > click on the Cell Styles option.
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.
Eventually, our title will be like this.
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.
Finally, we’ll have our desired title with the appropriate cell style and positioning.
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.
Firstly, select the whole dataset > go to Home > select Copy from the Copy icon or press CTRL+C.
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
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.
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.
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.