I've got an XLS* with several drop-down lists (from an adjoining tab). When I populate any of the drop-down cells, the remaining non-drop-down cells (using keybd shortcut Alt-down-arrow) have a "virtual" drop-down list of the values of the above cells.
Perhaps there's a handy use for this...