Can I sort by more than 3 columns?
One way to do this is to insert a "helper" column and insert a formula
that concatenates each value from the 6 columns to a single cell, like
this:
=A2&B2&C2&D2&E2&F2
Copy and paste that cell into all the necessary rows, sort on your
helper column, and delete it.
|