Text Alignment – Fill

We talked about examples of using “Text Alignment – Indent” in the previous post.  In the coming posts, let’s talk about the rest of the less commonly-used text alignments.  Actually, I find it a bit challenging to cite real-life examples for some of those.  “Fill” is one of those.

So what Fill does in text alignment?



It fills whatever you input in a cell to fit the whole column width.   Look at the screenshot below to get a better idea:

Excel Tips - Text Alignment Fill 2


So how could it help in my spreadsheet?

Honestly, I don’t have a simple answer.  In my previous works, I have never encountered a single cell with this format applied.

I tried to give an example of using Fill in the text alignment in work place.  However, I could hardly find one.  The best one I could think about is to create a signature line, like the example below.


However, I am not a big fan of using Excel to create forms or documents.  I still believe Word does a better job in creating forms or documents.

Be caution when using Fill as the outcome could be quite confusing.  How?

Try format a cell with number with Fill.  Look at cell A11 in the screenshot below, the number input is 1234, it appears as 123412341234… after the formatting.  It definitely gives you an impression of incorrect calculation, if any.

Excel Tips - Text Alignment Fill 2

My conclusion:

Unless you want to fool someone (even yourself), don’t use Fill in text alignment.  ;p

Do you have any good ideas in using Fill in text alignment?  Pls share in comment.

This entry was posted in Format and tagged , , . Bookmark the permalink.

One Response to Text Alignment – Fill

  1. Rebeca says:

    Nice job on presenting the information, this was very helpful.


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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s