Moving data validation messages
If you use Excel's data validation feature, you probably know that you can specify an input message that will appear when the cell is selected. Normally, this message appears near the cell.
When the prompt message is displayed, you can click it drag it to a new location. In the figure below, the prompt message for cell A1 has been dragged away. After you've dragged a prompt message, all new Data validation prompts are displayed in the same screen position!
There doesn't seem to be a way to "reset" this behavior back to normal -- except by closing and re-opening the workbook. (contributed by Bob Umlas)
