Add Center Across Selection to the Excel Quick Access Toolbar
Question details
The user wants quick access to Center Across Selection in Excel without merging cells.

- 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.
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.
Apply Center Across Selection through Format Cells
Use this method when you want to center content without macros or merged cells.
In the worksheet, select the unmerged cells across which you want to center the content.
Right-click the selection and choose Format Cells.
On the Alignment tab, open the Horizontal list, select Center Across Selection, and click OK.

Add a Center Across Selection macro to the toolbar
Use a VBA macro when you apply this alignment frequently and want a toolbar button.
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.

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.




