Excel's drop-down menus are useful for creating order forms and navigation for larger files like records of sales. The options in the menus are references to cells elsewhere on the spreadsheet.

Click on the heading of the column you want to evaluate for duplicates. Click and drag from one heading to the next to select more than one column. Hold down the "Ctrl" key and click to select columns ...