Microsoft Excel Excel's Builtin Features


	Excel's Builtin Features Microsoft Excel / Getting Started Data validation makes it easy to specify rules your data must follow. Unfortunately, Excel insists that lists used in data validation must appear on the same worksheet as the data being validated. Fortunately, there are ways to evade this requirement. In this tutorial, we provide two methods you can use to validate data based on a list on another worksheet. The first method takes advantage of Excel's named ranges, and the second uses a function call. Site: www.brainbell.com Report - View Tutorial