When the exact amounts that you want to enter in the Data Validation dialog box are in the worksheet, you can click the Collapse dialog box button and then select the cell with the amount.

Question

Quizplus · Accepted Answer

This is true. By clicking the Collapse dialog box button (the small red arrow pointing upwards at the top-right of the Data Validation dialog box), you can hide the dialog box while still having access to the worksheet. Then, you can select the cell with the desired amount and Excel will automatically enter it into the appropriate field of the Data Validation dialog box. This can help streamline the process of setting up Data Validation rules.

When the Exact Amounts That You Want to Enter in the Data