Please note: This item is from our archives and was published in 2005. It is provided for historical reference. The content may be out of date and links may no longer function. For example, start with ...
If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the Data tab on the ribbon, and created the rule in the Data Validation dialog ...
Microsoft Excel includes more than 450 built-in functions, which is admittedly a lot to master. These range from simple ...
is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 years. Microsoft is overhauling Excel with the ability to support custom live data types.