We sorted numbers in the previous video. You can also sort text and dates, either alphabetically, by format (such as color), or by a custom list you create.
Sort by specifying criteria
Use this technique to choose the column you want to sort, plus other criteria, such as font or cell colors.
-
Select a single cell anywhere in the range that you want to sort.
-
On the DATA tab, in the Sort & Filter group, click Sort. The Sort dialog box appears.
-
In the Sort by list, select the first column on which you want to sort.
-
In the Sort On list, select either Values, Cell Color, Font Color, or Cell Icon.
-
In the Order list, select the order that you want to apply to the sort operation — alphabetically or numerically, ascending or descending (that is, A to Z or Z to A for text, or lower to higher or higher to lower for numbers).
Want more?
Χρειάζεστε περισσότερη βοήθεια;
Θέλετε περισσότερες επιλογές;
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
