Merge Cells for Microsoft Excel
Merge cells in Excel 2016, 2013-2007, combine columns and rows
With Merge Cells you can efficiently merge the contents of several Excel cells into one without losing data.
See also: Merge data from 2 Excel tables in 5 easy steps
please use Merge Excel Tables wizard.
Merge cells in Excel exactly as you need them
This smart plug-in will save hours of your time. A couple of clicks and you have data from several Excel cells combined into one cell, or entire Excel rows and columns merged exactly as you need them. The Merge Cells joins various types of data such as names, numbers, dates, special symbols or text. You can separate the merged cells with any character, including the line break or carriage return.
Combine Excel columns row by row using any separator and place the results to the left cell of each row or the right cell of each row. More about combining columns in Excel.
Join data from several rows column-by-column and place the results to the top or bottom cell of each column. More about merging Excel rows.
Merge multiple cells into one cell and place the results to top left / right corner of the selected range or bottom left / right corner of the selected range. More about merging multiple cells to one.
Keep all data if the selection contains multiple values
One more fascinating feature of the Merge Cells is that it keeps all data when the selection contains multiple data values. If you try to merge data from multiple cells into one cell using the standard Microsoft Excel option, you will get the following error message: "The selection contains multiple data values. Merging into one cell will keep the upper-left most data only."
With Merge Cells you will never see this message again. The add-in preserves all data if the selection contains multiple data values. Your data in Microsoft Excel will never be lost!
How to merge two columns in Excel
Imagine that you have a list of your clients' addresses split into three columns: Address, City and ZIP code. You want to have the clients' addresses in one cell separated with a comma and a line break.
- In your worksheet, select the text cells you want to combine and click the Merge Cells icon.
- In the Merge Cells dialog box, set the parameters as follows:
- "How to merge" field: row by row.
- "Separate values with" field: type a comma and press Alt+Enter in the edit box.
- "Place the results to" field: select left column.
- Check the "Clear the content of selected cells" checkbox.
- Pick the "Skip empty cells".
- Check the "Wrap text" checkbox.
- Click the Merge button.
- That's all, now you have the addresses in one cell separated with comma and line break.
Select the additional options for merging cells
- Merge multiple ranges (even non-adjacent ones) and place the results into the selected cell
- Clear the cells after their content has been merged
- Combine all areas in the selection
- Exclude empty cells from merging
- Wrap text in the resulting cells
Find more details
Three ways to merge columns in Excel without losing any data
How to merge rows in Excel
Merge Cells screenshots
Combine cells by row, column or all into one, and choose where to place the results
Merge multiple Excel cells by selecting them and clicking the icon
Pick the settings: choose the delimiter you want and have a backup copy of your table
Your Excel data merged by row
Merge Cells for Excel system requirements:
- Microsoft Excel 2016 (32- and 64-bit)
- Desktop Excel included in Office 365
- Microsoft Excel 2013 (32- and 64-bit)
- Microsoft Excel 2010 (32- and 64-bit)
- Microsoft Excel 2007
- Microsoft Excel 2003
- Windows 10 (32- and 64-bit)
- Windows 8 (32- and 64-bit)
- Windows 7 (32- and 64-bit)
- Windows Vista (32- and 64-bit)
- Windows XP (32-bit)
- Windows Server 2003, 2008, 2012
- .NET Framework 4.0 must be installed.
If you need to install the add-in for a group of users, or on a Terminal Server (servers farm) please see Corporate deployment
Merge Cells version
Current add-in version: 5.0.6
published on: Nov 24, 2015
End-User License Agreement (EULA).