Merge Cells in Excel Without Merging: Center Across

To make a heading look centered across several Excel columns without combining the cells, select the range, open Format Cells, and choose Alignment > Horizontal > Center Across Selection. This keeps the cells separate and preserves their individual contents. The method is best for a heading or label in the leftmost cell of a single row, with the cells to its right left empty.

Excel’s Center Across Selection option changes how text is displayed; it does not create a merged cell. That distinction is useful when you want a clean layout but also need ordinary cells for entering data, sorting, copying, or using formulas.

What You’ll Need

Excel for Microsoft 365 desktop on Windows, or the desktop version for Mac.
A worksheet with the heading or label entered in the first cell of the range you want to span.
Empty cells to the right of that heading within the selected range, so other entries do not interfere with the centered display.

Excel for the web does not provide the Center Across Selection setting in its usual cell-alignment controls. If you are working in a browser, open the workbook in the Excel desktop app to apply this formatting.

Step-by-Step

Enter the heading in the first cell. For example, type a report title in B2 if you want it centered across B2:D2. The text needs to be in the leftmost cell of the selected range. If the title is currently in C2, either move it to B2 or select a range that starts at C2.
Leave the remaining cells in the range empty. For the example, make sure C2 and D2 do not contain text or numbers. Center Across Selection will not delete values from those cells, but content there can prevent the heading from appearing as a single centered line across the full range. Move any data you need to keep before formatting.
Select the cells the heading should span. Click B2 and drag across to D2, or click B2, hold Shift, and click D2. The selection should be one horizontal row, such as B2:D2. You can select a wider range if the heading needs more room.
Open the Format Cells dialog. On Windows, press Ctrl+1. You can also go to Home > Alignment and click the small dialog box launcher at the lower-right corner of the Alignment group. On Mac, press Command+1 to open Format Cells; the ribbon layout can look slightly different, but the relevant setting is in the Alignment tab.
Choose the horizontal alignment option. In Format Cells, open the Alignment tab. Find the Horizontal dropdown, open it, and select Center Across Selection. This is a horizontal alignment choice, not the Merge Cells command.
Apply the setting. Click OK. The title in B2 should now appear centered across the B2:D2 range. Click each cell in the range to confirm that the cells remain separate; the selection outline and formula bar will identify the active cell normally.
Adjust the range or appearance if needed. If the heading looks off-center, select the range again and check that it begins with the cell holding the text and ends at the intended column. You can still change font, font size, color, borders, and fill from the Home tab. These options change appearance without merging the cells.

To center another heading on a different row, repeat the process for that row’s range. For example, if a second heading is in B5, select B5:D5 and apply the same alignment. Applying the format separately by row keeps each heading associated with its own cells. If you select several rows at once, Excel may apply the alignment to each row in the selection; for predictable results, work with one heading row at a time.

To reverse the effect, select the formatted range, open Format Cells > Alignment, and choose General or another horizontal alignment from the Horizontal dropdown. This changes the alignment back without affecting the cell contents. You can also use the Undo command immediately after applying the format, although changing the setting directly is clearer if you have made other edits since then.

Common Mistakes

Putting the heading in the wrong cell. Center Across Selection uses the leftmost cell as the source of the displayed text. If the selected range is B2:D2 but the heading is in C2, the result will not behave like a heading centered across B2:D2. Put the heading in B2 or start the selection at C2.
Selecting cells with existing content. The alignment setting does not combine cells or clear their contents. If C2 or D2 has data, that data remains in place and may conflict visually with the heading. Check the range before applying the format, and move any important values rather than deleting them.
Using the Merge & Center button by mistake. That command actually merges cells and can discard content from cells other than the upper-left cell. Use Format Cells > Alignment > Horizontal > Center Across Selection instead. If you accidentally merge, use Undo promptly; unmerging later does not restore values that were removed.
Expecting the text to span vertically. Center Across Selection is a horizontal alignment option. It is suited to a range such as B2:D2, not to making a heading appear centered across a tall block of rows.
Assuming the cells are merged because the heading looks continuous. The visual result can resemble a merged heading, but the cells are still separate. Click within the range or inspect the formula bar to check which cell contains the text.

Tips

Choose the smallest useful range. If a title needs to span B:D, do not format B:K just because those columns are visible. A narrower range is easier to maintain if you later add columns or move the report layout.
Keep the heading in the first cell. A consistent layout makes it easier to edit later. For each heading, put its text in the leftmost cell of its own selected range and leave the cells after it blank.
Use borders and fill to define the heading area. Center Across Selection does not draw a border or add background color. Select the same range and apply a fill or border from the Home tab if you want the heading area to stand out.
Consider other people who will edit the file. The cells remain ordinary cells, but the alignment may not be obvious to someone inspecting the workbook. A brief note in your documentation or a consistent heading style can help other editors understand the layout.
Use actual merge only when you need it. A merged cell can be appropriate for a simple display-only title, but it can make selecting, sorting, and manipulating ranges less convenient. Center Across Selection is often a better fit when the worksheet also contains structured data.

Troubleshooting

The option is missing or you cannot find it. Make sure you opened the full Format Cells dialog and selected the Alignment tab, rather than only using the center-alignment button on the ribbon. The setting is inside the Horizontal dropdown. In Excel for the web, open the workbook in the desktop app and try again.

The heading stays at the left or appears in the wrong place. Confirm that Center Across Selection is selected, the heading is in the first cell of the range, and the intended range is selected. Also make sure you did not choose ordinary Center alignment, which centers text only within its own cell.

The title does not look centered across the range. Check for text or values in the cells to the right, and make sure the columns are wide enough to display the title. If the heading is longer than the combined width, widen the columns, reduce the font size, or choose a shorter heading. Center Across Selection does not automatically resize columns or wrap text across the range.

The cells still behave oddly after formatting. Center Across Selection does not merge cells, so it should not itself prevent selecting individual cells. If a range is still merged, select it and use Home > Merge & Center > Unmerge Cells. Be aware that unmerging does not recover any values previously lost when cells were merged.

You cannot edit the heading. Click the leftmost cell in the formatted range, because that is where the text is stored. If editing is blocked, check whether the worksheet is protected or whether the cell is locked under the sheet’s protection settings; alignment formatting is separate from editing permissions.

Frequently Asked Questions

Does Center Across Selection actually merge cells?
No. It changes horizontal alignment so text in the first cell appears centered across the selected range. Each cell remains separate and can still hold its own value.

Can I use this for multiple headings?
Yes. Apply the setting to each heading row separately, making sure the text is in the leftmost cell of that row’s range. For example, use B2:D2 for one title and B5:D5 for another.

Will the setting delete data in the other cells?
No. Center Across Selection does not clear cell contents. However, data in the rest of the selected range can interfere with the visual result, so check the cells before formatting.

Can I use it in Excel for the web?
The desktop app is the reliable option because Excel for the web does not expose this setting in its normal alignment controls. Open the file in Excel for Microsoft 365 on Windows or Excel for Mac to apply it.

Does it work for vertical ranges?
It is designed for horizontal alignment across columns, such as B2:D2. For a vertically arranged label, use ordinary alignment, borders, or a layout change rather than expecting this setting to span rows.

Can I still sort or filter the worksheet?
Because the cells are not merged, this method avoids the merged-cell structure that can complicate some worksheet operations. Sorting and filtering still depend on having a properly organized data range with consistent headers and rows.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.