If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
With Excel’s Merge Cells and Center Text feature, you can spread the contents of several cells into one merged cell. A merged cell is created by combining one or more cells into one new larger cell. For instance, you may have a lengthy title that spans several cells. The Merge Cells and Center Text feature will combine the extra cells into one large cell and center the text within the new cell. You can change the text alignment by choosing Left or Right alignment from the Home Ribbon or by choosing additional options from the Format Cells dialog box.
Once the cells have been merged, they can be returned to their original state by clicking the Merge and Center button with the merged cell selected.
To Merge Cells and Center Text
- Ensure that the data to be merged and centered is located in the leftmost cell.
- Select the cells you wish to merge.
- Click the Merge and Center button on the Alignment group on the Home Ribbon.
Similar Posts:
- Locking and Unlocking Cells in an Excel Worksheet
- Mail Merge in Word Part 5: Completing the Merge
- Mail Merge in Word 2007 Part 3: Writing Your Letter
- Align Objects in PowerPoint 2007
- Mail Merge in Word 2007 Part 1: Setting Up a Merge Letter
- Apply Colors and Shading to Cells in Excel 2007
- Using the AutoSum Button in Excel
