Microsoft Support

Microsoft Home Page

Sign in

Select the product you need help with

Select a solution

Use AutoFilter to filter your data - Excel - Office.com
Filter a range of data using AutoFilter to show the data you want and hide the rest.
Sort by dates - Excel - Office.com
Sort by date from oldest to newest or newest to oldest using Sort &Filter on the Home tab.
Filter a range of data - Excel - Office.com
Filter a range of data using built-in comparison operators to show the data you want and hide the rest.
Sort data using a custom list - Excel - Office.com
Sort a list by days of the week or months of the year. Or create your own custom list for items that don't sort well alphabetically.
Guidelines and examples for sorting and filtering data by color - Excel - Office.com
Filter and sort data by color to make data analysis easier and help show highlights and data trends at a quick glance.