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:

And here is the form after aggregating cells:

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:

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

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.

Step 4: And here is the box after merging:

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

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):

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

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.

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:

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:

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:

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):

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

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

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

Jessica Tanner

Update 13 April 2020