Skip to search results
PRODUCT
Office.com results
Video: Filter data by using an AutoFilter
Video Use the AutoFilter to filter a range of data in Excel 2007 and Excel 2010 and learn how to remove filters.
Excel 2010
Video: Sort data
Video Learn how to sort data in a worksheet.
Excel 2010
Quick start: Sort data in a worksheet
Article Sort data in Excel 2010 quickly, in just a few clicks.
Excel 2010
Remove subtotals
Article Remove calculated subtotal rows from a worksheet and remove subtotals from a PivotTable in Excel 2007 and Excel 2010.
Excel 2010, Excel 2007
Guidelines and examples for sorting and filtering data by color
Article Filter and sort data by color to make data analysis easier and help show highlights and data trends at a quick glance.
Excel 2010
Outline (group) data in a worksheet
Article Group rows or columns and then use an outline to quickly display summary rows or columns, or to reveal the detail data for each group.
Excel 2010
Filter for unique values or remove duplicate values
Article Use several ways to filter for unique values or remove duplicate values.
Excel 2010
Quick start: Filter data by using an AutoFilter
Article Use the AutoFilter to filter a range of data in Excel 2007 and Excel 2010 and learn how to remove filters.
Excel 2010
Filter data in a range or table
Article Use the AutoFilter to filter a range of data in Excel 2007 and Excel 2010 and learn how to remove filters.
Excel 2010
Insert subtotals in a list of data in a worksheet
Article Calculate subtotals for rows with SUM, AVERAGE, or other function, including nested subtotals, in Excel 2010
Excel 2010
Sort data in a range or table
Article Sort data in Excel 2010 by numbers, text such as alphabetical order, dates, colors, icons, or by a custom list.
Excel 2010
Quick start: Sort data in a worksheet
Article Sort data in Excel quickly, in just a few clicks.
Excel 2013
Outline (group) data in a worksheet
Article Use an outline to group data and quickly display summary rows or columns, or to reveal the detail data for each group.
Excel 2013
Guidelines and examples for sorting and filtering data by color
Article Filter and sort data by color to make data analysis easier and help show highlights and data trends at a quick glance.
Excel 2013
Find and remove duplicates
Article Filter for unique values and remove duplicates from your worksheet.
Excel 2013
Didn't find what you were looking for?Search all of Office.com