Skip to main content
Search all of Office.com
Warning: This site requires the use of scripts, which your browser does not currently allow.
See how to enable scripts.
Skip to search results
Demo: Distribute the contents of 1 cell across multiple cells
Play Demo Or download the demo. (You may experience a delay while the demo is loading.) Storing information, such as a full address, in one column can limit wha...
Excel 2010: New Search Filter
This blog post introduces the new Search box built into the AutoFilter in Excel 2010 that makes filtering quicker and easier.
Excel 2007, Excel 2003
Filter by using advanced criteria
Use the The Advanced Filter to use complex criteria to filter a range in Excel 2007.
Filter for unique values or remove duplicate values
Filter for unique values, remove duplicate values, and conditionally format unique or duplicate values in Excel 2007.
Guidelines and examples for sorting and filtering data by color
Show All Hide All Sorting and filter ing data by color is an eagerly anticipated new feature in Microsoft Excel 2007. The following guidelines and examples can ...
Guidelines for organizing and formatting data on a worksheet
Microsoft Office Excel has a number of features that make it easy to manage and analyze data. To take full advantage of these features, it is important that you...
Sort data in a range or table
Sort data in Excel 2007 by numbers, text such as alphabetical order, dates, colors, icons, or by a custom list.
Try Microsoft Office 2010
Give Microsoft Excel 2010 a spin by trying Office 2010 free for 60 days, or buy it now!
Watch this: Let the status bar do the work
If you select several cells containing numbers, Excel sums, averages, counts, and otherwise analyzes that data and shows you those results on its status bar.