How to Center a Title in Excel (With and Without Merging)

To center a title in Excel, type it in the first cell, select the cells it should span, and either click Merge & Center (Home tab) or choose Center Across Selection in Format Cells. Both look the same on screen, but Center Across Selection keeps your cells separate, so sorting, filtering and copying still work. That is the method I recommend.

Not sure which one you need? Use this quick guide, then jump to the section you want.

I want to center…	Best method	Shortcut (Windows)
A title across several columns (no merging)	Center Across Selection	Ctrl + 1, then Alignment tab
A title across several columns (merged)	Merge & Center	Alt, H, M, C
Text inside a single cell	Center button	Alt, H, A, C
Text up-and-down in a tall cell	Middle Align	Alt, H, A, M
A chart title	Chart Title > Above Chart	–
The whole sheet on a printed page	Page Setup > Margins > Center on page	–
Text in a printed header or footer	Custom Header, Center section	–

Steps are for Microsoft 365 and Excel 2016 or later. Older versions have the same commands, with small differences in tab names.

Merge & Center vs Center Across Selection

Merge & Center joins the selected cells into one big cell. Center Across Selection only changes how the text is displayed. The cells underneath stay separate.

	Merge & Center	Center Across Selection
Cells merged?	Yes	No
Contents of the other cells	Deleted	Kept (but cells to the right of the title must be empty for it to centre)
Sort and filter	Problems with merged cells	Works normally
Inside an Excel Table	Button is greyed out	Use it on a row above the Table
Where is it	Home tab button	Format Cells dialog

My rule: use Center Across Selection for anything you will sort, filter, copy or reuse. Use Merge & Center only for a finished report or dashboard that nobody will sort.

Method 1: Center Across Selection (recommended)

This centers your title over several columns without merging a single cell.

1. Type the title in the leftmost cell, for example A1.
2. Select the cells the title should span, for example A1:F1. The cells to the right of the title must be empty.
3. Press Ctrl + 1 (Cmd + 1 on Mac) to open Format Cells. Or right-click and choose Format Cells.
4. Stay on the Alignment tab. Under Horizontal, change General to Center Across Selection.
5. Click OK.

Click the title and look at the formula bar. The text lives in A1 only, and B1 to F1 are still ordinary cells. That is why sorting and filtering keep working.

Tip: If the title does not centre, check that the cells to its right are truly empty. Even a stray space stops it.

Method 2: Merge & Center

This is the quickest method, and fine for a one-off report.

1. Type the title in the first cell of the range.
2. Select the cells to span, for example A1:F1.
3. On the Home tab, in the Alignment group, click Merge & Center. Keyboard: Alt, H, M, C.

Excel keeps only the text in the top-left cell. Anything in the other selected cells is deleted, so copy it elsewhere first. Click the small arrow beside the button if you want Merge Across or Merge Cells (merge without centering).

If you select several rows, centered text sits in the bottom row of the merged cell. Fix that with Middle Align, covered next.

How to Center Text in a Single Cell

For one cell, no merging is needed. Select the cell and click Center in the Alignment group on the Home tab. Keyboard: Alt, H, A, C on Windows, or Cmd + E on Mac.

The same group has Left and Right alignment buttons if you change your mind. To center a whole row of column headings, select the header cells and click Center once.

How to Center a Title Vertically (Middle Align)

In a tall row, text sits at the bottom by default. Click Middle Align (Alignment group, Home tab) to put it halfway up the cell. Keyboard: Alt, H, A, M. Combine it with Center and the title sits exactly in the middle, horizontally and vertically.

How to Center a Title Over a Table

A title above a table is just a cell above the table’s first column. Use Center Across Selection on the row above the table, spanning the same columns as the table.

Do not merge cells inside an Excel Table. The Merge & Center button turns grey when the selection is part of a Table. Keep the title in a row above the Table instead, and your filter buttons and sorting stay intact. Want to sort a list safely? See Re-Sorting a List or Table in Excel.

How to Unmerge Cells in Excel

1. Select the merged cell.
2. On the Home tab, click Merge & Center again (it works as a toggle), or open its arrow and choose Unmerge Cells.

The text drops back into the left cell. To switch to the cleaner method, select the same range again and apply Center Across Selection as in Method 1. Pressing Ctrl + Z straight after merging also undoes it.

To find every merged cell on a sheet, press Ctrl + F, click Options > Format, tick Merge cells on the Alignment tab, then click Find All.

How to Center a Chart Title in Excel

New charts usually place the title in the top centre automatically. If yours is missing or has moved:

1. Click the chart.
2. Click the green + (Chart Elements) button at the top right, or go to Chart Design > Add Chart Element.
3. Tick Chart Title, then pick Above Chart. The title sits centered above the plot area.
4. Click the title and type your own text.

Centered Overlay in the same menu places the title over the chart instead of above it. If you dragged the title off-centre, choosing Above Chart again snaps it back.

Want the title to update by itself? Read Dynamic Chart Titles in Excel. More chart polish tips are in Creating Beautiful Excel Charts for Business Presentations.

How to Center a Sheet on the Printed Page

Your title may look centered on screen but print off to the left. To center the whole printout:

1. Go to the Page Layout tab.
2. Click the small arrow (dialog launcher) in the Page Setup group.
3. Open the Margins tab.
4. Under Center on page, tick Horizontally, Vertically, or both.

Check it in Print Preview (Ctrl + P).

How to Center Text in a Header or Footer (Print)

Every printed header and footer has three boxes: Left, Center and Right. “Center header section” simply means the middle box.

1. Go to Insert > Header & Footer. Excel switches to Page Layout view.
2. Click the center box at the top (header) or bottom (footer) of the page.
3. Type your text, or use the Header & Footer tab to insert the sheet name, file name, date or page number.

Prefer a dialog? Go to Page Layout, open the Page Setup launcher, choose the Header/Footer tab, then Custom Header or Custom Footer. Type in the Center section box. This route also lets you apply the same header to several sheets at once.

For example: file name in the left section, today’s date in the centre, page number in the right section. Print Preview shows the result.

Note: set up headers and footers in the Excel desktop app. Microsoft’s instructions for them cover the desktop versions.

Excel for Windows, Mac and the Web

• Windows: everything above applies. Shortcuts: Ctrl + 1, Alt, H, A, C.
• Mac: same buttons on the Home tab. Format Cells is Cmd + 1, and Center is Cmd + E. The Alt key sequences are Windows only.
• Excel for the web: Merge & Center is on the Home tab. If you cannot find Center Across Selection in the web version, open the file in the desktop app to apply it.

Want the full list of keys? See Microsoft Excel Shortcuts.

Troubleshooting

Merge & Center is greyed out

You are either editing a cell (press Enter or Esc first), or the cells are inside an Excel Table. Convert the Table to a range (Table Design > Convert to Range), or put the title in a row above the Table.

I cannot sort my data

Merged cells block sorting. Unmerge them, then use Center Across Selection instead. Also see How to Freeze Top Rows and Columns to keep headings visible while you scroll.

Center Across Selection does nothing

Make sure the title is in the leftmost cell and the cells to its right are empty. A space or a formula returning “” can also interfere.

My text disappeared after merging

Excel keeps only the top-left cell. Press Ctrl + Z immediately to get it back.

Frequently Asked Questions

How do I center a title in Excel?

Type the title in the first cell, select the cells it should span, then use Merge & Center on the Home tab or Center Across Selection in Format Cells. Center Across Selection is better because it does not merge cells.

What is the best way to center a title over the width of a section of a financial model?

Use Center Across Selection from the Format Cells menu (Alignment tab, Horizontal). It centers the title across the section without merging cells, so sorting, filtering and copying still work. The custom header’s center section is for printed pages, and Merge & Center merges the cells.

How do I center a header in Excel?

It depends on what you mean. For column headings, select the cells and click Center on the Home tab. For text printed at the top of every page, use Insert > Header & Footer and click the center box.

Where is the center header section in Excel?

It is the middle of the three boxes (Left, Center, Right) in Page Layout view and in the Custom Header dialog. Find it under Insert > Header & Footer or Page Layout > Page Setup > Header/Footer tab.

What is the shortcut to center text in Excel?

Press Alt, H, A, C in Windows to center the contents of the selected cells. On Mac, press Cmd + E. Merge & Center is Alt, H, M, C.

Why is Merge & Center greyed out?

Either you are still editing a cell, or the cells are part of an Excel Table. Press Esc, or convert the Table to a range first.

How do I center a title across columns without merging?

Select the cells, press Ctrl + 1, go to the Alignment tab and set Horizontal to Center Across Selection. The title is centered but each cell stays separate.

How do I center text vertically in Excel?

Select the cells and click Middle Align on the Home tab (Alt, H, A, M). Combine with Center to put text in the exact middle of the cell.

How do I center a chart title in Excel?

Click the chart, open Chart Elements (the + button), tick Chart Title and choose Above Chart. It is placed at the top centre of the chart.

Cheers,
Vinai Prakash
Founder & Master Trainer, ExcelChamp.net