Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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 the width of the cell unchanged, but it finds a place to insert a break into the cell contents so that it wraps around.
And as you can see, all the cell's contents appear within the body of the cell. The compromise that was made is that the cell is now taller than it was before. If you're okay with the row being taller than the rows around it, then you can use the Wrap Text option. Let's suppose that doesn't work. Let's suppose that you don't want the cell boundaries to change at all. If that's the case, then you can shrink the text so that it will fit within the cell. I'll show you how to do that, but the first thing I'll do is click the Wrap Text button to remove that effect, so now, once again, the text doesn't fit.
And then with cell B2 selected, on the Home tab of the Ribbon, I'll click on the Alignment group's dialog box expander. That displays of the Alignment tab of the Format Cells dialog box. In the Text control group, the middle option is Shrink to fit. I'll check that box and click OK. Doing so reduces the size of cell B2's contents until they fit inside of the cell. So in other words, the cell boundaries didn't change either in the vertical or horizontal direction; the compromise was made by reducing the type size of the data inside the cell.
So again, you can use Wrap Text if you don't mind having your cell increase in size vertically, or, if you don't want the cell to change at all, you can use Shrink to fit and get it all in there and have it all be visible.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.