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

This type of control is truly one of Excel’s most helpful features, because the drop-down list can be almost anything. In this case, we’ll use a list of color names at the sheet level.