Solved Clicking arrow does not reveal Pick List in SOME cells

September 2, 2019 at 07:08:32
Specs: Macintosh
This is an odd one - I hope someone my be able to help!

I've set data validation and for some cells in the column it works fine i.e. click the arrow and the list displays

In other cells the arrow button is there but clicking it does nothing It's odd the validation is definitely copied to those cells that don't work.

Any ideas would be really appreciated! Thanks in advance


See More: Clicking arrow does not reveal Pick List in SOME cells

Reply ↓  Report •

#1
September 2, 2019 at 08:33:49
✔ Best Answer
I'm guessing this is an Excel question.......

If you copy the data validation to columns that already contain data it may not work as expected.

See this page for more info on Data Validation:

https://support.office.com/en-us/ar...

About half way down the page, check the Tips for working with data validation section.

Also, in the future, Excel questions are best asked in the Office Software forum.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Reply ↓  Report •
Related Solutions


Ask Question