How to merge cells in Excel 2003 2007

Normally, you often use Merge & Center directly to merge cells in Excel, but cells with data, you will lose data in the back cells because Merge Cell only retains data in the first cell.

Suppose, before aggregating cells, your form would look like this:

Instructions on how to merge cells in Excel Picture 1

And here is the form after aggregating cells:

Instructions on how to merge cells in Excel Picture 2

1. How to merge cells in Excel 2003

a.Method 1: Check box using Format Cells feature in Excel 2003

Step 1: Click and hold the Shift key, then left-click on the cells to merge:

Instructions on how to merge cells in Excel Picture 3

Step 2: Right-click the selected area and then select Format Cells

Instructions on how to merge cells in Excel Picture 4

Step 3: In the Format Cells window, select Alignment (item 1).In the Horizontal and Vertical sections, select Center (item 2 and item 3) to display the content in the middle of the cell.Then select the Merge cells (item 4) check box, Click OK (item 5) to complete the cell merging process in Excel 2003.

Instructions on how to merge cells in Excel Picture 5

Step 4: And here is the box after merging:

Instructions on how to merge cells in Excel Picture 6

Do the same operations on columns: Name, Date of Birth, Occupation, Income, you will get the results as shown in the following picture!

Instructions on how to merge cells in Excel Picture 7

b.Method 2: Quickly merge cells in Excel 2003 by displaying Merge Cells feature on Menu

Step 1: If you have not dragged the Merge Cells feature to the Menu bar, you need to right-click on any empty spot on the Menu bar (item 1) and then select Customize (item 2):

Instructions on how to merge cells in Excel Picture 8

Step 2: Select the Commands tab (item 1), Select Format (item 2).Navigate to Merge Cells (item 3), then left-click Merge Cells:

Instructions on how to merge cells in Excel Picture 9

Step 3: Move the mouse to the Menu bar, then select the location to set the Merge Cells feature.When you select a position in the Menu bar, release the left mouse button.

Instructions on how to merge cells in Excel Picture 10

Step 4: After you have finished dragging the Merge Cells feature to the Menu bar, hold down the Shift key, then left-click the cells you need to merge:

Instructions on how to merge cells in Excel Picture 11

Step 5: Click on the Merge Cells icon above the Menu bar (item 1), where you have just selected the Merge Cells feature in Step 3. As a result, the cells you selected in Step 4 will merge into 1 cell as Section 2:

Instructions on how to merge cells in Excel Picture 12

Note:

The next time, you only need to select the cells to merge, then left-click on the Merge Cells feature icon in the Menu bar without having to drag the Merge Cells feature onto the Menu bar anymore.

2. How to merge cells in Excel 2007

Step 1: Click and hold the Shift key, then left-click on the cells to merge:

Instructions on how to merge cells in Excel Picture 13

You perform a cell merger in Excel 2007 similarly to a cell merger in Excel 2003.

Step 2: Next, click the Home tab (item 1), Select Merge & Center (item 2):

Instructions on how to merge cells in Excel Picture 14

Step 3: After doing Step 2, the 2 cells selected in Step 1 will be combined into 1 cell as shown below:

Instructions on how to merge cells in Excel Picture 15

Step 4: Do the same with the Name, Date of Birth, Occupation, and Income fields, you will also get the following result:

Instructions on how to merge cells in Excel Picture 16

So you have successfully merged multiple cells into one cell in Excel, which is extremely simple and fast.

Jessica Tanner

Update 13 April 2020