Link to home
Start Free TrialLog in
Avatar of SRMoxy
SRMoxyFlag 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  

Avatar of SRMoxy
SRMoxy
Flag of United States of America image

ASKER

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

User generated image
ASKER CERTIFIED SOLUTION
Avatar of Karen Falandays
Karen Falandays
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Additionally, your data list is perfect to "Format as table". Then you can apply table formats and borders very easily
Avatar of 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.
User generated image