Can´t add lines in my Pivot Table design

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

Hi @silviasa85


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



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?



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.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies