each column in crosstab take up 2 cell in excel format

Issue: I have a report contain 1 cross tab and when i try to export the report to excel format. Each column in the crosstab take up 2 cells in the excel. But I only want 1 column 1 cell. How to fix it?
Untitled2.xls (19.0 KB)


gohatto (BOB member since 2009-05-11)

problem solve
just uncheck “show cell margins”


gohatto (BOB member since 2009-05-11)

Hi,

where can I find that “show cell margins” option?
I am facing the same problem. :wah:
Thanks in advance.

-Buddy


Buddy :india: (BOB member since 2006-08-04)

Right Click on Crosstab > CrossTab Expert > Customize Style

It should be in the left column as a checkbox option.


DBokar (BOB member since 2009-06-12)