Forum Discussion
silviasa85
Jan 11, 2019Copper Contributor
Can´t add lines in my Pivot Table design
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...
Wyn Hopkins
Jan 12, 2019MVP
silviasa85
Jan 14, 2019Copper Contributor
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...
- Wyn HopkinsJan 15, 2019MVPAre you able to attach the file or a sample version?
- silviasa85Jan 15, 2019Copper Contributor
Yes, sure!
- Wyn HopkinsJan 16, 2019MVP
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