For some people, using Excel may be considered less practical when compared to Word. Well, in fact, both are Microsoft Office products that have different functions. If Word is more used to type a written document (articles, papers, novels, etc.), Excel functions more as data processing.
We will learn to sort names in Excel quickly and easily here. Curious, right? Listen to the end, yes!
Sort data or names in Excel easily.
There are several simple ways or steps that you can do if you want to sort names or data in Excel. Microsoft, on its website, explains as follows.
- Select the data that you want to sort, for example, the data in cells A1, A2, A3, and so on.
- If it has been determined, select the name or data in a particular cell again.
- Click the tab in the Data section, then go to Sort & Filter or Short & Filter.
- Well, there will be an icon in the form of the letter AZ as in the picture above (in a red box).
- There are two types of sorting. You can choose A to Z or Z to A. See the arrow as a benchmark for sorting names or data.
- Determine and select which cells you will sort the data from.
- Click the Data tab and go to Short & Filter or Sort & Filter.
- Perform the steps as before. Adjust the sort by A to Z or Z to A (according to the image above).
- Go to Sorted on and select Cell Color, Cell Icon, Value, and Font Color.
- Now, in the Order list, you can sort based on their respective criteria, for example, letters, names, data, numbers, text, etc.