Center Across Selection in Excel: Add It to Quick Access

How-to basics · Updated November 19, 2026

To add Center Across Selection to Excel’s Quick Access Toolbar in Microsoft 365 for Windows, open File > Options > Quick Access Toolbar, set the command list to All Commands, select Center Across Selection, choose Add, and click OK. Afterward, select the cells you want to span and click the new QAT button; the command centers the first cell’s content across the selected cells without merging them.

What Center Across Selection does

Center Across Selection is a horizontal alignment setting for a range of cells. It makes content in the leftmost cell appear centered across the selected cells, while the cells remain separate. That distinction matters: the range still has individual cells, so you can select them, format them, and use them in formulas without first unmerging anything.

A common use is a table heading. Suppose a report has columns B through E for four quarterly figures, and you want a heading in B2 to sit visually over all four columns. Select B2:E2 and apply Center Across Selection. The text in B2 is displayed centered across that span, while B2, C2, D2, and E2 remain separate cells. For the intended appearance, keep the other cells in the selected span empty; their contents can interfere with how the centered text is displayed.

The setting applies to the selected range, not just to the text itself. If you select a range that includes multiple rows, Excel applies the alignment across each row of that selection. For a single heading, select the cells in that heading’s row rather than a larger block of the worksheet.

Add the command to the Windows Quick Access Toolbar

The Quick Access Toolbar, often shortened to QAT, is the small toolbar near the top of the Excel window. It can hold frequently used commands regardless of which ribbon tab is open. To add the alignment command in desktop Excel for Microsoft 365 on Windows:

  1. Select File > Options.
  2. In the Excel Options window, open Quick Access Toolbar.
  3. In the Choose commands from list, choose All Commands. This is important because the command may not appear among the default Popular Commands or in the ribbon’s visible commands.
  4. Find and select Center Across Selection in the command list, then click Add >>. The command should appear in the list on the right, which represents the QAT.
  5. Optionally use the up and down arrows to position it among your other toolbar buttons, then choose OK.

Back in the worksheet, the new button is available at the top of the Excel window. The exact location can differ if you have moved the QAT below the ribbon or customized your window, but the button remains part of that toolbar. If you cannot immediately spot it, check the QAT’s position and the toolbar’s overflow or customization controls.

Apply the button to a heading

Adding the button does not format existing headings automatically. First select the range, then click the QAT button. For example, to center a title over columns A through D in row 1, enter the title in A1, leave B1:D1 empty, select A1:D1, and click Center Across Selection. The title should appear centered across the four-column range.

You can apply the command to a range that already has content, but it is best to check that the cells to the right of the first cell are empty if you expect the text to appear across the full span. Center Across Selection does not combine or erase the cells. It is an alignment operation, not a data-cleanup operation, so inspect the selected range before applying it.

To remove the effect, select the same cells and choose a different horizontal alignment, such as General or Center, from the Format Cells dialog. Changing the alignment does not alter the cell values. If you need to check exactly which cells were formatted, select them and open Format Cells to view their alignment settings.

Find the setting without a QAT button

You do not need to customize the toolbar to use Center Across Selection. Select the cells, press Ctrl+1 on Windows to open Format Cells, and choose the Alignment tab. In the Horizontal list, select Center Across Selection, then click OK. This route is useful if you only need the command occasionally or if the command is not available in your QAT command list.

The setting is in the Format Cells dialog rather than the standard set of alignment buttons on the Home tab. The regular Center button centers content within each cell; it does not center one cell’s text across a selected range. Likewise, the QAT button is a shortcut to the specific alignment operation, not a general-purpose replacement for the other alignment controls.

If you do not see the command in All Commands, try using the Format Cells route first. You can also check that you are customizing the Quick Access Toolbar rather than the ribbon, and that the command list is set to All Commands. Available customization options can differ between desktop Excel and Excel for the web, so a missing command there does not necessarily mean it is missing from desktop Excel.

Center Across Selection versus Merge & Center

These options can make a heading look similar, but they behave differently. Merge & Center combines selected cells into one larger cell and centers the content in that merged cell. Center Across Selection leaves the cells distinct and changes their horizontal alignment. For many worksheet headings, keeping the cells separate makes later editing and data handling simpler.

  • Choose Center Across Selection when you want a heading to appear centered over several columns but still need the cells to remain independent.
  • Choose Merge & Center only when you specifically want one merged cell and have considered how that affects selecting, sorting, copying, and working with the range.
  • Choose ordinary Center alignment when each cell’s own content should be centered inside that cell rather than one entry being centered across several cells.

A frequent misconception is that Center Across Selection is a form of merging. It is not: each cell retains its own address and can contain its own value. However, if cells to the right contain text or numbers, those values can make the display crowded or prevent the leftmost entry from looking like it spans the whole range. Keep the heading span clear when presentation is the goal.

Common problems and how to fix them

  • The text stays left-aligned. Confirm that you selected the entire intended range, including the cell containing the heading, before clicking the QAT button. Selecting only the blank cells to the right will not center the heading in the way you expect.
  • The heading does not look centered over the columns. Check whether the cells to the right of the text contain values. Also confirm that the selected range begins with the cell containing the heading and ends at the desired column.
  • The command is hard to find. In the QAT customization dialog, set the source list to All Commands and look for the exact name. If it still is not available, use Format Cells > Alignment > Horizontal instead.
  • The button is missing after customization. Reopen File > Options > Quick Access Toolbar and check the list of commands on the right. If the command is listed there, it has been added; it may simply be hard to see because of the toolbar’s position or available space.
  • You expected every selected cell to be merged. Center Across Selection does not merge cells. If a single merged cell is truly required, use the merge controls on the Home tab, understanding that merging can affect worksheet operations.

When diagnosing a display issue, check the selected range and the contents of neighboring cells before changing the command. A formatting button cannot make a heading span visually across cells that are occupied by other content, and it does not move the heading’s value out of its original cell.

Using the feature on Mac or in Excel for the web

On Excel for Mac, the Format Cells route is the dependable way to apply the setting: select the range, open Format Cells, choose Alignment, then set Horizontal to Center Across Selection. The shortcut to open Format Cells is generally Command+1 on Mac, rather than Windows’ Ctrl+1. To customize the toolbar, look under Excel > Settings (called Preferences in some releases) and then Ribbon & Toolbar; labels and layout may vary slightly by release.

Excel for the web has a more limited interface than desktop Excel. It does not provide the same desktop QAT customization workflow, and the full Center Across Selection option may not be available in its alignment controls. If you need this exact alignment, open the workbook in the desktop Excel app and use either the QAT button or Format Cells. The workbook can then be saved so the desktop formatting is retained.

When this alignment is useful

Center Across Selection is most useful for visual headings over a small, defined group of columns, such as a report title over monthly figures or a label over a block of related measures. It is not a good reason to place a title across a very wide worksheet range if that makes the sheet difficult to navigate. Consider using a separate title area, a text box, or a report layout when a heading needs more control over position and appearance.

For data tables, keep actual column labels in their own cells and avoid spanning one heading over columns if users need to sort or filter the table by those individual fields. A visual group label can sit above the table, while the row of column headers remains one label per column. That arrangement keeps the worksheet understandable and preserves the structure that Excel tools expect.

Frequently Asked Questions

Can I add Center Across Selection to Excel’s Quick Access Toolbar?
Yes, in desktop Excel for Windows, open File > Options > Quick Access Toolbar, choose All Commands, select Center Across Selection, and add it. If it is not listed in your installation, use the Format Cells dialog instead.

Does Center Across Selection merge cells?
No. It changes horizontal alignment while leaving the selected cells separate. The content remains in its original cell, normally the leftmost cell of the selected span.

Where is Center Across Selection in Excel?
Select the cells, open Format Cells, choose the Alignment tab, and select Center Across Selection from the Horizontal list. On Windows, Ctrl+1 opens the Format Cells dialog.

Why is Center Across Selection not centering my text?
Make sure the selection starts with the cell containing the text and includes the full span you want. Check that cells to the right are empty; their contents can interfere with the intended display.

Can I use Center Across Selection in Excel for the web?
The web app does not offer the same desktop QAT customization workflow, and the full alignment option may not be available there. Use desktop Excel when you need to apply this specific setting.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.