Home » Free Excel Tips » How to Customize Excel's Ribbon to Format Cells

Add Format Cells to Excel Ribbon

Over half of all Excel workbooks use Merge and Center for headings, but Merge and Center causes problems when charting, selecting data, doing PivotTables and other functions. The trick is to use Format Cells-Center Across Selection. Unfortunately there is no shortcut.

You can select cells, right click on the cells and choose Alignment-Center Across Selection.

You can also add Format Cells to the Ribbon Menu! Here's How:

1. Click on File-Options and choose Customize Ribbon. Click on the Home Tab and New Group. (You cannot add this to an existing group.)
   
2. Add Format Cells to the New Group.
   
   
3. Rename Group as Format Cells
   
   
4. Click and Drag to move Format Cells next to Alignment. Click OK to finish.
   
   
5. This will add Format Cells to the Ribbon Menu. Then you can easily click on Format Cells-Alignment-Center Across Selection.
   

You can also use VBA and the Quick Start Menu

For those of you familiar with VBA, you can use this code in your Personal macro file. Excel will automatically load this file everytime you start Excel.

Sub CenterAcrossSelection()
    With Selection
        .HorizontalAlignment = xlCenterAcrossSelection
        .MergeCells = False
    End With
End Sub

Then go to File-Options-Quick Access Toolbar, select Macros and add CenterAcross Selection:

When done, Excel will show Center Across Selection in the Quick Start Menu:

This will give you easy access to this function.

Other Charts Included in QI Macros for Excel