Is it possible when exporting a report to excel to format the colum width to "auto scale"

The data in my report is too long to fit on A3 in the designer, but i don't want to view it online, of print it.

I just need to export it into excel.

So i have had to make the field widths small enough to fit in the screen

any ideas?