The Merge and Center formatting feature in Excel is a handy option to quickly format titles and headings in Excel spreadsheets.
In previous versions of Excel problems often occurred if you tried to make formatting changes to an area of the worksheet where the Merge and Center feature had been applied.
Adding new columns to the merged area was particularly difficult and it was necessary to un-merge the cells, add the new columns, and then reapply Merge and Center.
In Excel 2007 and Excel 2010 this problem has been corrected. Adding new columns to the merged area is now quite easily done.
The Merge and Center option is located under the Home tab of the ribbon.
Example using the Merge and Center cells feature
For help with this example, see the image above.
- Click on cell A2.
- Type in a title such as: The Cookie Shop.
- Click on cell A3.
- Type in a subtitle such as: Income Statement.
- Drag select cells A2 to C2
- Click on the Home tab.
- Click on the Merge & Center option on the ribbon.
- The title should be centered across columns A to C.
- Drag select cells A3 to C3
- Click on the Merge & Center option on the Ribbon.
- The subtitle should be centered across columns A to C.
Note: If you try to Merge & Center more than one row at a time only the title in the top row will be retained by Excel. All other titles will be discarded.