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.
You should read it
- Merge cells in Excel
- How to merge cells in Excel - Instructions to merge cells in Excel 2010, 2013, 2016
- How to split cells, combine cells in Excel
- How to merge cells in Excel with no data loss
- How to merge and split cells in Word
- How to merge cells in Google Sheets
- Instructions on how to split and merge cells in Word
- How to combine 2 or more cells in Excel without losing data
- Merge keyboard shortcuts in Excel
- How to split cells, combine cells (cells) in Word table
- How to color formula cells in Excel automatically
- How to Lock Cells in Excel