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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies