Microsoft Excel Question:
Download Questions PDF

How can I make text in a cell display in multiple lines?

Answer:

When entering text into the cell, press Alt-Enter to insert a line break. When you do so, Excel will automatically apply text wrapping to the cell.

To reformat existing cells so they sport wrapped text, select the cells and then choose Format, Cells. On the Alignment tab, select "Wrap text," and click OK.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
I find that sometimes my formulas do not get fully calculated. This often happens when I use custom functions created with Visual Basic?When I open a workbook, Excel asks if I want to update the links. I have looked everywhere, and I can not find any links in my formulas?