Center in Excel Without Merging Cells: A Step-by-Step Guide

How-to basics · Updated November 20, 2026

To center a heading across several Excel columns without merging them, select the cells in one row, open Format Cells with Ctrl+1, choose the Alignment tab, set Horizontal to Center Across Selection, and select OK. The heading stays in the first cell, while the selected cells remain separate and editable. For centering text inside just one cell, select that cell and choose Home > Center.

What You’ll Need

  • A workbook open in Excel for Microsoft 365 on Windows. The Center Across Selection setting is available in the desktop Format Cells dialog.
  • A row of adjacent cells for the heading or label. For example, select B2:F2 to center a heading over five columns.
  • Any text or number you want to center entered in the leftmost cell of that selected range. The other cells in the range should be blank for the cleanest result.

If you are using Excel for Mac, the same alignment setting is in the Format Cells dialog; use Command+1 to open it. Excel for the web does not provide Center Across Selection, so open the workbook in the desktop app to use this method. You can still use the web version’s ordinary horizontal center alignment for content within individual cells.

Step-by-Step

  1. Enter the heading in the first cell. Type the heading in the leftmost cell of the area you want it to span. For example, if the heading should sit above columns B through F, type it in B2. Do not spread the heading across several cells, and do not put it in the middle cell: Center Across Selection uses the leftmost cell as the source.
  2. Select the cells that define the centering area. Drag across the cells in the same row, or click the first cell, hold Shift, and click the last. For the example, select B2:F2. This selection tells Excel the width over which to position the text. Select only the cells that belong to the heading area, not entire columns or neighboring rows that contain unrelated data.
  3. Open the Format Cells dialog. On Windows, press Ctrl+1. Alternatively, go to Home and select the small dialog box launcher in the lower-right corner of the Alignment group. On a Mac, press Command+1 or open Format Cells from the formatting menus. If you use the ribbon launcher, make sure the Alignment tab is visible in the dialog before continuing.
  4. Choose the horizontal alignment option. In the Format Cells dialog, select the Alignment tab. Open the Horizontal dropdown and choose Center Across Selection. This is different from Center: Center aligns content within each cell, while Center Across Selection centers the content from the leftmost cell across the selected range. Do not choose Merge & Center.
  5. Apply the setting. Select OK to close the dialog. The heading should now appear visually centered across the selected cells. Click the heading area to confirm that the cells have not become one merged cell; the separate cell grid and column boundaries remain intact.
  6. Check the underlying value. Select the leftmost cell, such as B2, and look at the formula bar. The heading should still be stored in that cell alone. The other selected cells remain blank, so each can still be used for its own entry, formula, or formatting later.
  7. Adjust the appearance if needed. You can use the usual font, fill, border, and number-format controls while keeping the cells separate. To make the heading stand out, select the same range and apply a fill or a bottom border. If you also want it vertically centered within a taller row, open Format Cells again, select Alignment, and choose Center in the Vertical dropdown.

For a regular table where every cell already has its own content, use ordinary center alignment instead. Select the cells whose contents should be centered, then go to Home > Center in the Alignment group. That command centers each cell’s own contents; it does not position one heading across a group of cells. This distinction matters when a heading spans multiple columns but the data below it must remain independently sortable and editable.

Common Mistakes

  • Choosing Merge & Center by habit. Merge & Center combines the selected cells into one larger cell. It can make sorting, filtering, selecting, and copying ranges less convenient, and Excel keeps only the upper-left cell’s content if several selected cells contain data. Center Across Selection changes alignment without combining cells.
  • Putting the heading in the wrong cell. Center Across Selection uses the content in the leftmost selected cell. If the text is in a cell farther to the right, it may not center as expected. Move the heading to the first cell in the range, then apply the alignment setting again.
  • Selecting cells that contain other values. The method is meant to display the leftmost cell’s content across a range, not to center several separate entries together. Keep the cells to the right of the heading empty if you want a clear heading across the whole area. If they contain data, preserve that data and use a different layout rather than clearing cells just to make the effect work.
  • Selecting multiple rows for one heading. Center Across Selection operates across the selected cells in each row. If you select a block several rows tall, the setting may apply row by row rather than create one centered heading across the whole block. Select only the single row where the heading belongs.
  • Expecting the text itself to move to another cell. The displayed position changes, but the value remains in the leftmost cell. This is intentional: formulas, references, and editing still use that cell. Do not mistake the visual centering for a change in where Excel stores the text.

Tips

  • Use it for headings, not for every table cell. Center Across Selection is especially useful for report titles, section labels, and column-group headings above a table. For ordinary data, apply center alignment to each relevant cell instead. This keeps the visual layout understandable and the data structure practical.
  • Keep the selection as narrow as the heading. If a heading describes columns B through E, select B:E in its row, not the entire worksheet width. A carefully sized area makes the centering predictable and reduces the chance of the title appearing oddly placed when the sheet is printed.
  • Plan the heading row before adding data. Leave the cells to the right of the title blank in that row, and put the table’s actual column labels on the next row. This lets the title span the table visually without taking away cells needed for data entry.
  • Use borders and fill separately. Alignment does not add a background or outline. Select the full heading range to apply a fill or border across it, even though the heading text is stored only in the first cell. Check that the styling matches the worksheet’s other section headings.
  • Remember that centering depends on the selected range. If you insert or remove columns, the title may no longer span the intended area. Re-select the updated range and reapply Center Across Selection if necessary. The setting is formatting, so changing the range does not move or rewrite the heading.
  • Use ordinary Center for a single cell. If you only need a label centered in one cell, select the cell and use Home > Center. There is no need to open Format Cells for a simple one-cell alignment change.

Troubleshooting

  • Center Across Selection is missing from the dropdown. Confirm that you opened the desktop Format Cells dialog and selected the Alignment tab. The setting is not the same as the Center button on the ribbon. If you are in Excel for the web, open the file in the desktop Excel app; the web app does not offer this specific option.
  • The text stays at the left or appears off-center. Check that the text is in the leftmost cell of the selected range, that you selected the intended cells in one row, and that cells to the right are blank. Also verify that Horizontal is set to Center Across Selection rather than General, Left, or Center. Reopen Format Cells and apply the setting again if needed.
  • The text appears cut off. Check whether the row is too short or the columns are too narrow for the heading. Increase the width of the selected area or reduce the font size. Wrap Text can change how a heading displays within a cell, so turn it off if it produces an unwanted line break. Avoid using Shrink to fit unless reducing the text size is acceptable.
  • The effect disappears after changing the sheet. If you insert columns, change the range, or copy formatting from another area, the alignment may no longer cover the intended cells. Select the new range and choose Center Across Selection again. If the heading was pasted from another workbook, check its alignment setting in Format Cells rather than relying on how it looks at first.
  • The cells seem to behave like one cell. Center Across Selection should not merge cells. If the Merge & Center button is highlighted or the selection behaves as one cell, use the dropdown beside Home > Merge & Center and choose Unmerge Cells. Then select the intended range and apply Center Across Selection. Before unmerging, check for content that might have been discarded earlier; unmerging cannot restore values that were removed during a merge.

Frequently Asked Questions

Does Center Across Selection merge cells?
No. It changes the horizontal alignment of the content in the leftmost cell across the selected range. The cells remain separate, so they can still be selected, formatted, and used individually.

Can I center a heading across columns when the cells to the right contain data?
Not cleanly with this method. The heading is displayed from the first cell across the selection, so neighboring entries can interfere with the appearance. Keep the heading range blank apart from its first cell, or redesign the heading and data layout rather than deleting existing values.

Can I use Center Across Selection vertically?
No. It is a horizontal alignment option that works across cells in a row. To center content vertically within a cell or selected range, use the Vertical dropdown on Format Cells’ Alignment tab and choose Center.

Will the heading still work with sorting and filtering?
The cells remain unmerged, which avoids a common obstacle caused by merged cells in data ranges. Keep the heading outside the rows being sorted or filtered, and use a proper header row for the table itself. Center Across Selection does not turn a heading into a table header.

Can I use this in Excel for the web?
Excel for the web does not include the Center Across Selection option in its alignment controls. Open the workbook in desktop Excel for this effect. In the browser, you can center text within a cell using the available horizontal alignment button.

What should I use if I just want text centered inside one cell?
Select the cell and choose Home > Center. That centers the cell’s own content horizontally. If you also want it centered top to bottom, choose Home > Middle Align in the Alignment group.

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.