Crystal Reports Export to Excel using Scheduled Task

Message

     Hi Everyone.. 

I have recently taken over some reports from a colleague who left. 

Originally there were 2 reports that were set up to run as part of a daily scheduled task to output to a saved excel spreadsheet, this spreadsheet is then part of another job that extracts it to a website. 

I have recently been tasked with adding 2 new reports to this same process.  I have done so, however when I compare my new reports to the old ones I notice that the columns are automatically expanded to show the data cleanly, however my output still has the columns bunched up and the spreadsheets are therefore not easily readable without manual manipulation. 

I have tried everything to locate where the required setting is so that my reports work in the same way as the previous reports, but have not been successful. 

Is anyone able to point me in the right direction? Or should I be looking for an option in excel instead? 

Thanks in advance!