Controlling Text Flow

The length of a label might not always fit within the width you’ve chosen for a column. If the cell to the right is empty, text spills over into it, but if that cell contains data, the text will be truncated (that is, cut off). A cell can be formatted so its text automatically wraps to multiple lines or cell contents can also be shrinked to fit within the available space; that way, you don’t have to widen the column to achieve an attractive effect. If the cell to the right is empty, cell contents can be combined, or merged, with the contents of other cells.

Control the Flow of Text in a Cell

Image Select a cell or range whose ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.