Can´t add lines in my Pivot Table design

Highlighted
New 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
Highlighted

Hi @silviasa85

 

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

 

image.png

Highlighted
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...
Highlighted
Are you able to attach the file or a sample version?
Highlighted

Yes, sure!

Highlighted

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

Highlighted

Thank you Wyn! I will try to do that.