There will be times when you're entering data into Excel and the data
doesn't quite fit into the cell that you're typing it into.
One way that you can make your data fit a little bit better is by adding a line break.
I'll show you how to do that in this movie.
I'll use of the LineBreak sample file, which you can find in the Chapter 5 folder
of your Exercise Files archive.
This workbook has a single worksheet, and there is a list of products: Dress
shirt, Leotard, and Leg warmers.
What I want to do is type in a description for the dress shirt.
So I'll click cell B2 and I'll type in White, narrow collar, and then gentle
taper for a better fit, and press Enter.
As you can see, the data doesn't fit inside the cell, and in fact, it's cut off,
because I don't want to change the right boundary, or how wide the cell is.
What I can do is add a line break.
So I'll double-click cell B2 to start editing the data. And it looks like just
before the word \"for\" is a good place of a line break to go.
So I'll click there. The insertion point is flashing just before the f. And then
to add the line break, I'll press Alt+Enter.
Doing so inserts a line break and when I press Enter, Excel resizes the cell
so that it now contains all of the data, and it did so without changing the
right edge of the cell.
And if I want, I can make the cell a little bit shorter
so it's not as tall vertically. So I'll drag the row marker at the bottom of row
2 up a bit, and doing so removes some of the white space so the row isn't
quite as large as it was before.
So if you need to enter a line break into one of your cell's textual data, just
press Alt+Enter and you can be on your way.
【本字幕由CGSUB.COM独家制作发布】 【禁止用作一切商业用途】 【www.cgsub.com】