How to combine two or more columns in Excel 1. In Excel, click the "Insert" tab in the top menu bar. Then, click "Table." 2. In the "Create Table" dialog box that pops up, edit the formula so that ...

Excel's Merge option is useful for merging any group of cells, columns or rows that are adjacent to each other. When using Merge, however, all data except that in the upper-left cell will be deleted.