Center in Excel Without Merging: A Practical Guide

How-to basics · Updated November 20, 2026

To center a heading across several Excel columns without merging cells, select the range, open Format Cells with Ctrl+1, choose the Alignment tab, and set Horizontal to Center Across Selection. This centers the text across the selected cells while keeping each cell separate, so the range remains easier to sort, filter, copy, and edit.

The steps below are for Excel for Microsoft 365 on Windows. You will need a heading or other text in the leftmost cell of the range and blank cells to its right. The feature is in Excel’s desktop Format Cells dialog; if Excel for the web does not show the option, open the workbook in the desktop app.

What You’ll Need

  • An Excel workbook open in the desktop version of Excel for Microsoft 365.
  • Text in the first cell of the range you want to center, such as a report title in B2.
  • A range of adjacent cells, such as B2:F2. The cells to the right of the text should be empty for the cleanest result.

Step-by-Step

  1. Put the heading in the first cell. Enter the heading in the leftmost cell of the range you intend to use. For example, put Quarterly Sales Report in B2 if you want it centered across B2:F2. The setting uses the text in the first cell of the selected range; it does not combine text from several cells into one heading.
  2. Select the full span of columns. Click and drag from the cell containing the heading through the last cell that should contribute to its centered width. For the example, select B2:F2. Include every column you want the title centered across, and avoid selecting extra columns that do not belong to the heading area. You can also click B2, hold Shift, and click F2.
  3. Open Format Cells. Press Ctrl+1 on Windows. In the dialog, select the Alignment tab. You can also right-click the selected range and choose Format Cells, then open Alignment. Do not use Home > Merge & Center; that command merges cells, which is what this method avoids.
  4. Choose the horizontal alignment option. Find the Horizontal dropdown in the Text alignment section. Open it and select Center Across Selection. This is different from choosing Center: ordinary Center aligns text within its own cell, while Center Across Selection positions the first cell’s text across the selected range.
  5. Apply the setting. Click OK to close Format Cells. The heading should now appear centered over the width of the selected cells. The grid still contains the same individual cells, and you can click each one separately.
  6. Check the appearance and adjust the range if needed. If the title seems slightly off-center, verify that you selected the intended columns and that the cells to the right of the heading are empty. A long heading may need wider columns, a smaller font, or a wider selected span. Adjust the column widths or selection, then reopen Format Cells and reapply the alignment if necessary.
  7. Repeat for other headings. Apply the method to each title row separately, or select matching ranges in more than one row when appropriate. For a simple, predictable layout, format each heading row on its own: select that row’s title span and set Center Across Selection. This does not copy the text or merge the rows.

On a Mac, the Format Cells dialog is also available with Command+1, and the alignment choice is on its Alignment tab. Ribbon labels and dialog layout can vary slightly by Excel release, but look for the Horizontal alignment dropdown and Center Across Selection. In Excel for the web, alignment choices can differ from desktop Excel; if the option is unavailable, use Open in Desktop App rather than substituting Merge & Center.

Common Mistakes

  • Choosing Center instead of Center Across Selection. Center applies alignment inside each cell. It will not center a heading across several separate columns. Reopen Format Cells and choose the full Center Across Selection option from the Horizontal list.
  • Using Merge & Center by habit. Merge & Center combines the selected cells into a larger cell. Center Across Selection changes alignment only, so use the latter when separate cells must remain available for data entry, sorting, or formulas.
  • Putting the heading in a cell other than the range’s left edge. The feature is intended to center the contents of the first cell in the selected span. If the heading is in C2 but the selected range starts at B2, move the heading to B2 or select a range beginning at C2.
  • Leaving other values in the selected cells. Center Across Selection does not erase or combine neighboring cell contents. Existing values can interfere with the visual result or be hidden by the heading. Keep the rest of the title span blank, or choose a different layout if those cells contain data that must remain visible.
  • Selecting too few or too many columns. The selected range defines the width used for the visual centering. If the heading looks off relative to the page or table, check the left and right boundaries of the selection.

Tips

  • Use a dedicated title row. Keep the heading in one cell and leave the remaining cells in its span empty. Put column labels and records on the rows below. This separates presentation from the underlying table data.
  • Choose the span intentionally. If a heading describes columns B through F, use B:F rather than centering it over the entire worksheet. A title centered over the relevant table is easier to read and remains visually connected to that section.
  • Keep a consistent layout. Use the same start and end columns for related headings. If several report sections share a width, applying the same alignment and font styling to each title row makes the sheet look orderly.
  • Use other formatting separately. Center Across Selection controls horizontal positioning; it does not set font size, bold, fill color, borders, or vertical alignment. Apply those choices independently from the Home tab or the Format Cells dialog.
  • Remember that alignment is formatting, not data. You can still select, edit, or reference the cells individually. The title remains stored in its original cell, so formulas that refer to that cell can continue to work.
  • Consider print layout. If the title should be centered on a printed page rather than only across table columns, check the print preview as well. Center Across Selection follows the chosen cells’ widths; it does not automatically center a title on the printed page.

Troubleshooting

The title did not move. Confirm that the setting was applied to the whole range, not just the cell holding the text. Select the range again, press Ctrl+1, and check Alignment > Horizontal. Center Across Selection should be the selected option. If the range starts in a blank cell to the left of the title, adjust the selection or move the title to the first cell.

The option is missing from the list. Make sure you are using the desktop Excel app and the Format Cells dialog, not only the quick alignment buttons on the Home tab. Excel for the web may not provide every desktop alignment choice. Open the workbook in the desktop app and check the Horizontal dropdown on the Alignment tab.

The heading appears left-aligned or is cut off. Check whether the text is in the range’s first cell and whether another cell in the selected span contains content. Also inspect column widths and the text length. Widen the columns, shorten the heading, or reduce the font size if the available span is too narrow. Do not assume the text has disappeared: it remains in the cell even if the display is constrained.

The setting seems to affect more than one row. If you selected multiple rows, the alignment can apply to the selected cells row by row. For a single title, select only that row’s horizontal span. For several separate headings, format each row deliberately and confirm that each heading is in the leftmost cell of its own span.

The title is centered over the wrong area after changing column widths. Center Across Selection uses the current boundaries and widths of the selected cells. If columns are resized or the intended title area changes, select the new range and apply the setting again. Check the result in Normal view and in print preview if the sheet is meant to be printed.

Frequently Asked Questions

Does Center Across Selection merge cells?

No. It changes horizontal alignment only. The selected cells remain separate, so you can still select, edit, format, and reference them individually.

Can I center text across several rows at once?

You can apply the alignment to a multirow selection, but each row is treated as its own horizontal span. For a clear result, place each row’s heading in that row’s leftmost selected cell and leave the rest of that row’s span empty. Select only the rows you intend to format.

Can I use this for a heading above a data table?

Yes. Put the heading in the first cell above the table, select the cells spanning the table’s columns, and choose Center Across Selection. Keep the other cells in that title row empty so their contents do not compete with the heading.

Will formulas or sorting stop working?

The alignment setting does not combine cells or change their contents, so formulas can still reference the individual cells. Sorting and filtering are generally easier to manage with separate cells than with merged cells, though the heading row should not be included as part of a data range if it is not a record.

How do I undo the alignment?

Select the formatted range, press Ctrl+1, open Alignment, and change Horizontal to General or another alignment you prefer. You can also use Undo immediately after applying the setting. On a Mac, use Command+1 to reopen Format Cells.

Why not just use the Center button on the Home tab?

The Center button centers text inside each individual cell. It does not treat a group of columns as one visual span. Center Across Selection is the specific horizontal alignment option for centering a cell’s text across adjacent unmerged cells.

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.