Choose the best way to extract and rearrange your data in Excel.

It's easy to alphabetize data in a Microsoft Excel spreadsheet by row or column using the "Sort" feature. You can also alphabetize in Excel using shortcuts found in the "Data" or "Home" tabs. One of ...

Filtering in Excel allows you to organize your data in multiple ways. Using a filter, you can cut down the amount of data shown on your sheet based on the values for either a certain selection, such ...

Have you ever struggled to sort data in Excel in a way that truly fits your needs? Imagine trying to organize a list of regions not alphabetically, but in a specific order like “North, South, East, ...

When it comes to mundane office programs, spreadsheet editors are some of the most powerful and versatile tools you're likely to come across. While Microsoft's Excel is what you likely associate with ...

Please note: This item is from our archives and was published in 2003. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I often recruit ...

It's often useful to freeze header rows in place in Microsoft Excel to remember what type of data is in various columns as you scroll or search through a lengthy spreadsheet. You can also make sure ...

You can use Microsoft Excel to set up a simple row-and-column matrix of information, listing income data, itemizing expenses and documenting events. These tasks barely scratch the surface of Excel's ...