When you are using Excel as a word processor to include a paragraph of text to explain something in your worksheet, you usually have to decide where to break each of your lines manually. Excel has a command that re-flows your text in a paragraph to fit a certain number of columns.
So, for the reason above, you should do some careful planning of your work before invoking the justify command.
Follow the steps below to learn how:
- Be certain that your text is composed of one column of cells that contain text. It is fine if your sentences extend beyond one column, but the text should be arranged so that the left column contains text and the remaining cells are blank.
- Make sure that the upper left cell of your selection begins with the first line of text.
- Ensure that the selection range is as wide as you want the finished text to be.
- If your sentences currently extend beyond the desired width, Excel requires more rows in order to wrap the text. Include several extra rows in the selection rectangle for that reason.
- On your Home tab, select Editing | Fill | Justify.
Excel will flow your text so that each line is shorter than the selection range.