Microsoft Excel limits sorting criteria to ascending and descending organization in numeric or alphabetic order, by date or time, by the color of cells, type or icons, or against a custom list of ...

Excel has announced a new array-based function called SORT, which can be used to sort data in one or more columns without involving a manual sort process or a complicated macro process.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.