export to excel issues

can anyone explain, why when exporting a really simple spread to excel, one ends up with a ton of blank rows?

I have a report with 8 columns but when exporting to excel i end up with around 50 columns. All most are blank?

That is because Excel uses a whole lot of column merging to get the alignment as close as possible to the original report. It sounds like you have unmerged the columns/cells or have tried to copy and paste to another worksheet.

A simple way to fix this is to unmerge the cells, then copy just the columns you are interested in, or delete the blank columns altogether.

|||this may because of formating issues .try to format the fields properly or try to make some changes(like reduce or increase text size etc) in each field.|||

I'm not sure if you're seeing extra columns or rows or both, but it could be due to the size of your background (the white grid space in the body of the report). Make sure it is not bigger than your report items. I always get extra columns and rows in a dark grey in Excel if I don't size it correctly.

-Marianne