Pivot table - options spread

[olga1]

Hi,

How can I change the way my pivot table displays? I want the data not to spread unless someone clicks on the sign

Thank you

[ErikG]

Hi @olga1
You can trying the collapse/expand function.

BR

[olga1]

Thank you Erik!
I was also wondering how can I change the headers of my columns?

[Vaibhav.narwade]

hello @olga1 ,
you can select the “format visual” option and select “Value column names”

[olga1]

Thank you Vaibhav! But it allows me to format only one column, not the rest

[ErikG]

Hi @olga1
is it possible you only have one column field and the rest are row fields?
BR

[Vaibhav.narwade]

Hi @olga1 ,
Please select row names