Excel 2003
Inserting and Deleting Cells
Merging cells
In Excel 2003, you have another alignment option available to you: Merge and Center. This is performed when you want to select one or more cells and merge them into a larger cell. The contents will be centered across the new merged cell.
The picture below shows why we might want to merge two cells. The spreadsheet presents Last Month and This Month Sales and Expenses for Sally. Notice that Sally's name appears above the Last Month column. To evenly center Sally's name across the two cells, we would perform a Merge and Center.
To merge two cells into one:
- Select the cells that you want to merge. It can be cells in a column, row, or both columns and rows.
- Click the
Merge and Center button on the Standard toolbar.
- The two cells are now merged into one.
