The Freeze feature in Excel allows you to scroll down through hundreds of rows and still see the original headers or field names in row 1, or scroll over hundreds of columns and still see the data ...
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.