How to align or format numbers centrally in Microsoft Excel table– TopBullets.com

Topbullets.comYou may have come across this problem while you were trying to align everything centrally, but numbers don’t go to center. All other formats like date, text and account can be centrally aligned but once you change them to numbers with comma style, the format goes out of toss. I remember one conversation between one of my colleagues and his manager about formatting. The manager wanted everything in the table centrally aligned and my colleague was trying to explain, it was impossible. Both tried all tricks and finally, the manager had to agree with him. Today, I found one hack which helps to overcome this challenge.

Step1: I am making a sample table with text, date and general fields in different columns and make them centrally aligned – vertically and horizontally.

Central2

Step 2: Now I will convert the few revenue columns as numbers. See the difference. They all go south (I mean right-aligned). No matter what you do, you can’t make them left or centrally aligned.

Central3

Step 3: Here is the simple hack. Copy the table, open a blank PowerPoint and paste as special. Avoid Ctrl+C and Ctrl+V. Ctrl+C the table from Excel but before pasting on PowerPoint, right-click and select the second option (Keep Source Formatting (K)).

Central1

Step 4: Now, select the table again on PowerPoint. Copy it and paste back to the Excel. This time you can use Ctrl+C and Ctrl+V.

Central4

Step 5: Now, in Excel, you can make those columns centrally aligned like I am doing here.

Central5

Hope it fixed your issue. If yes, please hit like and do comment your thoughts here.

Signature

Deepesh Singh
logo

Advertisements

Please leave your valuable comment.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s