Centering 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.
- Click on the Home tab of the ribbon to select it.
- Drag select cells D1 to G1 to highlight them.
- 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.
In previous versions of Excel merging cells could cause problems when making subsequent changes to the merged area of the worksheet.
Prior to Excel 2007, 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
Return to Index page