In this Excel tutorial, you will learn how to:
– Add or Insert a title in Excel
– Format a title
– Create a title column
– Remove a title
– Add the title in Excel chart
– Create a dynamic chart title
– Remove chart or axis title
– Freeze title in Excel
– Hide or show title in Excel
We have used Microsoft 365 to prepare this article. However, the methods are also applicable in all Excel versions.
The title gives you an idea of what’s going on in the dataset and makes things clear. To explain this article, we will use the following dataset containing the sales report of a company.
Download Practice Workbook
Download this practice workbook for practice while you are reading this article.
What Is a Title in Excel?
We can insert a title into a worksheet, chart, or graph to provide a clear description or heading for the content. The title makes it easier for readers to interpret and analyze the information. It enhances the overall presentation and communication of data within an Excel document.
What are the Types of Title in Excel?
There are several types of Titles in Excel. They are:
- Worksheet Title: The title given to an entire worksheet, represents the main subject or purpose of the data it contains.
- Cell Title: Titles to specific cells to provide additional context or description for the data contained within.
- Column Title: Titles to individual columns, providing descriptions of the data contained in each column.
- Row Title: Titles to individual rows, typically used to identify and categorize the data within each row.
- Chart Title: A title added to a chart or graph, summarizing the information presented in the visual representation.
- PivotTable Title: A title assigned to a PivotTable, which summarizes the data analysis or insights provided by the PivotTable.
- Report Title: A title used in reports or presentations created in Excel, capturing the main topic or subject matter of the document.
What Is the Importance of Title in Excel?
Here are some reasons why the title is important in Excel:
- Data Organization: A title helps you and others understand what the data is about and provides a quick overview.
- Data Interpretation: A well-chosen title can provide important information about the content of the spreadsheet.
- Data Filtering: When working with large datasets, you may need to filter or sort the data based on specific criteria. Having a title helps you identify the relevant columns or rows to apply filters or sorting, making it easier to work with the data.
- Data Sharing: If you share your Excel files with others, a clear and descriptive title makes it easier for recipients to understand the purpose of the data.
- Documentation and Reference: When you create a title for your Excel spreadsheet, it becomes a reference point for future use. If you need to revisit the spreadsheet at a later time, the title helps you remember the purpose of the data and find the relevant information quickly.
- Presentation and Reporting: A well-crafted title in Excel enhances presentations, setting context, capturing attention, and adding impact to your data.
How to Insert Title in Excel
1. Using Merge & Center Feature to Insert Title in Excel
In our dataset, we’ll merge and center cells B2:H2 and then insert the title.
- Select range B2:H2.
- Go to Home tab >> Alignment >> Merge & Center.
- Our selected cells are merged now.
- Type Sales Report as the title in the merged cells.
Notes: If you merge multiple cells containing data, only the data from the first cell will remain in the merged cell. The data from the other cells will be lost.
2. Insert Title Using Center Across Selection Command
We’ll use the Center Across Selection feature to center the data of the selected cells of Excel. You do not need to merge the cells in this method.
- We have entered a title in cell B2.
- Select range B2:H2 and press Ctrl + 1.
- Format Cells dialog box pops up.
- Go to the Alignment tab >> Choose the Center Across Selection option from the Horizontal drop-down list >> Select the Center option from the Vertical drop-down list >> Click on OK.
- Now, you can center the data in the selected cells.
Note: By using the Center Across Selection option, you can center the title without losing any data from the selected cells.
3. Use Header and Footer Feature to Insert a Title in Excel
You can use the Header & Footer feature to add or insert a Title in Excel.
- Select Insert tab >> Go to the Text option >> Choose Header & Footer feature.
- We can see the Header & Footer box appears on the Excel sheet. When we click this box, the Header & Footer tab appears in the Excel ribbon.
- Click on Add header box >> Select Header & Footer tab >> From the Header & Footer Elements group, choose File Name and Sheet Name feature with space.
- After that, move your cursor to any other cell and you will be able to see the title.
4. Use Header & Footer Elements Section to Add Page Numbers, Dates, Times, or Any Other Text in Title
In the above method, we enabled the Header & Footer feature in the sheet. Here, we will show how to add page numbers, dates, times, or any other text to the header or footer title.
- Select Header option >> Header & Footer tab >> Header & Footer Elements >> Page Number.
- Hence, move your cursor to any cell, and you will see 1 in the top-right corner of the sheet as the header.
Similarly, you can edit the header title of the center box.
How to Edit or Format Title in Excel
1. Use Font Group to Format Title in Excel
We will use the Font group to format the title in Excel.
- Select the title of the data table >> Go to Home tab >> Choose Font group.
- Format the title as you want from the Font group. You can change the font color, size, style, etc. from here.
2. Using Cell Styles Feature to Edit and Format Title
We’ll use the Cell Styles feature to format the title in Excel. Cell Styles contains a list of predefined formats to use.
- Select title >> Go to Home tab >> Choose Font group >> Select Cell Styles drop-down list.
- Choose Heading 1 from the Title and Heading option.
3. Apply Page Setup Dialog to Edit Header & Footer Title
You can also edit the Header and Footer title using the Page Setup dialog box. We’ll change the header Title in Excel.xlsx Header & Footer to Sales Report by using the Page Setup dialog box.
- Go to Page Layout tab >> Page Setup >> Select the arrow in the bottom-right corner.
- Page Setup dialog box pops up >> Choose the Custom Header option from the Header/Footer tab.
- Header dialog box will appear >> Insert Sales Report in the Center section typing box >> Click OK option >> Again, press OK on Page Setup window.
- Finally, you will see the Sales Report as the header.
Following the above process, you can edit the header title as you want.
How to Title a Column in Excel
We can use Formula Bar to title a column in Excel. Now, we will add the title to all cells of range B4:D4.
- Select cell B4 >> Go to the Formula Bar >> Type your desired title for your column. Here, we typed Order No as column title.
- Hence, press Enter.
- Similarly, add column titles for the rest of the columns. Here, we will set Order Date as title in cell C4, Customer Name as title in cell D4, and so on.
Now, we will show you how to Format your column title in Excel.
- Select range B4:H4 >> Go to Home tab >> Choose Font group.
- You can make the text in the title columns bold and italic and change the text and background color of the title columns using the Font group.
- Select the Center and Middle Align from the Alignment group.
How to Remove Title in Excel
If you don’t need the title, you can remove it. You can remove the title by using the Cell Styles feature in Excel.
Select the cells where the titles are >> Go to the Home tab >> Styles >> Cell Styles >> press Normal.
Notes: You can also remove the title from an Excel data table by selecting it and pressing the Delete key.
How to Add Title in Excel Chart
1. Add and Format Excel Chart Title
We can add a title to an Excel chart by using the Chart Element feature and format using the Font and Alignment groups under the Home tab.
- To add a title, select the chart area >> Click on plus (+) symbol at the top-right corner of the chart >> Check the Chart Title option >> Add Customer vs Sub Total chart as title.
Now, you can format the chart title using the Font and Alignment groups.
- Select the chart title >> Go to Home tab >> Use the Font group for bold and italic format and change the text and background color of the chart title.
- You can modify the alignment of the chart title using the Alignment group.
2. Create a Dynamic Chart Title
You can create a dynamic chart title by linking a cell reference.
- Select the chart title >> Go to Formula Bar >> Type an equal (=) sign and then select any cell ($H$4) to create a link.
- Hence, press Enter.
Now, we’ll check if the chart title is dynamic or not.
When we change the Sub Total column heading to Total, we will observe that the chart title automatically changes.
3. Add Axis Titles to a Chart in Excel
We can add Titles to the horizontal and vertical axis of a chart in Excel.
- Select the chart >> Click the plus (+) symbol at the top-right corner of the chart >> Check the Axis Titles option from Chart Elements.
- Set the Horizontal and Vertical axis titles as Customer Name and Sub Total respectively.
How to Remove Chart or Axis Title in Excel
Uncheck the Chart Title & Axis Titles option from the Chart Elements group.
How to Freeze Title in Excel
You can use the Freeze Panes feature to visible title while scrolling through a large worksheet.
- Select the cell A3 below the title.
- Go to the View tab >> Window >> Select the Freeze Panes dropdown menu >> Freeze Panes feature.
- Hence, you can freeze the title in Excel as shown in the following screenshot.
To unfreeze the titles, simply go back to the Freeze Panes dropdown menu and select Unfreeze Panes.
How to Display or Hide Titles in Excel
To display or hide titles in Excel, go through the process below:
- Choose the View tab >> Workbook Views >> Click on the Normal feature.
- Hence, by default, titles within rows and columns are visible.
- Place your cursor left side below Row 2 >> Two directional arrow appears >> Drag the mouse upward to minimize the row height.
- Your title will be hidden.
- Please take a look at the video file below for a better understanding.
Which Things You Have To Remember?
- Always remember to save your spreadsheet after adding titles to ensure that your changes are not lost.
- You can also add or remove Data Labels, and Legend from the Chart Elements section.
- Using the Alignment and Font group from the Home tab, you can format the title.
Frequently Asked Questions
1. Can I add a picture or image as the title in Excel?
Answer: No, you cannot directly add a picture or image as the title in Excel. However, you can create a separate text box or shape and insert an image into it, placing it near the title area to achieve a similar effect.
2. Is there any character limit for the title in Excel?
Answer: Yes, there is a character limit for the title in Excel. The maximum character limit for a title is 255 characters, including spaces and special characters.
3. Can I use a formula as a title in Excel?
Answer: Yes, you can use a formula as a title in Excel. To do this, create the desired formula in a cell, and if you want to display the result as a title, copy the formula cell, right-click the destination cell where you want the title, and choose Paste Values to convert the formula result into a static title.
Conclusion
In the above discussion, we discussed the ways to add, format, and remove titles in Excel. We have also discussed how to add or remove a title in a chart or graph as well as to create a dynamic chart title.
The title in Excel provides essential context, improves understanding, and enhances the visual representation of your data.
I hope you found this article interesting. Leave a comment if you have any queries.
Title in Excel: Knowledge Hub
<<Go Back to Worksheet Formatting | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!