I recently modified an excel sheet which required me to convert some tables on a tab to a range to remove an unnecessary column that was interfering when copying a range form one sheet to another. When I went back to convert the ranges back to tables, the tables no longer alternate color when filtered.
What I mean by that is, when the table has no filter active, and all rows are visible, and the rows alternate between blue and white. When I activate a filter now, I could have 2 or more rows with the same color next to each other. Prior to the change, the colors would be alternate as if it was unfiltered.
My question is, what did I do wrong, and how can I fix it?
Edit: I am using Office Home and Business 2016