Add a Filter Prompt
- On the Advanced Filter dialog box, add a criteria line.
- Select the field and operator.
- Select the Filter Prompt check box to the right of the value field.
- Enter the prompt message in the field.
When you click Activate all prompts display.