Content

• To step
• Method 1 of 2: Merge with the Format Toolbar
• Method 2 of 2: Merge with a mouse button
• Tips

You can create and modify groups of cells or individual cells with the Excel spreadsheet program in Microsoft Office. You can combine cells, also known as merge, to combine data or improve the appearance of the spreadsheet. Learn how to merge cells in Microsoft Excel.

To step

Method 1 of 2: Merge with the Format Toolbar

1. Open an Excel document.
2. Enter data in the cells.
   • Keep in mind that merging cells can cause you to lose data. Only the data in the top cell on the left will be preserved when the cells are merged. Do not put data in every cell if you want to merge the empty space of a cell.
   • If you want to merge cells, but there is data in one of the middle cells, copy that data using the "Edit" menu, and paste it in the top left cell.
3. Select the cells you want to merge with your cursor. It is best to select cells in a single row or column, because that way you better understand what the command does.
4. Format the cell to merge it. The command depends on the version of Excel.
   • Newer versions of Excel have a "Merge" button in the "Home" tab of the ribbon. Look for the "Alignment" group of the options, or click the arrow to the right for more options.
   • In older versions of Excel, click the "Format" menu and select "Merge" from the options in the drop-down menu.
5. Click the "Merge and Center" option in the merge options list. This merges the cells and places the data in the middle, making the presentation of data a little more attractive.
   • You can also choose "Merge row," which will bring the data to the top right, or "Merge cells."

Method 2 of 2: Merge with a mouse button

1. Open your Excel document.
2. Select the cells you want to merge with your mouse.
3. Click the right mouse button. A menu appears with several options for changing the data in the cells.
4. Click on the option "Cell properties".
5. Select the "Alignment" tab in the Cell Properties dialog box.
6. Check the box "Merge cells". You can also select the vertical and horizontal alignment of the data in the merged cells.

Tips

• You can also split merged cells again. Select the cell that you previously created from a merge. Return to the Alignment menu on the Home tab, in the Format menu, or in the Cell Properties group. Select "Unmerge Cells" or "Split Cells." You can also uncheck the box next to "Merge cells". You cannot divide the cells that were previously unmerged.