Question

Mention the two ways to handle long text in an Excel cell.

Answer 1

Answer:

Select the cell with text that's too long to fully display, and press [Ctrl]1. In the Format Cells dialog box, select the Shrink To Fit check box on the Alignment tab, and click OK.

Increase Column Width

1. Type your long text in the appropriate cell.
2. Point your mouse cursor to the vertical line on the immediate right of the top column letter.
3. Double-click the line to make the column automatically resize to accommodate the lengthy text.

Explanation: