With these tips, you can sort your table in Excel correctly
Especially if you have complex Excel documents, you can help your table with these tips to get more order. We show you the most important sorting functions.
- The button "sort and Filter" (see the Screenshot), you can make the sorting of your table. The button you find in the menu bar, go to "Start" as the second-to-last icon on the right side. You think when you sort, always keep in mind: All of the items that you want to sort, must be pre-marked.
- You can sort the contents of your table alphabetically or numerically in ascending or descending order. This will help you, for example, if you want to sort a table with names according to the Alphabet. You can sort a table but also according to Numbers in ascending or descending order. As is shown, for example, the highest or the lowest price First.
- If you click on "custom sort", you can use any amount of other functions. For example, the tables are there in terms of the columns or of the cell sorting. You can also set here whether you want to observe the Uppercase and lowercase letters, for example, to the sorting according to the Alphabet. Click for these options on the "options" and then make the appropriate selection before you click "Ok".
- Furthermore, you can sort the table according to cell colors. Select the appropriate sorting in the "sort by". This sorting Option, see "custom sorting".
- Clear your Excel spreadsheet will also, if you sort them by the color of the font. This point you will also find under "sort".
- A last important point you will also find under "sorting": the cell symbols. You have used certain cells of the symbols, you can leave the table after this sort.
- The "custom sort" in the field "sequence" you can select also "custom list", and then, for example, a sorting according to date.
If you sort your table, it is clear. In this context, it is often helpful to duplicate rows, locate and accordingly hide.
