Avatar of SRMoxy
SRMoxy
Flag for United States of America asked on

MS Excel table cell borders inconsistently showing up

Why do cell borders disappear and reappear in my table when various data is refreshed??  Yes I have set the properties to "preserve cell formatting" but still they come and go!! LOL  

Microsoft ExcelGolangMicrosoft Office

Avatar of undefined
Last Comment
SRMoxy

8/22/2022 - Mon
SRMoxy

ASKER
SAMPLE -  See under # and Duration .......   I either want borders everywhere or not at all....  


ASKER CERTIFIED SOLUTION
Karen Falandays

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Karen Falandays

Additionally, your data list is perfect to "Format as table". Then you can apply table formats and borders very easily
SRMoxy

ASKER
Thanks, and Yes I am able to do that, but when a user makes a selection with a slicer the borders change.
(My 2nd sheet is the "table" and this is the dashboard with slicers)
I guess I can live with just setting the horizontal lines and living with the random vertical lines that come and go.

Your help has saved me hundreds of hours of internet surfing.
fblack61