Looking for a Way to Customize Excel's Ribbon?

Here's an Example Showing How to Add "Format Cells" to Excel's Ribbon

Why the way you format headings is important

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.

To Change Format to Center Across Selection

Select the cells, right click and choose Alignment-Center Across Selection.

ExcelFormat Cells

Here's How to add Format Cells to Excel's Ribbon Menu!

  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.)

    Customize Ribbon Add Group
  2. Add Format Cells to the New Group.

    add format cells
  3. Rename Group as Format Cells

    Customize Ribbon - Rename Group
  4. Click and Drag to move Format Cells next to Alignment. Click OK to finish.

    Customize Ribbon - Move Format Cells
  5. This will add Format Cells to the Ribbon Menu. Then you can easily click on Format Cells-Alignment-Center Across Selection.

    center across selection using format cells ribbon

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:

Add Center Across Selection to Quick Start Menu

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

Center Across Selection Added to Excel Quick Start Menu

This will give you easy access to this function.

Stop using old technology!

Upgrade Your Excel and Data Analysis Skills to Smart Charts Using QI Macros.

Track Data Over Time

Primitive Chart
line graph
Line Graph
Smart Chart
control chart
Control Chart

Compare Categories

Primitive Chart
pie chart
Pie Chart
Smart Chart
pareto chart
Pareto Chart

Analyze Variation

Primitive Chart
bar or column chart
Bar or Column Chart
Smart Chart

QI Macros add-in for Excel makes creating smart charts a snap.