I don't like the fact that Excel cells have no-fill by default. So I have edited the "Normal" cell styles to have white background. White background color cell styles

However, after doing this alternating color for structured tables don't work anymore. Apparently, cell styles will take priority over table styles. Table styles are overriden by cell styles

While this is what I want the table styles to be: What I want for table styles

  • If you select the table, and remove the color from it, it will get the style back and ignore future white cells when expanding. – Christofer Weber Mar 23 at 19:37
  • What do you mean remove the color from it @ChristoferWeber – Freelensia Mar 25 at 11:49

As an elaboration of my comment, I made a small GIF of what I meant:

enter image description here

So when you have all the cells being white, you can select the table, pick "no fill" and then the table should go back to the normal style.

Your results may vary. I tried doing tables with normal set to white, and I don't even get the effect from the start:

enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.