I have created an Excel table. There are 149 rows so far. When I highlight everything and select sort and filter to alphabetize it only alphabetizes the first 50 rows. The first 50 rows are alternating blue and white. The rows after 50 are not alternating colors. How can I alphabetize all 149 rows (I'll be adding more)?
Solved by M. E. in 13 mins