How to use fill, justify, and distributed in Excel

These are the options to fill, justify, and distribute content horizontally in cells.

Let’s take a look.

Let’s look first at the Fill option.

Selecting a horizontal alignment of Fill will fill a cell with content, repeating the content as necessary.

This is not very useful for ordinary content, but it can be used for other effects.

Or, we could use a period instead.

Justify only affects text in cells that are wrapped.

If fact, you’ll see the Wrap Text button highlight automatically when you apply Justify.

Justify will force all lines except the last line to fill the entire column width.

In general, the Justify alignment option will look better when used on wider columns.

Even cells that contain a small amount of text on one line are expanded to fit the column width.

When a cell contains one word or number only, the Distributed option centers the content.

Be aware that with both Justify and Distributed, the text wrapping is automatic.