Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.

It's often useful to put a header or footer on the top or bottom of Excel spreadsheets. The header or footer might contain information about who prepared the spreadsheet, a disclaimer about the ...