Ms Excel is a powerful spreadsheet editor. It allows you to work with voluminous data types, namely, sort them according to a given criterion, set the necessary formulas and much more.
Sorting by a given filter
One of the important and necessary functions of the Ms Excel program is automatic sorting according to a given parameter. This function allows you to organize data in an Ms Excel table. You can sort data of various types: text, such as surnames, and numeric, such as dates. There are at least two types of sorting.
To arrange surnames alphabetically, you must select sorting by one attribute. It is worth saying that surnames in Ms Excel can be systematized in ascending order, that is, from "A" to "Z", or vice versa, in descending order. This is the so-called simple sort.
With this type of sorting, it is sufficient to select the column containing the surnames to be sorted. Then, in the Ms Excel Control Panel at the top right, find the Sort & Filter option. Click on it with the left mouse button, a window will open in front of you, in which you can select sorting from the first letter of the alphabet to the last, in reverse order, or independently determine the required parameter. A simple sort is suitable if there is only one column with last names in the Ms Excel document.
If your document has many columns, Ms Excel may ask you to clarify whether or not to expand the formatting area. In this regard, a corresponding dialog box will appear. You can choose to expand the range or sort according to the highlighted value. If you select Automatic Formatting Extension, the cells associated with the formatting column will still remain attached to it. Otherwise, sorting won't touch them. At this point, you should be careful, because the data in the document, if the sorting is incorrectly selected, risk mixing up.
Customizable sorting
The user can use another way to sort last names alphabetically by selecting a custom range. In this case, you will have to independently specify the column by which the data will be ordered. The Ms Excel user action will be the same, except that you select the Custom Sort option in the Sort & Filter section. After that, the user selects the column by which the data should be ordered. In this case, it is the last name column. The next step is to select alphabetically sort from first letter to last or vice versa. Such sorting is usually called complex.
Remember that in Excel, you can sort any column, regardless of its location on the sheet. Depending on which version of Ms Excel you have installed, the automatic sorting settings may vary, the essence of the work remains unchanged.
