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.

Deleting rows from a large filtered range in Microsoft Excel can take a long time, temporarily place the program into a "not responding" state, or—in a worst-case scenario—cause Excel to crash ...