Question

can we set the row height according to the text​

Answer 1

Answer:

Select the cell or range for which you want to adjust the row height. On the Home tab, in the Cells group, click Format. Under Cell Size, do one of the following: To automatically adjust the row height, click AutoFit Row Height.

Answer 2

Make sure the Home tab of the ribbon is displayed. Within the Cells group, click Format. Excel displays a drop-down menu of choices. Choose AutoFit Row Height from the menu.