Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation input message locatioin has become static
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation input message locatioin has become static
"Grab" it with your mouse and place it where you want it!
Bif "spence" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data validation input message locatioin has become static
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. spence wrote: 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Valitaion Input message | Excel Worksheet Functions | |||
Message Input with link to different work sheet | New Users to Excel | |||
Input message on data validation field | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) |