MS Excel Secrets - Sorting Options in Excel 2007
https://ingenuitydias.blogspot.com/2014/03/ms-excel-secrets-sorting-options-in.html
Sort by columns in Excel 2007:1. Select Data -> Sort (in Sort & Filter Group) -> Options.
2. Select Sort left to right option button and click OK.
3. In the Sort by option of the Sort dialogue box, select the row number by which the columns will be sorted and click OK.
Read lots more MS Excel Secrets
Sort by case sensitive:
1. Select Data -> Sort (in Sort & Filter Group) -> Options.
2. Check Case sensitive and click OK.
3. In the Sort by option of the Sort dialogue box, select the column title or/and add a level and click OK.
.jpg)
Posts
