To specify the exact width for one/more columns or height for one/more rows, follow these steps:
1.Select these columns or rows.
2.Right-click the header of any column or row in the selected range and run the Column width or Row height command from the context menu.
3.In the window that opens, specify the required width of columns or height of rows.
4.Click OK.