Question

how to change the width and height of the column as well as row

​

Answer 1

Explanation:

Select the column or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click Column Width. In the Column width box, type the value that you want.