Formatting Issues

Merge Five Excel Cells Into One Tall Cell

Elise WilliamsElise Williams Nov 12, 2026 868 views

Question details

Create one large cell with the height of five rows beside five separate cells.

Merge Five Excel Cells Into One Tall Cell
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to merge cells A1 through A5 into one tall cell while leaving cells B1 through B5 separate.
Observed behavior
A single merged cell should span the combined height of rows 1 to 5 in the first column.
Before you start

Make sure the cells you plan to merge are in one continuous vertical range, such as A1:A5. Only the value in the upper-left cell is retained after merging, so move any needed content there first.

Solution 1Recommended

Merge cells A1 through A5 into one tall Excel cell

Use this method when you need one vertical cell beside several separate row cells.

Merging A1:A5 combines the five cells into one cell that matches the total height of rows 1 through 5. Cells in adjacent columns, such as B1:B5, remain separate.

1
Select the vertical cell range

Click cell A1, then drag down to select A1:A5.

2
Open the merge command

On the Home tab, select Merge & Center in the Alignment group.

3
Keep the text uncentered if needed

If you do not want centered text, click the arrow next to Merge & Center and choose Merge Cells instead.

Merge cells A1 through A5 into one tall Excel cell
Result: A1:A5 becomes one tall merged cell, while B1, B2, B3, B4, and B5 stay as individual cells.
Work with spreadsheets in WPS Office

Merge Multiple Rows Into One Tall Cell in WPS Spreadsheets

WPS Spreadsheets lets you merge a vertical cell range into one tall cell using familiar spreadsheet controls, while adjacent cells remain independent for structured layouts.

  1. 1. Open the worksheet: Open your spreadsheet in WPS Spreadsheets and go to the worksheet containing the cells.
  2. 2. Select the cells to combine: Drag from A1 through A5 to select the continuous vertical range.
  3. 3. Choose Merge and Center: On the Home tab, click Merge and Center in the Alignment section.
  4. 4. Use Merge Cells for uncentered content: Open the Merge and Center drop-down and select Merge Cells if you want to retain the default text alignment.
Merge a vertical range such as A1:A5 into one tall cell.Keep adjacent rows and columns separate for forms and tables.Open, edit, and save Microsoft Excel .xlsx and .xls files.Use a familiar ribbon-based spreadsheet interface with lightweight WPS Office.
microsoft office alternative - wps office

Frequently Asked Questions

Will merging A1:A5 affect cells B1:B5?

No. Merging A1:A5 only combines the selected cells in column A. Cells B1:B5 remain separate unless you select them too.

What happens to text already entered in the cells I merge?

Excel keeps only the content from the upper-left cell, which is A1 for the range A1:A5. Content in A2 through A5 is removed.

How do I merge cells without centering the text?

Select the range, go to Home, open the arrow beside Merge & Center, and choose Merge Cells.

How can I split a tall merged cell back into five cells?

Select the merged cell, then go to Home and click Merge & Center again or choose Unmerge Cells from its drop-down menu.