Adrian,
Have had that problem before. Appears AutoDesk has no solution. Only way I deal with excel is in the worksheet after you are done with the changes, select the entire spreadsheet and make the text size as small as possible. Re-size the columns, copy the area you want, paste in AutoCAD...