Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Dick
Lv 7
Dick asked in Computers & InternetSoftware · 1 decade ago

Microsoft Excel?

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

6 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    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.

  • ?
    Lv 4
    5 years ago

    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."

  • 1 decade ago

    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.

  • 1 decade ago

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

    the lazy brown dog

  • Anonymous
    1 decade ago

    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.

  • 1 decade ago

    Press both buttons on keyboard alt+enter

Still have questions? Get your answers by asking now.