Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.
The default Google Sheets dropdown list allows the user to only select a single item from the list. I often want to select ...