how to center number in excel

Center Numbers in Excel: A Step-by-Step Guide

By Anthony Allen
AD

In everyday tasks, numbers often need to be aligned centrally within Excel cells for neat, readable spreadsheets. However, Excel doesn't directly support horizontal centering for numbers. But, you can achieve this through formatting or custom number formatting. Let's explore how.

First, understand that Excel aligns text to the center by default, but numbers are aligned to the left, making them appear misaligned. We'll need to trick Excel into centering them. Let's dive into methods to center numbers in Excel.

Using Align Center in Excel

Before we dive into advanced tactics, let's first try the simple 'Align Center' tool that works with text, but not numbers by default.

AD
How to split numbers into individual digits in excel
How to split numbers into individual digits in excel
Custom Excel number format
Custom Excel number format
How to generate random number without duplicates in Excel?
How to generate random number without duplicates in Excel?

1. Select the cells containing the numbers you want to center.

2. Right-click the selected cells and choose 'Format Cells' from the context menu.

How to create sequential number in Excel FAST
How to create sequential number in Excel FAST
How to concatenate keeping number/date formatting in Excel?
How to concatenate keeping number/date formatting in Excel?

3. Go to the 'Alignment' tab and select 'Center' under the 'Horizontal' section. Click 'OK'.

Limitation of Align Center

The 'Align Center' tool only works with digits, not numbers with decimal points. Decimals are aligned to the left. To remedy this, we need to use custom number formatting.

AD

1. Select the cells with the numbers you want to center.

2. Right-click and select 'Format Cells'.

3. Go to the 'Number' tab, then click on 'Custom'.

AD

4. In the 'Type' field, enter `@` to add a space between each digit, helping to center the numbers more accurately. Click 'OK'.

Merging and Center Aligning Numbers

If your numerical data is grouped or merged, you might want to center align the numbers within those merged cells.

1. Select the merged cells you wish to center align.

AD

2. Right-click on the cells and select 'Format Cells'.

3. In the 'Alignment' tab, choose 'Center Across Selection' under the 'Merge and Center' section. Click 'OK'.

Centering Text and Numbers Together

If your cells contain a mix of text and numbers, you can center both together using the 'Merge and Center' tool.

1. Select the cells with both text and numbers.

2. Right-click and choose 'Format Cells'.

3. In the 'Alignment' tab, select 'Merge and Center'. Click 'OK'.

The key is to understand Excel's default behaviors and tweak them using built-in formats and customizations. Master these techniques to create clean, legible spreadsheets where numbers are aligned just as needed.

AD