How to Center Accounting Format in Excel? (with Quick Steps)

Get FREE Advanced Excel Exercises with Solutions!

In Excel, the number formats generally get right-aligned, and the text values get left-aligned. Sometimes, we might need to center these values for a better and cleaner representation of data. If you are looking forward to learning about centering the accounting format in Excel, you have come to the perfect place. Follow the article below to learn every step to center accounting format in Excel.

How to Center Accounting Format in Excel: Step-by-Step

Now, you can follow the simple and quick ways below to center the accounting formatted cells in Excel.

๐Ÿ“Œ Step 1: Select Cells in Accounting Format

First and foremost, you need to select the required cells for this process.

  • To do this, initially, select the cells C5 to C12 by dragging your left mouse button.

Select the Accounting Formatted Cells to Center Accounting Format in Excel

Read More: What Is Accounting Number Format in Excel

๐Ÿ“Œ Step 2: Go to Format Cells Window

Now, you need to access the Custom format options.

  • In order to do this, after selecting the required cells, click the right button on your mouse.
  • Subsequently, choose the Format Cellsโ€ฆ option from the context menu.

Access the Format Cells Dialogue Box

  • At this time, the Format Cells dialogue box will appear.
  • Subsequently, go to the Number tab from this dialogue box >> choose Custom from the Category: options.

Choose Custom Category

You can see the format type of these selected cells is marked with a blue highlighter.

Read More: How to Make Negative Accounting Numbers Red in Excel

๐Ÿ“Œ Step 3: Remove the Asterisk Symbols

Now, you need to change something in the format to center these Accounting formatted data.

  • Regarding this target, at the very beginning, you need to go to the Type: text box.
  • Afterward, remove the three Asterisk symbols (*) in the Type: text box.

Remove the Asterisk Symbols to Center Accounting Format in Excel

  • After removing the Asterisk symbols, click on the OK button.

Click on the OK Button to Confirm the Format

Consequently, you will get all the accounting formatted cells in center alignment.ย  And, the final outcome should look like this.

Centered Accounting Format in Excel

Read More: How to Change Accounting Format in Excel

Download Practice Workbook


In a nutshell, in this article, I have shown you all the simple and quick steps to center the accounting format in Excel. Read the full article carefully and practice accordingly. I hope you find this article helpful and informative. You are very welcome to comment here if you have any further questions or recommendations.

Related Articles

Tanjim Reza
Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF