You have a long text in a cell and you want the text to appear in multiple lines. How can you achieve this in MS Excel 2010?
A
Select the text, click View > Page Break Preview
B
Select the text, click Page Layout > Breaks
C
Select the text, click Home, in the Alignment group, choose Wrap Text
D
None of the above
Correct Option:
C
Explanation
Wrap Text displays long cell contents on multiple lines while keeping them inside the same cell. Excel automatically adjusts the visible line arrangement according to the cell's width and row height.