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

Microsoft Excel Format Tutorial

By

4 of 9

Merge and Center Cells
Excel Merge and Center Cells

Excel Merge and Center Cells

© Ted French

Merge and Center the Worksheet Title

It is common to center the title left to right over the data in the worksheet. Although there is more than one way to accomplish this task, probably the easiest way to do it is to use the Merge and Center option on the Home tab of the ribbon.

Merge and Center works by merging the selected cells into one and then centering the data in the new combined cell.

Tutorial Steps:

  1. Select cells A2 to F2 to Highlight them.

  2. Click on the Home tab of the ribbon to select it.

  3. Click on the Merge and Center on the ribbon to merge the selected range of cells and to center align the worksheet title Deduction Calculations for Employees.

Additional Information on Merge and Center

Prior to Excel 2007, merging cells could cause problems when making subsequent changes to the merged area of the worksheet.

Adding new columns to the merged area, for example, was not possible. Before adding new columns, the title would have to be unmerged, the columns added, and then the merge and center option applied again.

Now it is possible to add additional columns to the merged area in the same manner as other areas of the worksheet.

Merge and Center still has one shortcoming - it can't merge and center data from multiple cells. If you try to do this, only the data in the left most cell will be kept - all other data will be lost when the merge occurs

©2014 About.com. All rights reserved.