Notifications
Clear all
Dashboards & Charts
4
Posts
2
Users
0
Reactions
234
Views
Topic starter
Hello,
I need your support to understand why Excel reset to default borders in gray color, despite I customized the color of cell borders
Please see video attached
Thank you very much
Mark
Posted : 18/02/2021 7:58 am
Hi Mark,
I couldn't really make out what was happening in the video, sorry. Can you create a mock up file and share it with us so we can reproduce the issue?
Mynda
Posted : 19/02/2021 2:12 am
Topic starter
Hi Mynda,
Thank you for your reply
Mark
Posted : 19/02/2021 4:16 am
Thanks for sharing your file, Mark.
What you're seeing are the gridlines which you've hidden with white borders on the cells. When the PivotTable resizes the old formatting is lost. Instead simply turn gridlines off via the View tab of the ribbon > deselect Gridlines.
Mynda
Posted : 19/02/2021 6:03 am
