Excel allows you to merge cells together in two ways: using the Merge and Center tool on the ribbon or toolbar, or by using the controls in the Alignment tab of the Format Cells dialog box. If you merge cells quite a bit, you might long for a shortcut that will merge whatever cells you've selected.

With Merge Cells you will • Combine multiple cells into one cellJoin multiple Excel cells and place your result either to the top left/right cell, or to the bottom left/right cell. • Merge columns row by rowCombine columns and save the result to the left or to the right column. • Combine rows column by columnMerge several rows and place the result to the top or to the bottom row. • Keep all your values while merging cellsThe add-in won't delete your data, even if the selection contains multiple data values.

• Manage your resultYou can choose to clear the contents of the selected cells, skip empty cells, merge all areas in the selection, or wrap text. • Separate your merged valuesSet a separator for your merged values: comma, semicolon, space, line break, or any character of your choice.

How to combine columns in Excel. You start the add-in, select your range and choose what to merge: columns, cells, or rows.

Then you indicate a separator for the combined values, it can be space, comma, semicolon, line break, or any separator of your choice. You determine the place where to put the result. You can also choose to clear the contents of the selected cells, merge all areas in the selection, skip empty cells, and wrap text. Then you click Merge and the result is ready in a few seconds.

Find a more detailed description.

1 Mac OS Requirements..2 Mac System Requirements.. Board software smart technologies.