How to find the validation list for a cell?

Solution 1:

You use Data > Data Validation from the ribbon to set the validation for a cell via a popup dialog. If you do the same for a cell that already has validation set then the popup shows the validation that was previously set.

If that validation is a list then the source range for the list is shown and clicking on the little spreadsheet icon next to the source range takes you to it.