Merge Excel Columns Vertically and Keep the Top Value
Question details
Merge multiple vertical cell ranges in an exported cable list while retaining the value at the top of each range.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A cable list exported from AutoCAD has separate cells where vertically merged cells are needed.
- Observed behavior
- The exported cells are separate, and each intended vertical range needs to retain its top value when merged.
Identify each vertical range to merge and check that the value you want to keep is in its top cell. Review the cells below it for data you may need, because merging retains only the top cell's value.
Merge each vertical range in Excel
Use Excel's Merge Cells command to restore each vertical merge while keeping the top value.
In the worksheet, select the first vertical range and confirm that its top cell contains the value to keep. Move or combine any needed values from the cells below before merging.
Select the cells below the top cell and press Delete to clear values you no longer need, leaving the top cell unchanged.
Select the full vertical range again. On the Home tab, open the Merge & Center dropdown and choose Merge Cells.
Select and merge each remaining vertical range separately. Check the result in each column to make sure the intended top value remains.

Merge Vertical Cell Ranges in WPS Spreadsheets
Open the exported cable list in WPS Spreadsheets and merge each vertical range while retaining its top value.
- 1. Open the cable list: Open WPS Spreadsheets and use Open to select the exported Excel file.
- 2. Review the values: Select the first vertical range and check that the top cell contains the value to keep. Move any needed values from the cells below, then clear unwanted values.
- 3. Merge the range: Select the full vertical range, then use the Home tab's Merge & Center dropdown and choose Merge Cells.
- 4. Repeat and save: Merge each remaining vertical range separately, check the retained values, and select Save.

Frequently Asked Questions
What happens to values below the top cell when I merge vertically?
Excel keeps the value in the top cell and discards other values in the merged range. Move or combine any information you need before using Home > Merge & Center > Merge Cells.
Can I merge several columns at once and keep a value in each one?
Selecting several columns as one block and merging them creates a single merged cell. To keep a separate top value in each column, merge each vertical range separately.
How do I merge cells without centering the text?
Select the vertical range, open the Merge & Center dropdown on Excel's Home tab, and choose Merge Cells.
Can I keep text from more than one cell in a merged range?
Yes. Combine or move the needed text into the top cell first, then clear the other cells and merge the range. For example, use a formula in an empty cell to join the text, then copy and paste its value into the top cell before merging.




