Can´t add lines in my Pivot Table design

Question

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

wyn hopkins · Answer

Hi&nbsp;silviasa85
&nbsp;
You may need to create your own Custom Pivot design for that
&nbsp;

silviasa85 · Answer

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 hopkins · Answer

Are you able to attach the file or a sample version?

silviasa85 · Answer

Yes, sure!

wyn hopkins · Answer

Hi&nbsp;
&nbsp;
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.
&nbsp;
I would use a custom design and assign borders to the Whole Table
&nbsp;
See attached

Forum Discussion

Can´t add lines in my Pivot Table design

Share

Resources