Question

4. The column width gets fixed and the text is wrapped in the same cell.​

Answer 1

The column width gets fixed and the text is wrapped in the same ccell by these Steps:

1. On the Home tab, in the Cells group, click Format.
2. Under Cell Size, do one of the following:
3. To automatically adjust the row height, click AutoFit Row Height.
4. To specify a row height, click Row Height, and then type the row height that you want in the Row height box.
5. Open Excel on your Mac or PC and select the cells that you want to format.
6. Select the "Home" tab, then find the wrap text icon and click "Wrap Text."
7. Alternatively, you can select "Format" from the menu at the top, hit "Cells" and then select "Wrap Text" under the "Alignment" tab.