How to Center Accounting Format in Excel (with Easy Steps)

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.


Download Practice Workbook

You can download our practice workbook from here for free!


Steps to Center Accounting Format in Excel

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


πŸ“Œ 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: What is Accounting Number Format 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: [Fixed] Accounting Format in Excel Not Working (2 Quick Solutions)


Conclusion

In a nutshell, in this article, I have shown you all the simple and quick steps to center 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.

And, visit ExcelDemy to learn about many more Excel problem solutions, tips, and tricks. Thank you!


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

ExcelDemy
Logo