How to Make Sub-Columns Under a Main Column in Excel

Excel can’t split a column into smaller columns, but you can get the same look with two header rows. Put each sub-heading (Jan, Feb, Mar) in its own real column, then center the main heading (Q1) across the cells above them with Home > Merge & Center, or with Center Across Selection if you’ll sort or filter the data.

Your sales sheet needs one Q1 heading with January, February and March sitting neatly underneath it.

How Sub-Columns Work in Excel

Microsoft’s Merge and unmerge cells page is plain about it: you can’t split an individual cell. What looks like a column with smaller columns under it is really several ordinary columns with one wide label on top. In Lena’s sales sheet, that layout looks like this:

	A	B	C	D
Row 1		Q1 (spans B1:D1)
Row 2	Region	Jan	Feb	Mar
Row 3	North	4,200	3,950	4,610

Row 1 holds the main heading, row 2 holds the sub-headings, and the data starts in row 3. Every number still sits in its own column, which keeps formulas such as =SUM(B3:D3) simple.

Set Up the Sub-Columns

1. Make room for the sub-columns. If Q1 is a single column today, right-click the column letter to its right and choose Insert, once for each extra sub-column you need. To add several at once, select that many column letters first.
2. Make room for the main heading. If your headers are in row 1, right-click the row 1 number and choose Insert so you have an empty row above them.
3. Type the sub-headings in the lower header row: Jan in B2, Feb in C2, Mar in D2.
4. Type the main heading in the leftmost cell above them, B1. Leave C1 and D1 empty.

The main heading now sits over the first sub-column only. The next two sections stretch it across all three. If you’re new to adding columns, here’s how to insert a column in Excel.

Method 1: Merge and Center the Main Heading

Before you merge: Microsoft warns that when you merge cells, only the contents of the upper-left cell are kept (upper-right in right-to-left languages) and the rest are deleted. Make sure the heading is in B1 and that C1 and D1 are empty or hold nothing you need. Excel usually warns you before discarding other values, but don’t rely on it.

1. Select B1:D1, the cells above your sub-headings.
2. On the Home tab, in the Alignment group, select Merge & Center.
3. Check the result: B1:D1 is now one wide cell with Q1 centered over Jan, Feb and Mar.

The arrow next to Merge & Center offers the other options:

• Merge & Center: joins the cells and centers the text.
• Merge Across: merges each selected row separately instead of making one big cell, which helps when one selection covers several header rows.
• Merge Cells: joins the cells without centering.
• Unmerge Cells: splits a merged cell back into its original cells.

Repeat for each group. Lena types Q2 in E1 over Apr, May and Jun in E2:G2, then merges E1:G1. The full set of merge options and their side effects is in this explainer on merging cells in Excel.

Method 2: Center Across Selection

Center Across Selection gives the same centered heading without joining the cells. B1, C1 and D1 stay separate, so you avoid the sorting and selection problems merged cells cause. It’s the better pick for any sheet you’ll sort, filter or hand to someone else. Microsoft’s merge page doesn’t mention it; the option is in Excel’s Format Cells dialog.

1. Make sure the heading is in the leftmost cell (B1) and the cells to its right are empty.
2. Select B1:D1.
3. Press Ctrl + 1 (Command + 1 on a Mac), or select the small arrow in the corner of the Home tab’s Alignment group, to open Format Cells.
4. On the Alignment tab, open the Horizontal list and choose Center Across Selection.
5. Select OK.

Q1 now appears centered over the three columns, but clicking C1 shows an empty cell. It works across a row only, not down a column. To undo it, select the cells and set Horizontal back to General.

Make the Two-Row Header Easy to Read

• Borders: select B1:D2 and use Home > Borders > Outside Borders so each group reads as a block. A thick bottom border under row 2 separates headers from data.
• Column widths: narrow sub-columns look tidy, but numbers turn into #### if a column is too slim. Double-click the boundary between column letters to AutoFit, or use these AutoFit shortcuts for columns and rows. For identical widths, select the columns and choose Home > Format > Column Width.
• Fill and bold: shade the main heading row a little darker than the sub-heading row so the hierarchy is obvious.
• Keep both rows on screen: click A3, then View > Freeze Panes > Freeze Panes. Rows 1 and 2 stay visible as you scroll. More options are in this freeze panes walkthrough.

Sorting, Filtering and Tables With a Two-Row Header

Merged headings cause most of the trouble people hit later. Microsoft’s Find merged cells page notes that Excel won’t sort data in a column that contains merged cells. Some ways to stay out of trouble:

• Sort only the data. Select A2 down to the last data row (the sub-heading row plus data), then Data > Sort with My data has headers checked. Leaving row 1 out of the selection keeps the merged cell out of the sort.
• Put filters on row 2. Select the sub-heading row and the data below it (A2 to the last data row) before choosing Data > Filter, so the arrows land on Jan, Feb and Mar, not on Q1.
• Tables want one header row. An Excel Table (Ctrl + T) treats a single row as its headers, and merge commands are generally unavailable inside a table. Keep the Q1 row above the table and let row 2 be the table’s header row.
• Think about screen readers. Microsoft’s Excel accessibility guidance says to avoid splitting or merging cells, because it makes navigation with assistive technology very hard. Center Across Selection keeps cells separate.

If you mainly want totals per quarter, consider skipping the grouped header in your raw data. Keep a flat list with one heading per column (Region, Month, Sales) and build a PivotTable, which groups months under quarters for you. Here’s how to create a PivotTable in Excel.

Split Existing Data Into Sub-Columns

Sometimes the sub-columns already exist inside one column, such as “Jan 4200” or “North, 4200”. To spread them out:

• Text to Columns: insert empty columns to the right, select the column, choose Data > Text to Columns, pick Delimited, tick the separator (space or comma) and select Finish.
• Flash Fill: type the first result by hand in the next column, then press Ctrl + E. Excel fills the rest by following your example. See how Flash Fill works in Excel for patterns it handles well.

Then add the main heading above the new columns as described earlier.

Make One Cell Look Split

For a corner label (Region down the side, Month across the top) you can draw a diagonal line through one cell: Ctrl + 1 > Border, then select the diagonal border button. It’s only a line; the cell still holds one value, so you position the two words with spaces or Alt + Enter line breaks. For splitting an actual value, this guide on splitting a cell in Excel covers formulas and Power Query too.

Undo a Merged Heading

Select the merged cell, open the arrow next to Merge & Center and choose Unmerge Cells. The text stays in the upper-left cell. Anything that was deleted during the merge doesn’t come back, so press Ctrl + Z straight away if you merged by mistake.

To find merged cells you’ve forgotten about on the desktop app, choose Home > Find & Select > Find, select Options > Format, check Merge cells on the Alignment tab, then select OK and Find All. In Excel for the web, Microsoft says to select a cell and see whether Merge & Center is highlighted.

Header Layout Questions

Merge or Center Across Selection: which should I use?

Use Center Across Selection for working data you’ll sort, filter, copy or share. Merge & Center is fine for a report title or a printed summary that nobody will rearrange. The two look the same on screen.

Can I put sub-columns under only one column?

Yes. Other headings that have no sub-columns, such as Region, can sit in row 2 with row 1 above them left blank, or you can merge A1:A2 vertically so Region spans both header rows. Merging vertically has the same sorting drawbacks, so keep it to headers.

Does Center Across Selection work in Excel for the web?

Microsoft doesn’t document it for the web version. A workbook formatted this way in the desktop app should keep its look when opened in a browser, but if you can’t find the option online, open the file in the desktop app to apply it.

Next Step

Insert an empty row above your headers, type Q1 over the first month, and apply Center Across Selection to the three cells. Then freeze row 2 so the whole header stays put while you add the rest of the year.