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

Turns out half my old formulas were just dynamic arrays in disguise, written the long way.

Inserting a blank row between existing rows of data in an Excel spreadsheet can be a tedious task if you insert each row individually. Fortunately, if you know this trick, inserting rows between ...

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

Stop updating Excel manually. Discover how to use dynamic array formulas to create self-updating reports and dropdown lists ...