English Deutsch Français Italiano Español Português 繁體中文 Bahasa Indonesia Tiếng Việt ภาษาไทย
All categories

Is there a way I can have more than one line of text in a single cell?

for example:

the quick red fox jumped over
the lazy brown dog

instead of:

the quick red fox jumped over the lazy brown dog

2006-10-26 11:11:56 · 6 answers · asked by Dick 7 in Computers & Internet Software

6 answers

There are two ways to complete this task.

1. Type the top line of the cell, and then hold your Alt key and press Enter. This will create a line break where your cursor was.
2. You can go to the Format menu, Cells, Alignment Tab, and choose Word Wrap. You may still have to change the size of your cell, or you can merge the cell with another one to see the results you want.

2006-10-26 12:24:08 · answer #1 · answered by Jame 3 · 1 0

Lemme bet, you are in a Computer Literacy magnificence... possibly with the Art Institute??? Because whats humorous is that is the EXACT query of this weeks first task. bizarre. "Week three: Week three - W3: Assignment one million Discussion Discussion Question three Compare Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. When will have to you utilize each and every of those programs? When are you able to use those programs interchangeably? Give examples and causes to help your reply."

2016-09-01 03:08:34 · answer #2 · answered by ? 4 · 0 0

If you go to the format cells dialog you can select the wrap text function. It will make the font smaller than the rest of the other text.
Hope it helps.

2006-10-26 11:22:14 · answer #3 · answered by etcher1 5 · 0 0

the quick red fox jumped over(hold "Alt" key and press "Enter" while still holding "Alt" key)
the lazy brown dog

2006-10-26 13:53:43 · answer #4 · answered by Ragdoll 4 · 0 0

right click and format the cell
Format-alignment and wraptext
just make sure you expand the box or if your not altering the columns and rows then highlight the cells you want and merge the wrap text and it will still do the same as you want.

2006-10-26 14:01:54 · answer #5 · answered by Anonymous · 0 0

Press both buttons on keyboard alt+enter

2006-10-26 11:14:21 · answer #6 · answered by Unique 3 · 0 0

fedest.com, questions and answers