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

How-to basics · Updated November 20, 2026

To make a heading span several Excel cells without combining them, select the cells, open Format Cells with Ctrl+1, choose the Alignment tab, and set Horizontal to Center Across Selection. The cells remain separate, so each can still hold its own value. If by grouping you mean collapsing rows or columns, use Data > Group instead; that creates an outline, not a merged cell.

These are two different jobs, and choosing the right one matters. Center Across Selection changes how a cell’s contents appear. Group creates expandable and collapsible sections of rows or columns. The steps below show how to use both in Microsoft Excel for Microsoft 365 on Windows, and explain what to do if your Excel version or layout differs.

What You’ll Need

  • An Excel workbook and a clear idea of whether you want a heading to span cells or a section of rows or columns that can be collapsed.
  • For a heading across cells, plan to put the heading text in the leftmost cell of the selection. Keep the other selected cells empty if you want the text to display cleanly across them.
  • For an outline group, arrange the worksheet so the rows or columns you want to collapse are together. A summary row or column outside the detail makes the outline easier to use.

Step-by-Step

Option 1: Center a heading across cells without merging

  1. Choose the cells the heading should span. For example, if a report title should sit above columns A through D, select A1:D1. Select cells in one row for a horizontal heading; this setting is for alignment, not for making a multi-row block into one cell.
  2. Enter the heading in the leftmost cell. In the example, type the title in A1 and leave B1:D1 empty. If the text is already in another cell, move or copy it into the leftmost cell before applying the alignment. Center Across Selection does not combine the contents of several cells.
  3. Open the Format Cells dialog. Press Ctrl+1 on Windows, or right-click the selection and choose Format Cells. On a Mac, use Command+1 or open Format Cells from the menu, depending on your keyboard and Excel version.
  4. Open the Alignment tab. In the Format Cells dialog, select Alignment. Find the Horizontal dropdown in the Text alignment area. Do not choose Merge & Center on the ribbon; that is a different command and merges the selected cells.
  5. Choose Center Across Selection. Open the Horizontal dropdown, select Center Across Selection, and click OK. Excel centers the value from the leftmost cell across the selected range while keeping each cell independent.
  6. Check the result and the underlying cells. Click A1 and look at the formula bar to confirm the title is still in A1. Click B1, C1, or D1 to verify those cells are still separate and available for data. You can also enter a test value in one of them, then undo the test if you do not want to keep it.
  7. Format the heading if needed. Apply a font, fill, border, or number format using the Home tab. These formatting choices do not merge cells. If you later change the selected range, repeat the alignment steps with the new range.

This method is useful for report titles, section labels, and print layouts where you want a centered heading above several columns. It is not a general-purpose way to make several cells behave as one: formulas, sorting, and data entry still treat each cell separately.

Option 2: Group rows or columns so they can be collapsed

  1. Identify the detail to collapse. For example, suppose rows 5 through 12 contain monthly detail and row 13 contains a total. Decide whether the total should remain visible when the details are hidden. A summary outside the detail range is usually easier to read and manage.
  2. Select the rows or columns themselves. To group rows 5 through 12, select their row numbers along the left edge of the worksheet. To group columns, select the column letters at the top. Selecting whole rows or columns makes your intention clear and reduces the chance of grouping the wrong part of the sheet.
  3. Apply the Group command. On the ribbon, choose Data > Group. If Excel asks whether to group Rows or Columns, choose the appropriate option and confirm. You can also use Alt+Shift+Right Arrow on Windows to group the selected rows or columns. Ribbon labels and shortcut behavior can vary slightly by platform and keyboard setup.
  4. Use the outline control to collapse the detail. Excel adds an outline bracket and a minus sign beside the grouped rows or above the grouped columns. Click the minus sign to hide the grouped detail. The control changes to a plus sign; click it to expand the group again.
  5. Check that the right rows or columns are included. Expand the group and inspect its boundaries. If the summary row was accidentally included, ungroup the selection and create the outline again with the corrected range. The cells have not been merged; grouping only changes whether rows or columns are shown.
  6. Create another group if the worksheet has separate sections. Select the next block of rows or columns and use Data > Group again. For nested outlines, group smaller detail sections first, then group the larger range if needed. Expand and collapse each level to make sure the outline controls match the structure you intended.

On Excel for Mac, use the Data tab’s Group command where available; keyboard shortcuts differ by keyboard and version, so the ribbon is the dependable route. Excel for the web may offer fewer outline controls than the desktop app. If you cannot find Group or the outline buttons, open the workbook in desktop Excel and make the structural change there.

Common Mistakes

  • Using Merge & Center by accident. Merge & Center combines selected cells into one cell and can discard all but the upper-left cell’s content. For a heading that should remain in separate cells, use Format Cells > Alignment > Horizontal > Center Across Selection.
  • Expecting Center Across Selection to combine text. It aligns the contents of the leftmost cell; it does not join values from other selected cells. Put the heading in the first cell and preserve any other data elsewhere before formatting.
  • Putting data in the cells beside a spanning heading. Other values remain in their cells, but they can prevent the heading from appearing as expected or make the row visually confusing. Keep the rest of the selected heading range empty, or choose a smaller range.
  • Selecting the wrong outline range. If you include a total or heading row in a group, it may disappear when you collapse the detail. Select only the rows or columns that should hide and keep summaries outside the group when practical.
  • Confusing hidden rows with grouped rows. Manually hiding rows does not create an outline bracket with plus and minus controls. Use Data > Group when you want a repeatable, expandable section.
  • Assuming grouping changes the data. An outline is a display control, not a calculation or a new data structure. Hidden detail still exists in the worksheet and may affect formulas, charts, or other features.

Tips

  • Use Center Across Selection for layout, not data modeling. It is handy for presentation headings, but avoid using a spanning heading as a substitute for a clear table structure. Keep one record per row and one field per column in data that you will sort or filter.
  • Make summary rows obvious. Add a label such as Total or Subtotal and use a border or bold type. Keep that row outside the detail group if readers should still see it after collapsing the section.
  • Use outline levels deliberately. A worksheet can have multiple levels of row or column groups. Start with a small section, test the plus and minus controls, and then add broader groups only if they make navigation simpler.
  • Look for existing groups before adding more. Outline brackets and numbered level buttons near the worksheet edges indicate that groups may already exist. Expand the outline and inspect it before applying another group, which could create confusing nested levels.
  • Plan for printing and sharing. Center Across Selection preserves separate cells, but it does not change column widths or page scaling. Grouped rows that are collapsed may print differently from expanded rows, so check Print Preview and the worksheet state before distributing a report.
  • Use a clear file structure. If other people will edit the workbook, label summary rows and explain what the outline controls hide. That makes the worksheet easier to understand without relying on merged cells or unexplained hidden data.

Troubleshooting

  • The heading does not look centered. Confirm that the selection is one continuous row and that Center Across Selection is set in Format Cells > Alignment. Make sure the heading is in the leftmost selected cell and the other cells in the span are blank. Widen the columns or reduce the font size if the text still does not fit visually.
  • The Center Across Selection option is hard to find. Open the Format Cells dialog with Ctrl+1 on Windows, then check the Alignment tab’s Horizontal dropdown. It is not the same as the horizontal Center button on the Home tab, which centers text within each individual cell.
  • The rows will not group. Select row numbers rather than only a few cells, then choose Data > Group. Check whether the worksheet is protected; protection can prevent structural changes. If the command is unavailable, review the workbook’s protection and sharing settings or try the desktop app.
  • The group hides the wrong rows. Click the plus sign to expand it, select the intended row or column headers, and choose Data > Ungroup. Then select the correct range and group it again. On Windows, Alt+Shift+Left Arrow can ungroup a selected outline, though using the ribbon is clearer if the shortcut is intercepted.
  • The outline buttons or brackets are missing. The group may not exist, may have been removed, or outline symbols may be hidden in Excel’s settings. Look for outline level buttons near the row and column headings. If you are working in a browser or on a restricted worksheet, open the file in desktop Excel and check the Data tab and protection state.
  • Collapsing the group hides the total too. Expand the group and recreate it without the summary row, or change the row arrangement so the total sits outside the detail range. Check the outline settings if Excel has automatically placed summary rows in an unexpected position.

Frequently Asked Questions

Can I group individual cells in Excel without merging them?
Not with the Data > Group command. That command groups whole rows or columns to create an outline. For a heading that visually spans adjacent cells, use Center Across Selection; the cells remain distinct.

Is Center Across Selection the same as Merge & Center?
No. Center Across Selection changes alignment while preserving separate cells and their contents. Merge & Center combines the selected cells into one and may remove contents in cells other than the upper-left one.

Can I type separate values into cells formatted with Center Across Selection?
Yes. Each cell remains available for its own value. However, values in neighboring cells can interfere with the appearance of a spanning heading, so use the setting for a row where the other selected cells are intended to be empty.

Can I group columns as well as rows?
Yes. Select the column letters you want to collapse and choose Data > Group. Excel adds outline controls above the columns. Use the plus and minus controls to expand or collapse the group.

Will grouped rows be deleted when I collapse them?
No. Collapsing hides the rows from view; it does not delete their contents. Expand the outline to show them again. Hidden detail can still matter to formulas and other workbook features.

Can I sort or filter a range that uses Center Across Selection?
The cells remain separate, but the alignment format does not make a range into a table or a single data field. For reliable sorting and filtering, use a standard tabular layout with one header per column and avoid spanning headings inside the data rows.

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.