1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Merge and Center Cells

Merge Cells in Excel

By

Excel 2007 Formatting - Merge and Center Cells

Excel 2007 Formatting - Merge and Center Cells

© Ted French

The Merge and Center formatting feature in Excel is a handy option to quickly format titles and headings in Excel 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 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.

  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 Tutorials

©2014 About.com. All rights reserved.