Excel 2010 Cell Validation - Grouped List <p>Is it possible (without the use of user forms, or form controls) to have a grouped validation list in-cell, where the group title cannot be selected. So for example:</p> <p><strong>Fruit</strong><br> Apple<br> Banana<br> <strong>Veg</strong><br> Potato<br> Carrot</p> <p>I feel like I've been searching for an absolute age now, and I'm getting no where fast. The reason I cannot use form controls as that there are 8 sheets, each with a few thousand rows (possible) and each entry must have this selection. I have done this before with dependant lists across multiple columns but I'd like to trim everything down.</p> <p>Any ideas? I don't want a clear cut solution if one exists, just a nudge in the right direction. Any help appreciated.</p>