How to Add, Format & Remove Title in Excel (Complete Guideline)

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.

Title in Excel

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.

Select the Merge & Center feature

  • Our selected cells are merged now.

Merging and centering selected cells

  • Type Sales Report as the title in the merged cells.

Using Merge & Center feature to insert title in Excel

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.

Selection of Center Across Selection option

  • Now, you can center the data in the selected cells.

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

Selection of the 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.

Appearing Header & Footer tab in the Excel sheet

  • Click on Add header box >> Select Header & Footer tab >> From the Header & Footer Elements group, choose File Name and Sheet Name feature with space.

Select File Name and Sheet Name features

  • After that, move your cursor to any other cell and you will be able to see the title.

Create a title with the workbook and sheet name

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.
Inserting header title

Click here to enlarge the image

  • Hence, move your cursor to any cell, and you will see 1 in the top-right corner of the sheet as the header.

Getting header title

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.

Use Font group to format title

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.
Selection of the Heading 1 option to format title in Excel

Click here to enlarge the image

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.

Selection of the Custom Header option

  • Header dialog box will appear >> Insert Sales Report in the Center section typing box >> Click OK option >> Again, press OK on Page Setup window.

Inserting Sales Report in Center section typing box

  • Finally, you will see the Sales Report as the header.

Using Page Setup dialog box to Insert center header title

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.

Blank cells to title the columns

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

Typing Order No in the Formula Bar

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

Adding column titles for the rest of the columns

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.

Using Font group to format title columns

  • Select the Center and Middle Align from the Alignment group.

Apply Alignment group to format title columns

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.

Removing title in Excel

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.

Add Title in Excel chart

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.

Formatting chart title

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.

Using formula to create Dynamic chart title

  • Hence, press Enter.

creating Dynamic chart title

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.

Checking the dynamic chart title

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.

Check the Axis Titles option

  • Set the Horizontal and Vertical axis titles as Customer Name and Sub Total respectively.

Set the Horizontal and Vertical axis titles

How to Remove Chart or Axis Title in Excel

Uncheck the Chart Title & Axis Titles option from the Chart Elements group.

Uncheck the Chart Title and Axis Titles options

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.

Using Freeze Panes to freeze title

  • Hence, you can freeze the title in Excel as shown in the following screenshot.

Freeze the title in Excel

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.

Selection of the Normal feature

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

Hiding title in Excel

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


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!
Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF