With Microsoft Excel's powerful sorting capabilities, you can enter unsorted data and let the software sort your data numerically, alphabetically or chronologically. You can sort all the rows in a ...

Data validation in Microsoft Excel is a great way to limit what can be entered into a cell. However, creating rules using a formula allows you to enforce even more precise parameters—and there are ...

Use Excel data validation to prevent duplicate values in a column Your email has been sent Prevent duplicates before they happen by combining a simple function with data validation. Excel has built-in ...

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets. An 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 ...

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 ...

Do you have an Excel spreadsheet with huge data and scratching your head about how to find discrepancies? A discrepancy in Excel is quite common irrespective of whether you are an expert or an amateur ...

Please note: This item is from our archives and was published in 2004. It is provided for historical reference. The content may be out of date and links may no longer function. In the September 2003 ...

Learn a quick and easy straightforward method for creating dependent drop-down lists in Excel using range functions, without relying on complex formulas. By organizing data with dynamic ranges, each ...