Categories
Excel Training

Excel Training – Wrap Text

Text wrapping allows you to make all the contents of a cell visible without adjusting the cell’s size.

When you enter data, if that data is longer than the width of the cell, it appears in one of two ways:

(1)    If the cell to the right contains data, you will see only as much as the size of its cell allows. ( fig.1, column B)

(2)    If the cell to the right is blank, the data will spill across into that cell. (fig.1, column C)

Text wrapping gives you a third option, where none of the data is obscured, nor does it spill across to the next cell. (fig.1, column E)

You will find the Wrap Text (fig.2) command in the Home ribbon and the Alignment group.To apply it, highlight the relevant cell(s) and click on the Wrap Text button.

It’s that simple. Why not give it a try.

fig.1
fig.2

By Richard Bailey

I love what I do; I get to work with an outstanding team to help hundreds of people with their challenges. I’ve learnt a lot from the teams I’ve worked with, no matter the size or industry we all have challenges to overcome, difficult customers, creating a budget or keeping a project on track.