Excel spreadsheets are a daunting affair for many. And indeed, when you are confronting dozens of rows and columns comprising hundreds if not thousands of cells filled with all sorts of data, it's ...

If you’re a full-time spreadsheet jockey, or just a casual number-cruncher, you’ve come to know and either love or hate Excel’s interface. Well, your world just changed. Throw away almost everything ...

This illustrated walk-through (with a demo worksheet) shows how easy it is to create a multi-column search solution using validation lists and conditional formatting. Excel offers numerous ways to ...