Tuesday, 14 November 2017

Excel - Create Dependent Drop Down Lists

Create Named Lists


Apply the Excel Data Validation







Test the Dependent Data Validation

Adding a Third Dependent List


Using Two-Word Items



Using Items with Illegal Characters



Using Dynamic Lists



Block Changes in First Drop Down




Clear Dependent Cell After Selecting





Add Event Code to Clear the Customer Cell



Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London



















No comments:

Post a Comment