Postby Brian-Broncos » Sat Apr 27, 2024 1:11 pm
FYI: Don't sort with the drop-down headers!! It messes up the data since Excel will only include other columns with drop-down headers when sorting the data.
Instead, sort by double-click or with Sort & Filter on the toolbar.
Double-click can be used to perform tiered sorting. For example, a custom sort of Category [A to Z], Play [A to Z], and Team [Z to A], can be performed by double-clicking anywhere in the Team column, then Play, and then Category. It alternates between ascending and descending, so if the order is reversed, just repeat the double-click before moving to the next column.
May the forces of evil become confused on the way to your house. - George Carlin