Wrapping and shrinking cell text


show more Wrapping and shrinking cell text provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2013 Power Shortcuts show less
please wait ...

Wrapping and shrinking cell text

One of the hardest parts of creating an Excel worksheet is to get the design exactly the way you want it. That means that you need to get the appearance right, but it also means that you need to have the size of the cells exactly right so that they print properly. In this movie, I'll show you how to work with the cells' contents, so that you can stay within the boundaries of your existing design. I will use the WrapText sample file, which you can find in the Chapter 5 folder of your Exercise Files archive. The cell's content that I'm interested in working with is in cell B2.

And you can see that with the existing design of the worksheet, with the width of cell B2, which I don't want to change, the contents, which you can see on the Formula barm are not all displayed inside of the cell. So what can I do to change that? Well, the first thing I can do is click cell B2, and then on the Home tab of the Ribbon, in the Alignment group, click Wrap Text. What that does is leave t...

Wrapping and shrinking cell text
Video duration: 2m 32s 3h 16m Intermediate

Viewers:

Wrapping and shrinking cell text provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2013 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...