In this case, we’ll use the Insert Data button to see if they’re all Kentucky counties as follows: Click the Insert Data button. Choose Admin Division 1 (State … ) (Figure C). Figure C ...

Get more Excel tips How to add color to an Excel drop-down list If you’ve used data validation controls, you know how easy they are to add and how helpful they can be.