Formatting Issues

How to Center Cells Horizontally in Excel

Maira Mehtab Sep 21, 2026 869 views

Question details

The user needs to apply horizontal centering to the text inside a specific range of cells, such as A7:H8.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Formatting a spreadsheet to improve data presentation and readability.
Observed behavior: The text in the specified cell range is not centered horizontally, and the user needs to apply the correct alignment settings.

Before you start

Ensure you have selected the correct worksheet containing the data you wish to format, and verify the exact cell range (e.g., A7:H8) you want to align.

Solution 1Recommended

Use the Format Cells Dialog to Center Text

This is the most reliable method to precisely adjust cell alignment settings across a selected range.

By using the Format Cells dialog box, you gain full control over text alignment, including horizontal and vertical centering, without needing to merge the cells.

Select the Cell Range

Highlight the specific cells you want to center. For example, click and drag your cursor to select the range A7:H8.

Open Format Cells

Right-click anywhere inside the highlighted range and choose 'Format Cells' from the context menu.

Adjust Horizontal Alignment

Navigate to the 'Alignment' tab in the Format Cells window. Under the Text alignment section, click the 'Horizontal' drop-down menu and select 'Center'.

Apply Changes

Click the 'OK' button to apply the horizontal centering to your selected cells.

Quick Ribbon Method: Alternatively, you can select your cell range and simply click the 'Center' alignment icon directly from the Home tab on the Excel ribbon.

WPS Spreadsheet Solution

Center Cells Easily with WPS Spreadsheet

WPS Office offers a seamless and familiar interface for all your spreadsheet formatting needs. You can easily center cells, adjust alignments, and manage large datasets just like you would in Microsoft Excel.

1. Open your file in WPS: Launch WPS Office and open your spreadsheet file.
2. Select the target cells: Highlight the cell range you wish to format, such as A7:H8.
3. Apply center alignment: Navigate to the Home tab and click the 'Center' icon located in the alignment group.

Fully compatible with Microsoft Excel (.xlsx, .xls) formats.One-click alignment tools on the Home ribbon for quick formatting.Lightweight and runs smoothly on Windows, Mac, and Linux.Free to download with comprehensive spreadsheet functions.

Frequently Asked Questions

Is there a keyboard shortcut to center cells horizontally in Excel?

Yes. After selecting the cell range, you can press Alt + H, then A, and then C sequentially to quickly center the text horizontally using the Excel ribbon shortcuts.

What is the difference between Center Across Selection and Merge & Center?

'Center Across Selection' horizontally centers text visually across multiple columns without combining the cells. 'Merge & Center' actually combines the selected cells into one large cell and centers the text inside it, which can sometimes interfere with sorting and copying data.

Why is my text not centering even after applying the alignment?

Check if there are leading or trailing spaces in your cell data, or if the cell is formatted as 'Accounting', which aligns symbols and text strictly to the edges. Ensure the cell format is set to 'General' or 'Text' for standard centering.

Can I horizontally center cells on mobile spreadsheet apps?

Yes. Simply select the cell range, tap the formatting menu at the bottom of the screen, and select the center alignment icon under the text or alignment section.

Document & File Issues