Browse » Home
Monday, February 25, 2013
How to Merge Cell Contents in Excel 2007
1. Open the Excel worksheet.
2. Click the 'Home' tab on the command Ribbon.
3. Click and drag on the two or more cells to merge. A heavy black outline will form around the selected cells. The column headers above the outlined cells will turn a different color.
4. Click the down-arrow for the 'Merge Center' command in the 'Alignment' group. The drop-down menu offers three merge formats: Merge Center, Merge Across, Merge Cells. 'Merge Center' centers the text within the larger cell. 'Merge Across' retains the left-aligned text in the row. 'Merge Cells' unites the cells and keeps the data from the upper-left cell.
5. Click on one merge format. The cells will merge to appear as one larger cell. The heavy black outline will disappear.
6. Save this worksheet.