Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Wish you all the best.
Here's comes a big problem to me. Hope anyone can help. Thanks in advance~
1. I can't remove the blank spece from my pivot which leads my pivot color inconsistent,
2. I can't set the line color as pic 2
Did you see my qvw file attached, there you can see the red lines right? What do you mean works few times? When you come out of Grid mode are they going off?
You need a macro or some other work around to take off those empty spaces. However, you get the red border lines,
Click Ctrl+G, then using Before and After cell color, you can get the red lines. Like here:
Hi Vishwarath,
Thanks for your reply. Ctrl+G doesn't work. It still change the vertical line.
Would you please attached the file?
Thanks!
try to follow below steps
go to -->View tab--> select design grid
then select you table right clik custom format cell
there follow below image you wll get it.
Hi Chanty,
It works for straight table but not in pivot table. Is it a bug? I'm using Version 11.20.12577.0 SR8.
Due to company's policy, I'm not allow to upload any pic or file into Community. I can only download files.
What I uploaded before is at home.
Attached.
follow the steps which i have mentioned above then you come to know the result what your are expecting.
Hi Chanty,
I always got the vertical border changed as below. I try many time but can't change the horizonal border.
Do you know the reason? Thanks~
Hi Vishwarah,
I always got the vertical border changed as below. I try many times but can't change the horizonal border.
Do you know the reason? Thanks~