Text Alignment – Distributed

Let’s continue the topic of uncommonly used text alignment.  This time, it’s Distributed.

Honestly, another format rarely used in my work life.  So what is it about?

Excel Tips - Text Alignment Distributed  2

From the screenshot above, you may see that Distributed will evenly distribute the text string to fit the column width, by expanding the width of Space, if any.  When there is no space, the effect looks like Centre aligned with Wrap Text applied.

What to do with it in Excel? I have two examples for reference:

1) Better align Date with Day

Excel Tips - Text Alignment Distributed  3

Although it’s still not perfectly aligned (because of the font type chosen), I think the Distributed aligned (on the right) looks better.

2) Better align percentage change with +/- sign

Excel Tips - Text Alignment Distributed  4

This is another common situation I used Distributed alignment.  It better aligns the + and – sign to the left while leaving the number to the right. (note: it does not look nice when the column width is too wide)

Recently, I learned a direct way to achieve the same by using custom formatting from datapig‘s blog: http://datapigtechnologies.com/blog/index.php/aligning-custom-formatting-icons/

Actually I learned a lot from there!  🙂

Do you have other idea in using Distributed Text Alignment? Pls share with us.


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Format and tagged , . Bookmark the permalink.

1 Response to Text Alignment – Distributed

  1. Kathlene says:

    Remarkable! Its actually remarkable post, I have got much clear idea regarding from this piece of writing.


Comments, suggestions, corrections are welcome.

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 )

Facebook photo

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

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.