sodcalculator

10 Tech How-To

How to Use Fill, Justify, and Distributed in Excel

Guide 10-9734 · Updated · Step by step

Excel’s Fill, Justify, and Distributed options let you control how text wraps and aligns within a cell or merged area. Fill repeats a value to fill the cell width, Justify reflows text to fit neatly without extra spaces, and Distributed spreads words evenly across the cell. This guide covers each option, when to use them, and common pitfalls.

What You’ll Need

  • Microsoft Excel (2010 or later; steps are similar across versions)
  • A worksheet with text entries or cells you want to format
  • Basic familiarity with selecting cells and using the Ribbon

Step-by-Step

Using Fill

  1. Select the cell(s) containing the text you want to repeat across the cell width.
  2. Go to the Home tab on the Ribbon.
  3. In the Editing group, click the Fill dropdown (the paint bucket icon).
  4. Choose Justify from the dropdown menu. (Note: The Fill option is not directly in this dropdown; it’s in the Alignment dialog.)

Alternative for Fill:

  1. Select the cell(s).
  2. Press Ctrl+1 to open the Format Cells dialog.
  3. Go to the Alignment tab.
  4. Under Horizontal, choose Fill from the dropdown.
  5. Click OK. The text will repeat to fill the cell width.

Using Justify (Text Reflow)

  1. Select the cell(s) with text that is too long for the current column width.
  2. Go to the Home tab.
  3. In the Editing group, click the Fill dropdown.
  4. Choose Justify. Excel will reflow the text to fit within the column width, wrapping lines and adjusting row height.

Note: Justify works best on a single cell or a vertical range of cells. If you select multiple columns, it may merge them.

Using Distributed (Align & Spread)

  1. Select the cell(s) where you want text evenly spaced across the cell.
  2. Press Ctrl+1 to open Format Cells.
  3. Go to the Alignment tab.
  4. Under Horizontal, choose Distributed.
  5. Optionally, adjust the Indent value to add space from the edges.
  6. Click OK. The text will spread evenly across the cell width, with equal spacing between words.

Common Mistakes

  • Confusing Justify with Distributed: Justify wraps text to fit and aligns it to both edges; Distributed adds extra space between words to make lines equal width, even if it looks stretched.
  • Using Fill on numbers: Fill only works with text characters; numbers will not repeat.
  • Applying Justify to merged cells: Justify does not work well with merged cells; it may cause unexpected results or be disabled.
  • Forgetting to set row height: After using Justify, Excel usually auto-adjusts row height, but if you have manually set row height, the text may be cut off.
  • Selecting entire rows/columns: Applying these options to entire rows/columns can cause performance issues and unintended formatting.

Tips

  • Use Fill to create simple underlines or repeating characters like dashes or asterisks in a cell.
  • For Distributed, enable Wrap Text as well if you want the effect to apply to multiple lines.
  • If you want to remove the effect, set Horizontal alignment back to General or Left.
  • Use Justify to clean up imported text that looks messy due to line breaks.
  • Keyboard shortcut: Alt+H+FI opens the Fill dropdown, then press J for Justify.

Troubleshooting

  • Justify option is grayed out: This usually happens when the cell is merged. Unmerge the cell first (Home > Merge & Center) or use Distributed instead.
  • Text does not repeat with Fill: Make sure the cell contains text, not a number. Also check that the column width is wider than the text; otherwise, no repetition is visible.
  • Distributed makes text look too spaced: Reduce the indent value or use Justify instead for a more natural look.
  • Row height does not adjust after Justify: Manually set row height by selecting the row, right-clicking, and choosing Row Height, or double-click the row boundary to auto-fit.
  • Fill affects adjacent cells: Fill only affects the selected cell(s). If you see spillover, it’s likely the text is overflowing because the adjacent cell is empty. To prevent, enable Wrap Text or merge cells.

Frequently Asked Questions

What is the difference between Justify and Distributed in Excel?

Justify wraps text to fit the column width and aligns both left and right edges, similar to a newspaper column. Distributed also wraps, but adds extra space between words so that every line (except the last) has equal width, even if it means stretching the spacing.

Can I use Fill with numbers?

No, Fill only works with text characters. If you type a number, it will not repeat. You can convert the number to text by adding an apostrophe before it, but then it’s treated as text.

Why does my Justify merge cells?

If you select a range of cells across multiple rows and apply Justify, Excel may merge them into one cell to reflow the text. To avoid this, apply Justify to a single cell or a single column of cells.

How do I remove Fill or Distributed formatting?

Select the cell(s), press Ctrl+1, go to Alignment, and change Horizontal to General or Left. Click OK to revert.

Does Distributed work with wrapped text?

Yes, Distributed can be combined with Wrap Text. When both are enabled, each line of wrapped text will be evenly spaced across the cell width.

Why is my text cut off after using Justify?

This usually happens if the row height is manually set too small. Double-click the row boundary to auto-fit, or increase the row height manually.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →