Pivot table - options spread


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

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


1 Like

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

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

1 Like

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

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

Hi @olga1 ,
Please select row names