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.
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.
- 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.
You can see the format type of these selected cells is marked with a blue highlighter.
📌 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.
- After removing the Asterisk symbols, click on the OK button.
Consequently, you will get all the accounting formatted cells in center alignment. And, the final outcome should look like this.
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.
- How to Apply Accounting Number Format in Excel
- How to Apply Accounting Number Format to Selected Cells in Excel
- How to Simultaneously Apply Accounting Number Format in Excel
- [Fixed] Accounting Format in Excel Not Working
- How to Apply Single Accounting Underline Format in Excel
- How to Apply Double Accounting Underline Format in Excel
- How to Convert Accounting Format to Number Format in Excel