Excel 2007 Merge and Center Cells

The Merge and Center formatting feature in Excel 2007 is a handy option to quickly format titles and headings in Excel 2007 spreadsheets.

It allows you to center titles evenly above your data by merging a number of cells into one and then centering the title in this one cell.

In Excel 2007 the Merge and Center option is located under the Home tab of the ribbon.

Example using the Merge and Center cells feature

Note: For help with this example, see the image to the right.

1. Click on cell A2.
   
   
2. Type in a title such as: The Cookie Shop.
   
   
3. Click on cell A3.
   
   
4. Type in a subtitle such as: Income Statement.
   
   
5. Drag select cells A2 to C2
   
   
6. Click on the Home tab.
   
   
7. Click on the Merge & Center option on the ribbon.
   
   
8. The title should be centered across columns A to C.
   
   
9. Drag select cells A3 to C3
   
   
10. Click on the Merge & Center option on the Ribbon.
    
    
11. 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.

Related Articles

• Excel Formatting Options
• Excel's Format Painter