Question

Where will you find AutoFit Row and AutoFit Column Height option?​

Answer 1

Answer:

AutoFit columns and rows by using the ribbon

To AutoFit column width, select one, several or all columns on the sheet, go to the Home tab > Cells group, and click Format > AutoFit Column Width. To AutoFit row height, select the row(s) of interest, go to the Home tab > Cells group, and click Format > AutoFit Row Height.