graphci2
graphic1

Exam 77-427 Microsoft Excel 2013 EXPERT
3. Create Advanced Formulas
3.2 Look Up Data with Functions: Data Validation (Drop Down List-Input Message)

pci1

Data Validation: Input Message

Who wants to be successful? Yes, anyone who fills out your form hopes to complete the task quickly and correctly. So, use the Input Message to teach them how to fill in the blanks. Here are the steps:

 

4. Try This: Edit the Input Message

Go to the Input Message Tab.
Please type the following:
Title: Our Clients
Input Message: Select a client from the list.

Keep going...!

Data ->Data Tools-> Data Validation