Excel Text Across Cells Without Merging

To center text across several Excel cells without merging them, enter the text in the leftmost cell, select that cell and the empty cells beside it, then choose Format Cells > Alignment > Horizontal > Center Across Selection. The cells stay separate, so their values, borders, and column structure remain independent.

What “text across cells” means in Excel

People often say they want text to “span” or “go across” cells when they are formatting a heading above a table. Usually they want the heading to look centered over several columns, not to turn those columns into one large cell. Excel’s Center Across Selection alignment is designed for that visual effect: it centers the entry in the first cell across the selected horizontal range while leaving the underlying cells intact.

For example, you might want “Quarterly Sales” centered over columns B through E. Put that heading in B2, select B2:E2, and apply Center Across Selection. The heading appears centered over the selected width, but B2, C2, D2, and E2 are still distinct cells. You can still select them individually, apply different borders, or use them as separate columns in a table.

This is a formatting choice, not a way to distribute text or join multiple cell values. The text remains stored in its original cell. If you need to combine the actual contents of cells, use a formula or another data-combination method instead.

How to center text across cells without merging

Enter the heading or label in the leftmost cell of the range. For a heading over B through E, enter it in B2.
Select the full range that the heading should appear centered over, such as B2:E2. Keep the other cells in that row empty for the cleanest result.
On Windows desktop Excel, open the Home tab and click the small dialog box launcher in the Alignment group. You can also right-click the selection and choose Format Cells.
In the Format Cells dialog, open the Alignment tab. Under Horizontal, choose Center Across Selection, then click OK.

The ordinary Center button on the Home tab is not the same setting: it centers text inside each cell. Center Across Selection treats the selected cells as a visual span for the first cell’s entry. To undo the effect later, select the cells, open Format Cells again, and choose a different Horizontal alignment option, such as General or Center.

How the alignment behaves

Center Across Selection is horizontal alignment. It does not make text vertically span a block of cells, and it does not create a single cell with a larger address. Select a range in one row for a typical column heading. If you select several rows, Excel applies the alignment across the selected columns separately on each row; it does not center one entry over the entire rectangular block.

The first cell is where the entry is stored. In the B2:E2 example, B2 contains “Quarterly Sales”; C2, D2, and E2 remain their own cells. If you click one of those other cells, the formula bar shows that cell’s own contents, not a copy of the heading. This is useful when later formulas, sorting, or data-entry processes depend on the original columns remaining separate.

Leave the neighboring cells blank when possible. If a cell in the selected span contains another value, that content can interfere visually with the centered heading. Center Across Selection does not erase those values to make room. Check the selected row before applying the format, especially in a worksheet that already contains data.

Center Across Selection versus Merge & Center

Merge & Center is a different command. It combines selected cells into one larger cell and centers the remaining entry in that merged area. Merging can complicate selecting ranges, sorting, filtering, copying data, and using some table layouts, because the worksheet no longer has the same independent cells in that location. If multiple selected cells contain entries, Excel may warn that merging keeps only the upper-left cell’s content and discards the others.

Center Across Selection changes alignment only. It is often the safer choice for a heading over columns that still need to function as separate worksheet fields. It also avoids changing the worksheet’s cell structure just to achieve a visual effect. However, it does not make the heading part of every column, and it will not make a long heading fit if the selected range is too narrow; it only positions the text across the chosen width.

Merge & Center can still be appropriate for a simple presentation sheet where a true combined cell is intended and the range will not need to behave like a regular data grid. The choice depends on whether the cells need to stay individually usable. For a report built on sortable or filterable columns, keeping cells separate is generally more flexible.

Common problems and how to fix them

The heading stays at the left. Confirm that you selected the full range, including the cell containing the text, and chose Center Across Selection in the Format Cells dialog. The standard Center alignment does something different.
The heading appears interrupted or crowded. Look for values in the cells to the right of the text. Center Across Selection does not clear neighboring cells; move or remove conflicting entries only if appropriate for the worksheet.
The text is not centered over the columns you expected. Check the selected range. Excel centers across the cells you selected, so including an extra column or omitting one changes the visual midpoint.
The heading is clipped. Increase the width of the selected columns, shorten the heading, or use a different layout. Center Across Selection does not automatically wrap the heading across the range as a single combined text area.
The option is hard to find. Open Format Cells and inspect the Horizontal list on the Alignment tab. Do not confuse it with the horizontal alignment buttons on the ribbon.

After applying the format, click the cells around the heading and inspect their values if the worksheet is important. The alignment setting should not remove cell contents, but confirming that the intended cells were selected helps catch accidental formatting or edits.

When text overflow or a formula is a better fit

If you only want a left-aligned label to continue visually into empty cells, you may not need Center Across Selection. With the usual General alignment, text can appear to extend into adjacent blank cells when there is room. This is simple, but it is not centered over a group of columns, and the display stops where another cell contains data. Center Across Selection is the better match when the goal is a centered heading over a defined range.

If the goal is to join words or values into one actual text result, use a formula instead. With “North” in A2 and “Region” in B2, enter this in C2: =A2&" "&B2. It returns North Region in C2. That result is stored or calculated in C2; it does not visually span A2:B2. Choose the formula approach when the combined text needs to be used elsewhere, rather than simply displayed as a heading.

Wrapping text is another distinct option. Wrap Text places a cell’s text on multiple lines within that cell, usually increasing the row height. It does not center a heading across neighboring columns. Use it for long labels that should remain inside one cell, and Center Across Selection for a short label that should sit over several columns.

Formatting and worksheet design considerations

Center Across Selection controls alignment; it does not apply a heading style by itself. You can format the text with bold, a font size, or a fill color separately. You can also apply borders to the individual cells in the range, which is one practical benefit of leaving them unmerged. For a clean heading, select the same range for alignment and apply any desired formatting consistently.

Keep the heading’s location predictable. A heading in the first cell of a selected range is easiest to maintain because that is where the text resides. If someone later inserts columns, changes the selected range, or edits the original cell, the displayed centering may need to be reviewed. When documenting a workbook for other users, explain that the apparent span is alignment rather than a merged cell.

For data tables, reserve this kind of presentation formatting for labels and headings rather than the body of the data. A regular column should generally have one field per cell and a clear header row. Visual formatting can make a worksheet easier to read, but it should not obscure the underlying cell-by-cell structure.

Excel versions and platform differences

The steps above apply to Excel for Microsoft 365 on Windows. In Excel for Mac, select the range and open the Format Cells dialog from the Format menu or the cell’s context menu; then look on the Alignment tab for the Horizontal setting. Keyboard shortcuts can differ by keyboard and Excel platform, so using the menu is a reliable alternative when a shortcut does not open the dialog.

Excel for the web has a more limited set of formatting controls than the desktop application, and the Center Across Selection option may not be available in its interface. If you cannot find it, open the workbook in the desktop app and apply the alignment there. The workbook can then retain the formatting when opened elsewhere, though the visual result can depend on the application’s support and rendering.

Frequently Asked Questions

Does Center Across Selection merge cells?
No. It changes horizontal alignment only. The selected cells remain separate and can still hold separate values, formulas, and formatting.

Which cell should contain the text?
Put it in the leftmost cell of the selected horizontal range. For a heading over B2:E2, enter the text in B2, then select B2:E2 before applying the alignment.

Can I use Center Across Selection if the other cells contain data?
You can apply the alignment, but existing entries remain in place and may conflict with the heading’s display. For a clear heading, use a range whose neighboring cells are empty.

Why is Center Across Selection preferable to Merge & Center?
It gives a similar centered-heading appearance without turning the selected cells into one merged cell. That helps preserve separate cells for data entry, formulas, and many worksheet operations.

Can I center text across cells in Excel for the web?
The web app may not show this desktop alignment option. If it is missing, use Excel for Microsoft 365 on Windows or Excel for Mac to set Center Across Selection.

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.