Merge in Excel Without Merging: Center Across Selection

How-to basics · Updated November 20, 2026

To make a heading appear centered across several Excel columns without combining the cells, select the range, open Format Cells, then choose Alignment > Horizontal > Center Across Selection. This keeps each cell separate and preserves its contents. If by “merge” you mean join text from multiple cells into one result, use a formula instead; both approaches are covered below.

This guide is for Excel for Microsoft 365 on Windows. Center Across Selection is useful for titles and labels that should span a row visually, while keeping the worksheet easier to sort, filter, copy, and work with. It does not combine values or create one larger cell.

What You’ll Need

  • An Excel workbook and a row of cells where you want the heading to appear centered.
  • The heading or label in the leftmost cell of the selected range. For example, put “Quarterly Sales” in A1 if you plan to center it across A1:D1.
  • Access to the desktop version of Excel. Excel for the web may not offer the Center Across Selection option in its alignment controls, so use Open in Desktop App if you cannot find it.

Step-by-Step

  1. Choose the right row and range. Identify the cells that the heading should appear to span. For a heading centered across columns A through D in row 1, the range is A1:D1. Select one horizontal row for one heading; selecting several rows applies the alignment separately to each row, not as a single large merged area.
  2. Enter the heading in the first cell. Type the full heading into the leftmost cell of the range, such as A1, and leave the other cells in that span empty if possible. Center Across Selection uses the value in the first cell and positions it across the selected range. It does not pull text from the other cells.
  3. Select the full range. Drag across the cells, or click the Name Box to the left of the formula bar, type the range address such as A1:D1, and press Enter. Make sure the selection includes the heading cell and every column across which you want the heading centered.
  4. Open the Format Cells dialog. On Windows, press Ctrl+1. Alternatively, go to Home and click the small dialog box launcher in the lower-right corner of the Alignment group. The shortcut opens the same formatting dialog without changing any cell values.
  5. Open the Alignment tab. In the Format Cells dialog, select Alignment. Find the Horizontal drop-down in the Text alignment section. Do not choose the separate Merge cells checkbox; that is the command this method avoids.
  6. Choose Center Across Selection. Open the Horizontal drop-down and select Center Across Selection. This setting aligns the first cell’s content in the center of the selected span. It is different from ordinary Center alignment, which centers text within each individual cell.
  7. Apply the setting. Click OK. The heading should now appear centered across the selected columns, while the cells remain separate. Click a cell in the range to check that Excel still identifies an individual cell rather than one combined area.
  8. Adjust the appearance if needed. Change the column widths, font, size, or bold formatting as usual. If the title looks off-center, confirm that you selected the intended columns and that the leftmost cell is the one containing the title. The visual center depends on the widths of all columns in the selection.
  9. Save and check the worksheet’s behavior. Save the workbook, then try selecting, copying, or navigating through the cells. You should still be able to work with each cell separately. If the selected span contains other entries, review their display and consider moving them before using the alignment on a heading row.

On a Mac: Select the range, open Format Cells with Command+1, then choose Alignment > Horizontal > Center Across Selection and click OK. The dialog layout may look slightly different from Windows, but the alignment option has the same purpose. In Excel for the web, open the file in the desktop app if the option is unavailable.

If you mean combine text rather than center it: put the result in a separate, empty cell so the original entries remain intact. With the words “North,” “Region,” and “Team” in A2:C2, enter this in D2: =TEXTJOIN(" ",TRUE,A2:C2). The result is North Region Team. This joins the text with spaces; it does not merge the source cells, and the formula result updates when the source values change.

Common Mistakes

Choosing Merge & Center by accident. The buttons are easy to confuse because they are both related to centering across columns. Merge & Center combines a range into one cell and can discard values in cells other than the upper-left cell. Center Across Selection changes alignment only. In the Format Cells dialog, choose the item in the Horizontal list and leave Merge cells unchecked.

Putting the heading in the wrong cell. Center Across Selection uses the leftmost cell’s content for a horizontal selection. If the title is in C1 but you select A1:D1, do not expect Excel to center C1 across the whole span. Move the title into A1, or select C1 and the cells to its right if that is the intended span.

Expecting separate cell values to combine. This setting does not concatenate text, add numbers, or create a single cell address. If several cells contain words you want to display together, use a formula such as TEXTJOIN in another cell. If they contain numbers, first decide whether you need a total, a joined text label, or simply a centered heading; those are different outcomes.

Using multiple rows for one title. Selecting A1:D3 does not make one centered title across a rectangle. It applies the horizontal alignment across each row, and each row’s leftmost cell is treated as that row’s content. For one heading, select only the one row that contains it.

Tips

Keep headings in a dedicated row with no underlying data in the cells they span. That makes the layout clearer and avoids confusion if someone later enters information in a cell that is part of the visual heading range. Center Across Selection preserves those entries, but their presence can make a heading harder to read.

Use Center Across Selection for presentation, not as a data-cleanup tool. Each cell remains an independent value location, which is helpful when you need to sort a table, use filters, copy a column, or refer to cells in formulas. Keep the actual data in a simple tabular layout, with one record per row and one field per column.

To remove the effect later, select the same range, open Format Cells, return to the Alignment tab, and choose General in the Horizontal list. Click OK. This changes the alignment; it does not clear the heading or alter the values in the cells.

If the heading needs a border or background, apply those formats to the selected cells separately. Center Across Selection does not create a larger cell, so each cell can still have its own border and fill. Apply the same fill across the range for a continuous band, and check the borders at column boundaries if you want a seamless appearance.

When joining text values, keep the originals and put the formula result elsewhere. This makes it easier to correct source entries and avoids replacing useful data. If a formula should display a different separator, change the first TEXTJOIN argument: for example, a comma and space can separate names. Check the resulting text for unwanted extra spaces or blank entries, especially when source cells are filled by other formulas.

Troubleshooting

Center Across Selection is missing from the list. Confirm that you are in the Format Cells dialog’s Alignment tab and viewing the Horizontal drop-down, not the vertical alignment options. If you are working in a browser and cannot see it, open the workbook in the Excel desktop app. The exact web controls can vary, and the desktop app provides the full Format Cells dialog for this method.

The heading stays at the left. Verify that the horizontal alignment really is Center Across Selection and that the entire intended range was selected before applying it. Also check that the text is in the leftmost cell. If the selected range is only one cell wide, there is no wider span across which to center the heading.

The heading appears shifted. The cells may have unequal widths, or you may have selected extra columns on one side. Select only the columns that should form the visual span. If the worksheet has hidden columns, unhide them or account for their widths when deciding what the visual center should be.

Some content looks hidden or overlaps. Centering does not remove other cell values, but text or numbers elsewhere in the range can interfere with how the row looks. Inspect each cell in the selected span, including cells that appear blank but may contain spaces or formulas. Move data to its proper row or column rather than clearing it blindly.

The formula displays an error or unexpected text. Check that the formula is in a different cell from the source values, that the referenced range is correct, and that you used ordinary straight quotation marks around the separator. For the example above, A2:C2 must contain the source entries; D2 contains the formula. If the cells are blank, TEXTJOIN may return an empty result because the formula’s second argument tells it to ignore empty cells.

Frequently Asked Questions

Does Center Across Selection merge cells?
No. It changes the horizontal alignment of the selected cells. Each cell remains separate, keeps its own address, and can still hold its own value.

Will it delete data from the other cells?
No. Unlike Merge & Center, Center Across Selection does not discard values. However, values in the span can make the displayed heading confusing, so check the row before applying it.

Can I use this for a vertical range?
It is intended to center content horizontally across selected cells in a row. For a title across columns, select a single horizontal range. It does not center one value vertically across several rows.

Can I sort or filter cells formatted this way?
The cells are not merged, so this avoids a common obstacle caused by merged cells in sortable or filterable data. Still, keep decorative headings outside the body of a data table; a heading row inside the data can interfere with sorting and filtering for other reasons.

How do I combine values instead of centering one heading?
Use a formula in a separate cell, such as TEXTJOIN, with the source range and the separator you want. The formula creates a combined text result while the original cells stay independent; it does not create a merged cell.

Can I do this in Excel for the web?
The available alignment options can differ in the browser. If Center Across Selection is not offered in the web version you are using, choose Open in Desktop App and apply the setting through Format Cells on Windows or Mac.

Related

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.