Solidworks BOM export to excel

Can someone help in explaining how to change the width in excel after exporting bom from Solidworks? So, whenever I export an excel from Solidworks bom, the contents doesn't extend automatically while we try to increase the width of the column or a cell in excel, because spaces gets introduced in each cell.