See Also:
Office.com results
Demo: Distribute the contents of 1 cell across multiple cells
Article 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 2007
Guidelines and examples for sorting and filtering data by color
Article 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 ...
Excel 2007
Guidelines for organizing and formatting data on a worksheet
Article 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...
Excel 2007
Import data: Filter external data before importing it into Excel
Training Overview Learn to filter and sort data that is stored in a database by using Microsoft Query before importing into Microsoft Office Excel. After completing this...
Excel 2003
Lists I: How to use lists in Excel 2003
Training Use the List command in Excel 2003 to easily sort and filter data, and total up values.
Excel 2003
RANK function
Article Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank ...
Excel 2007
Sort all red cells to the top of a report
Article By Bill Jelen Bill Jelen is the author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com , whi...
Excel 2007