Center Align in Excel Without Merging Cells: How To

How-to basics · Updated November 20, 2026

To center a heading across several Excel columns without merging them, select the cells, press Ctrl+1 on Windows, open the Alignment tab, and choose Center Across Selection from the Horizontal list. This centers the text visually while leaving every cell separate, so you can still select, sort, and work with the cells independently.

This is useful for worksheet titles and section headings when Merge & Center would interfere with later editing or data handling. The steps below are for Microsoft Excel for Microsoft 365 on Windows. Excel for Mac has the same Format Cells option, although its keyboard shortcut differs.

What You’ll Need

  • A desktop version of Excel with the workbook open.
  • A row of adjacent cells to use as the width of the centered heading.
  • Text in the leftmost cell of that range. For the cleanest result, leave the other selected cells in that row blank.

Step-by-Step

  1. Enter the heading in the first cell. For example, type Quarterly Sales Report in A1. Center Across Selection uses the value in the leftmost cell of the selected range; it does not combine text from several cells.
  2. Decide how wide the heading should appear. If the report spans columns A through D, select A1:D1. You can drag across the cells with the mouse or click A1, hold Shift, and click D1. Include only the columns that should contribute to the centered area.
  3. Open Format Cells. With the range selected, press Ctrl+1 on Windows. Alternatively, go to Home and, in the Alignment group, select the small dialog box launcher at the group’s lower-right corner. The Format Cells dialog opens.
  4. Choose the Alignment tab. This tab contains the horizontal and vertical alignment settings, along with options such as text wrapping and text orientation. You only need to change the horizontal setting for this task.
  5. Open the Horizontal list. Select its dropdown menu and choose Center Across Selection. Do not choose Center, which centers the value inside only its own cell, or Merge & Center, which combines the selected cells.
  6. Apply the setting. Select OK to close the dialog. The heading in A1 should now appear centered across the selected A1:D1 area. The cells have not been merged: click A1 and the text remains in that cell, while B1, C1, and D1 remain separate blank cells.
  7. Check the result at the worksheet’s normal zoom. Confirm the heading looks centered over the intended columns and that it does not run into nearby content. If necessary, adjust the selected columns’ widths or select a wider or narrower range and apply the alignment again.
  8. Repeat for other headings as needed. Apply the setting to each heading range separately. If you select A1:D3, Excel applies the alignment row by row: the contents in the leftmost cell of each row can be centered across the selected columns in that row. Make sure other cells in those rows do not contain values that would conflict with the heading.

On a Mac, select the range and press Command+1 to open Format Cells, then choose Alignment and set Horizontal to Center Across Selection. You can also open the dialog from the ribbon. The labels may be arranged slightly differently depending on the Excel release, but the setting is still in the Alignment tab. If you use Excel for the web and cannot find this option in its formatting controls, open the workbook in the desktop app to apply it.

Common Mistakes

  • Choosing Center instead. The regular Center alignment positions text in the middle of its own cell. If the heading is in A1, it will not use the combined width of A1:D1. Choose Center Across Selection specifically.
  • Using Merge & Center by habit. Merging changes the cell structure and can make selecting, sorting, copying, or pasting ranges awkward. Center Across Selection provides a similar visual effect for a heading without turning the range into one merged cell.
  • Putting the heading in the wrong cell. The displayed text should be in the range’s leftmost cell. If it is in C1 and you select A1:D1, Excel will not treat the C1 value as the left-edge entry to center across the entire selection. Move the heading to A1 or select a range that starts at C1.
  • Leaving other values in the selected row. The other cells remain independent and keep their contents. Those values may block or interfere with the centered heading’s appearance. Keep the cells to the right of the heading blank in that row, or use a different layout if they need to contain data.
  • Selecting too many or too few columns. Excel centers across the range you selected, not automatically across the whole table. Check the column boundaries before applying the format.

Tips

Use Center Across Selection for short headings that sit above a set of columns, not as a way to format ordinary table entries. For example, if A1 contains Monthly Expenses and A1:F1 covers the six columns of a report, applying the setting makes the label appear centered over that section while preserving the separate column cells.

Keep the heading in the first cell even though it appears in the middle of the range. If you click a different cell in the selected area, the formula bar shows whether that cell has a value; the heading itself remains stored in the leftmost cell. This distinction matters when editing, copying, or referencing the worksheet later.

You can still format the selected cells independently after applying the alignment. For instance, you can change the heading’s font or apply a fill color to the whole heading band. The alignment setting does not merge cells or prevent you from selecting an individual cell. If you want to format the heading row, select the same range and use the appropriate controls on the Home tab.

For a multirow layout, apply the setting only when each row’s first cell contains the label intended for that row and the remaining cells in that row are clear. If your goal is a single title above a table, selecting a range in just that one title row is usually simpler and less likely to create confusing formatting.

Troubleshooting

  • The text still looks left-aligned. Reopen Format Cells and verify that Center Across Selection is selected in the Horizontal list. Also confirm that the text is in the leftmost cell of the range and that you selected the cells you meant to include.
  • The heading appears off-center. Check whether the range’s columns have different widths; the visual center is based on their total width, not on an equal number of columns. Also look for values in neighboring cells that may prevent the text from displaying as expected. Clear or move conflicting entries only if that is appropriate for your data.
  • The option is missing from the menu. Make sure you are in the Format Cells dialog’s Alignment tab and have opened the Horizontal dropdown. If the option is not available in Excel for the web, open the file in desktop Excel for Microsoft 365 or Excel for Mac and set it there.
  • You have already merged the cells. If you want the cells separate again, select the merged range and use Home > Merge & Center > Unmerge Cells. Check the result before proceeding: unmerging does not restore any values that were discarded when cells were originally merged. Then put the heading in the leftmost cell, select the intended range, and apply Center Across Selection.
  • The alignment seems to disappear after editing. Check whether you pasted formatting over the range or changed its alignment through another command. Reapply Center Across Selection from Format Cells. If the worksheet is protected, you may need permission to change cell formatting or to unprotect the sheet first.

Frequently Asked Questions

Does Center Across Selection merge cells?
No. It changes the horizontal alignment of the contents but keeps each selected cell separate. The heading’s value stays in the leftmost cell of the selected range.

What is the difference between Center and Center Across Selection?
Center aligns text within its own cell. Center Across Selection positions text across the width of a selected range of cells, without merging that range.

Can I use this for multiple rows at once?
Yes. Select a range covering the rows and columns, then apply the setting. Excel handles the alignment row by row, using the leftmost cell in each row. Check that other cells in those rows will not conflict with the displayed text.

Can I still sort or filter a table?
The cells remain unmerged, so this setting avoids the merged-cell structure that can complicate sorting. For best results, keep decorative headings outside the table’s data range and use the table’s own header row for field names.

How do I undo the setting?
Select the affected cells, open Format Cells > Alignment, and choose General or another horizontal alignment from the Horizontal list. This changes the alignment without changing the cell contents.

Will the setting work in Excel for the web?
Excel for the web can display many workbook formats, but its available formatting controls can differ from the desktop app. If Center Across Selection is not offered, open the workbook in desktop Excel to apply it.

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.