Is there a way to paste named ranges in the dialog setting up data validity? In data validity Criteria tab you may select a ‘cell range’ as source. However, I could not find a quick way to enter a named range in the source area of the dialog unless I actually remember what the range name is and I type it out. I recall that by comparison in Excel pressing F3 shows your named ranges and by selecting one named range it is added to the open dialog accordingly.
Thank you for the information. I see that this matter was reported just over a year ago, but I hope that it will be corrected at some time in the future.
-1- This is not an answer. Askbot rules would require to post this as a comment on the answer by @kompilainenn .
-2- The so called bug is treated like a bug, but actually is an enhancement request. It may only get resolved if a developer chooses to work on it in “cherry-picking” mode.