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...
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...
Import data: Filter external data before importing it into Excel
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...
Lists I: How to use lists in Excel 2003
Use the List command in Excel 2003 to easily sort and filter data, and total up values.
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 ...
Sort all red cells to the top of a report
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...
Sort Excel data on multiple columns