When we select cell B2 and click the drop-down button, we see the list of appetizers from the “Lists” sheet.
BONUS FEATURE: Notice how the blank cells that were selected do not show up in the drop-down. Before this new version, any extra cells would have been displayed, making the list appear less than professional. This relieves us of the need to convert the lists to proper tables or utilize Named Ranges with complex formulas to suppress blanks while making lists easily expandable.
“I want something with cheese.”
Looking through longer lists (say, hundreds of entries), if I want to see all entries that have “cheese” in the name, I can click in the cell and type the first few letters of “cheese”. Look what happens.
The drop-down list automatically reduces its scope to only display entries that contain the typed character string.
We can apply this drop-down list feature to many cells in the “Appetizer” column by selecting cell B2 and clicking Copy, then select additional cells (ex: B3 through B25) and click Home (tab) -> Clipboard (group) -> Paste -> Paste Special -> Validation.