How to Insert a Subtitle in Excel – 2 Methods

Method 1 – Using the Merge & Center feature to Insert a Subtitle in an Excel Sheet

• Select a blank cell on the top of your data table.
• Enter a caption into the cell.

• Select the consecutive cells to merge them.
• Go to the Home tab and select Merge & Center in Alignment.

• Go to the Home tab again.
• In  Alignment, select Top Align.
• Select Align Right.

• With the merged cells selected, go to the Home tab.
• In Font, select Italic.

• This is the output.

Read More: How to Center a Title in Excel

Method 2 – Using a Text Box to Insert a Subtitle in an Excel Chart

• Go to the Insert tab.
• Click Shapes.
• Select Text Box in Recently Used Shapes.

• Drag a rectangle using the Text Box tool.
• Choose a location for the Text Box.

• Enter a subtitle.
• Press ESC button or click the sheet.

• This is the output.

Practice Section

Practice here.

Download Practice Workbook

Download the Excel file.

Related Articles

• How to Make a Title Page in Excel
• How to Make a Title in Excel
• How to Merge and Center a Title in Excel

<< Go Back to Title in Excel | Worksheet Formatting | Learn Excel