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.

Fix Excel’s alphabetical month sorting issue with simple tricks. Learn how to group months chronologically using XMATCH and CHOOSECOLS.

Q. Is it possible to sort a column in Excel using formulas rather than the Data tab’s Sort tool, so the sort process is performed automatically as I update my data? A. Excel has announced a new ...

One of the most popular tasks in Microsoft Excel is filtering dates by month, or another particular criterion. However, there are times when the Excel date filter grouping does not work as intended, ...

Move beyond the basics of sums and averages. These tips open up all kinds of opportunities for working with spreadsheet data. Editor’s Note: This article was originally published in Sept. 2012 and the ...

You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.

Here's how Excel processes that request. First, the SORT function arranges the entire table by sales amount in descending order. Then, the DROP function takes that sorted list and removes the top five ...

Microsoft Excel is spreadsheet data management software used by many small businesses for day-to-day operational tasks. Excel's convenient cell-based structure lets you input your business' inventory, ...

Microsoft Excel has a great sorting feature that works quite well. However, it is possible to use this feature to sort cells based on their color. Multiple colors are supported, and from our testing, ...