Select A1:D1 with Quarterly sales in A1 and B1:D1 empty, then choose Home > Merge & Center. The heading spans A1:D1. On Windows desktop, press Alt and follow the displayed KeyTips to that command; on Mac or the web, use the Home ribbon. Keep other filled cells out of the selection.
On this page9
Keyboard route and menu alternatives
| Platform | Command route |
|---|---|
| Windows desktop | Press Alt to show KeyTips, then follow the displayed Home and Merge & Center choices. |
| Excel for Mac | Select the range, then choose Home > Merge & Center. |
| Excel for the web | Select the range, then choose Home > Merge & Center. |
The Windows route uses the KeyTips displayed by your ribbon; it is not a simultaneous key combination. Microsoft’s shortcut examples use a US keyboard layout. Ribbon language and browser shortcuts can differ, so use the named menu on Mac or in Excel for the web.
On a spare, left-to-right worksheet, type Quarterly sales in A1. Leave B1, C1 and D1 genuinely empty; do not type the word blank or use a formula that returns an empty string.
Select A1:D1. Confirm the selection covers only the heading row and that no other cell in that range contains text, a number or a formula.
Choose Home > Merge & Center to merge and center the heading. On Windows desktop, Alt displays KeyTips for keyboard navigation; follow the visible choices for Home and Merge & Center. Use the ribbon on Mac or in Excel for the web.
Check that Quarterly sales appears once across A1:D1 and is centered. Keep the report’s separate data cells below the heading unmerged.
Make one heading and check a filled-cell stop case
Use a spare left-to-right sheet. Type the heading in A1 and leave B1:D1 unused. The tables show the expected heading result and a separate populated pair that should stay unmerged when both values matter.
| Cell or range | Before Merge & Center | Expected heading result |
|---|---|---|
| A1 | Quarterly sales | Quarterly sales retained in merged A1:D1 |
| B1:D1 | Genuinely empty cells | Part of the same merged heading |
| A1:D1 | Four separate cells | One merged cell with a centered heading |
If columns are cut off, scroll the table sideways.
| Input pair | If the merge is completed | Safe decision when both values matter |
|---|---|---|
| A3 = North; B3 = South | North retained; South deleted | Leave A3:B3 unmerged and preserve the originals |
| A3 = North; B3 = South | Merging does not produce North South | Join text in empty C3 instead; expected text: North South |
If columns are cut off, scroll the table sideways.
- Only A1 contains data in A1:D1 before merging. The empty cells contain no spaces, formulas or placeholder labels.
- After Merge & Center, the heading appears once across A1:D1 and is centered. The separate records below the heading remain separate cells.
- Keep the populated A3:B3 safety pair unmerged. If a warning appears, cancel it rather than confirming loss of South.
- For text joining, =A3&" "&B3 in empty C3 returns North South. A3 stays North and B3 stays South; this result does not merge their layout.
Documentation reviewed .
Microsoft: Merge and unmerge cellsMicrosoft: Align text and Merge & CenterMicrosoft: Excel ribbon KeyTipsMicrosoft: Combine text from cells
Excel for Windows desktop: Check that only A1 contains text, select A1:D1, then choose Home > Merge & Center. For keyboard access, press Alt and follow the displayed KeyTips to the same command.Excel for Mac: Check that only A1 contains text, select A1:D1, then choose Home > Merge & Center. Use the named ribbon command instead of substituting Command into a Windows key sequence.
What this does
Merge & Center makes the selected cells one larger cell and centers the retained heading across it. For this left-to-right example, the retained value belongs in A1, the upper-left cell. Other filled cells in the selection are not appended to it: their contents are deleted when the merge is completed. The Merge Cells and Merge Across choices in the same menu merge without centering, so choose Merge & Center for this heading. Ordinary Center alignment centers text within its existing cell; it does not create a heading spanning A1:D1.
A worked example
Build the heading on a spare sheet: A1 contains Quarterly sales and B1:D1 contain nothing. Select A1:D1 and choose Home > Merge & Center. The expected result is one centered heading across those four columns; the text is not repeated in each column. Use the separate A3:B3 safety example below to decide when to stop: if A3 contains North and B3 contains South, both entries matter. Leave that pair unmerged. Copy the original values somewhere safe before considering any layout change. If Excel displays a data-loss warning, cancel it while you decide how to preserve the text; do not rely on a warning appearing in every interface.
In Google Sheets
This example documents Excel’s Home ribbon and Windows KeyTips. Those keys and menu labels are not instructions for Google Sheets. Check the Sheets merge command separately before applying a layout change there. If your goal is to keep North and South together as text, use a text-joining workflow instead of merging cells. In Excel, =A3&" "&B3 in empty C3 produces North South while leaving A3 and B3 separate. The linked Combine Columns tool joins pasted text in your browser; it does not merge worksheet cells or run Excel.
Common mistakes
- Merging a populated pair and expecting both values to survive. With North in
A3and South inB3, a completed left-to-right merge retains North and discards South; do not perform that merge when both are needed. - Treating a formula that displays an empty string as a genuinely empty cell. Start this heading exercise with
B1:D1unused. - Choosing Merge Cells and expecting the centered heading from Merge & Center, or using ordinary Center alignment and expecting one larger cell.
- Merging the data rows along with the heading. Select only
A1:D1; keep individual report fields in their own cells. - Using Unmerge Cells as a backup for text that a merge deleted. Preserve the original values before merging; splitting the layout is not a text-joining or data-recovery method.
Frequently asked questions
What is the keyboard route for merging cells?
On Windows desktop, press Alt to display ribbon KeyTips and follow the displayed choices for Home and Merge & Center. The route depends on the ribbon language. Use Home > Merge & Center on Mac or in Excel for the web; this page does not supply a guessed Mac or browser key combination.
Which filled cell is kept?
Microsoft documents retention of the upper-left cell for left-to-right languages, and the upper-right cell for right-to-left languages. This exercise uses a left-to-right sheet with text only in A1. Other filled-cell contents in the selected range are deleted by a completed merge.
Why is Merge & Center unavailable?
Finish editing the cell and check whether the selection is inside an Excel table. Microsoft identifies both as reasons the command can be disabled. Use a separate ordinary worksheet range for this heading exercise rather than changing a table’s structure just to merge its cells.
How do I split the heading into cells again?
Select the merged heading and choose the Merge & Center arrow > Unmerge Cells. The heading remains in the retained cell. Keep a copy of other original text before merging; unmerging is not a way to combine or restore discarded values.
How do I keep both North and South?
Keep A3 and B3 separate and join their text in a helper cell, for example =A3&" "&B3 in C3. The browser Combine Columns link below offers pasted-text joining with a separator. Neither method changes the source cells into a merged layout.