Friday, August 24, 2018

how to sort excel columns by color

There are two ways:
1. Use Sort & Filter -> Custom Sort -> set sort on... font color

2. highlight the header row and Sort & Filter -> Filter -> then specify font color you want to keep

No comments:

Post a Comment