data validation input message locatioin has become static

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three columns where each cell has data validation and corresponding
input messages. Suddenly the input message box loction has become static,
i.e. it shows up near the upper left corner of my spreadsheet no matter which
cell in which column is selected rather than showing beside the selected
cell. I don't know how this happened and I can't figure out how to change it
back. Thanks.
 
If you move any data validation input message, all the messages appear
in that location.

Close and reopen the file, and it should work correctly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation of input against the active directory 1
How do I lock the location of the Data Validation Input Message? 1
Data Validation 1
data validation input message 2
Problem with Vlookup and Data Validation 3
Creating input messages or comments 4
data validation input message 1
Remove blank cells from data validation drop down box 3

Back
Top