Ask Your Question

Paste named ranges in data validity dialog?

asked 2018-12-05 16:40:58 +0200

LibOff gravatar image

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.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-12-08 10:10:29 +0200

LibOff gravatar image

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.

edit flag offensive delete link more


-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.

Lupp gravatar imageLupp ( 2018-12-08 12:38:51 +0200 )edit

answered 2018-12-06 10:16:21 +0200

kompilainenn gravatar image

No way , for example there is a bug

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-05 16:40:58 +0200

Seen: 42 times

Last updated: Dec 08 '18