Question

If you want text in a cell to show even if the text is longer than the visible space in the cell, which text formatting option would you choose?

1) Overflow
2) Wrap
3) Clip

Answer 1

wrap

Step-by-step explanation:

On the Home tab, click Wrap Text. The text in the selected cell wraps to fit the column width. When you change the column width, text wrapping adjusts automatically. Note: If all wrapped text is not visible, it might be because the row is set to a specific height.