Microsoft Office Tutorials and References
In Depth Information
Filling cells and creating data series
Distributing long entries using the Justify command
Clicking Fill, Justify doesn’t do what you might think it does. It splits a cell entry and
distributes it into two or more adjacent rows. Unlike other Fill commands, Justify modifies the
contents of the original cell.
For information about the other justify feature—that is, justifying text in a single cell—see
“Justifying text in cells” in Chapter 9.
For example, in the worksheet on the left in Figure 8-30, cell A1 contains a long text entry.
To divide this text into cell-sized parts, select cell A1 and click Home, Fill, Justify. The result
appears on the right in Figure 8-30.
Figure 8-30 Clicking Justify distributes the long label in cell A1 to cells A1:A6.
When you click Justify, Excel displays a message warning you that this command uses as
many cells below the selection as necessary to distribute the contents. Excel overwrites any
cells that are in the way in the following manner:
If you select a multirow range, Justify redistributes the text in all selected cells. For
example, you can widen column A in Figure 8-30, select the filled range A1:A6, and
click Justify again to redistribute the contents using the new column width.
If you select a multicolumn range, Justify redistributes only the entries in the leftmost
column of the range, but it uses the total width of the range you select as its
guideline for determining the length of the justified text. The cells in adjacent columns are
not affected, although the justified text appears truncated if the adjacent column’s
cells are not empty.
Creating custom lists
If you find yourself repeatedly entering a particular sequence in your worksheets, such as a
list of names or products, you can use the Excel Custom Lists feature to make entering that
sequence as easy as dragging the mouse. After you create your custom list, you can enter
it into any range of cells by typing any item from the sequence in a cell and then
dragging the ill handle. For example, in Figure 8-31 we entered a single name in cell A1 and