Center Titles Across Multiple Cells in Excel

Add to Favorites

How to center a title across multiple cells in Excel in order to make good looking titles for your spreadsheets.

  1. Select the cells in which you want to center text.
  2. Go to the Home tab and click the button Merge & Center

  3. Your title will now look like this:
  4. If you only selected one row of cells to merge, skip to Step 5.
    Since we selected multiple rows as well as columns, we now need to center the title within the rows.
    With the new cells still selected, click the Middle Align button.
  5. Now that the text is centered, add whatever formatting you would like to make it look nice.  I went to the Home tab, clicked Cell Styles and selected the Heading 1 option.
  6. That's it!


Using the method illustrated above, it's easy to make nice looking titles for any project in Excel.

To unmerge the cells simply click the drop down arrow next to the Merge & Center option and click Unmerge Cells.

Download the attached workbook so you can see this example in Excel.

Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
How to use Vlookup Across Multiple Worksheets in Excel
Tutorial: This tutorial shows you how to use the Vlookup function across multiple worksheets within ...
How to Arrange Data within Cells in Excel
Tutorial: In this tutorial I am going to look at cell alignment / arrangement. These features allow ...
Copy Data or Formatting to Multiple Worksheets in Excel
Tutorial: Quickly copy all or parts of a single worksheet - data, formatting, or both - to multiple...
Sum Values that Equal 1 of Many Conditions across Multiple Columns in Excel
Tutorial: How to Sum values using an OR condition across multiple columns, including using OR with ...
Vlookup Across Multiple Workbooks
Tutorial: How to use the VLOOKUP function across multiple workbooks in Excel. This will create a lin...
Split Text into Multiple Cells in Excel
Tutorial: How to split text from one cell into multiple cells quickly and easily in Excel.  This in...