As we all know, we can export the CRM report in various
formats and one of them is “Excel sheet”. After exporting the report in
the excel sheet, there are chances that you may not be able to see the filter
on certain columns. You will also notice that two columns get merged in single
column and have empty columns. Hence there are two issues, one with column
filter and other with the merged columns, as you can see in the below :
The actual problem is with the report column and not with
the excel sheet. The problem in report is the column width. If a column
has width more than 1in then it adds a column extra in it.
Now you just need to set the column width to 1in which is
default width of a column, which will solve these problems and there will be no
extra column or filter issue.
Hope this help while
designing the report which can be exported to the excel sheet.
