Office Settings & Configuration

Add Center Across Selection to the Excel Quick Access Toolbar

Jason MillerJason Miller Nov 20, 2026 868 views

Question details

The user wants quick access to Center Across Selection in Excel without merging cells.

Add Center Across Selection to the Excel Quick Access Toolbar
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user wants to center content across separate cells and add the formatting action to the Quick Access Toolbar.
Observed behavior
Center Across Selection may not appear as a standalone command in the Quick Access Toolbar customization list.
Before you start

Select a range of unmerged cells, with the content to center in the leftmost cell. Check the Quick Access Toolbar command list first, as available commands and menu labels can vary by Excel version.

Solution 1Recommended

Apply Center Across Selection through Format Cells

Use this method when you want to center content without macros or merged cells.

1
Select the cells

In the worksheet, select the unmerged cells across which you want to center the content.

2
Open Format Cells

Right-click the selection and choose Format Cells.

3
Set the alignment

On the Alignment tab, open the Horizontal list, select Center Across Selection, and click OK.

Apply Center Across Selection through Format Cells
Toolbar limitation: If Center Across Selection is not listed as a command in Quick Access Toolbar customization, Excel does not provide a standard non-macro way to add it directly.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets for an easy move between office suites; it does not change Excel's Quick Access Toolbar.

Use familiar spreadsheet formatting controls to arrange worksheet contentOpen and edit compatible Microsoft Excel XLS and XLSX filesNavigate a familiar interface when moving from Microsoft OfficeUse a free, lightweight office suite for everyday documents
microsoft office alternative - wps office

Frequently Asked Questions

Where is Center Across Selection in Excel?

Select the cells, right-click and choose Format Cells, then open Alignment > Horizontal and select Center Across Selection.

Does Center Across Selection merge the cells?

No. It changes horizontal alignment while keeping the cells separate. Select unmerged cells and place the content in the leftmost cell.

Can I add Center Across Selection to the Quick Access Toolbar without a macro?

If it is not listed in the Quick Access Toolbar command list, Excel does not offer a standard direct way to add it without a macro. You can still apply it through Format Cells.

Why doesn't my macro toolbar button work in another workbook?

The workbook containing the macro must be open and macros must be enabled. Save the macro in an .xlsm workbook and open that trusted file before using its toolbar button.