Is there a way to set column widths for excel export of pivot table or prevent freezing panes?

jgrout
jgrout Member
in Cards, Dashboards, Stories

When I export my pivot table as an excel file, it is generating an excel where my second column is like 245 characters wide, and it also freezes the pane after that column, making it impossible for user to see any of the corresponding data to the right of the second column. Ideally, I'd want to set a fixed column width for Excel, but don't see a way to do this. 2nd best option would be turn off the automatic freezing of the panes that is currently done.

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    @jgrout I don't see options to set column widths on a pivot table card, but you could try checking the "Allow text to wrap" box under Chart Properties > General to see if the column with lots of characters displays better.

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @jgrout I don't see options to set column widths on a pivot table card, but you could try checking the "Allow text to wrap" box under Chart Properties > General to see if the column with lots of characters displays better.

Categories