Can´t add lines in my Pivot Table design

Copper Contributor

I am trying to add horizontal and vertical borders to my pivot table by selecting this options in the "Pivot Table Style Options" area but nothing happens. Does anyone ever had this problem and found out the solution?

6 Replies

Hi @silviasa85

 

You may need to create your own Custom Pivot design for that

 

image.png

Hi Wyn! Thank you for the reply. I am aware of this possobilty (even though I haven’t tryied it yet), but I was hoping to find out how to fix this problem. It used to work...
Are you able to attach the file or a sample version?

Yes, sure!

Hi 

 

The borders aren't showing as the default formatting image relates to having columns and values in your Pivot, whereas in this scenario you just have rows.

 

I would use a custom design and assign borders to the Whole Table

 

See attached

Thank you Wyn! I will try to do that.