Worksheet table shows list of employees from the selected region, using INDEX/MATCH formulas.

Select Region name from a data validation drop down list. The data validation list opens at the letter you typed, so it's easy to find what you need. The workbook has buttons to run macros that add the letter headings, or remove them.Īfter the letter headings are added, type a letter in a cell, then click the drop down arrow.

Excel File and I nstructions: Letter Headings in Drop Down List.

Set the number of top products by typing a number on the Lists sheet.Īdd single-letter headings in a long list of items, so it's easier to navigate in the list. Product drop down on Orders sheet shows latest used product names at the top, with remaining products below that, listed alphabetically.

Excel File and In structions: Drop Down List - Top Items.

Use the SORTBY function (Microsoft Excel 365) to create drop down list with latest items at top, others below that, A-Z. Unblock Files Data Validation DV0078- Drop Down with Latest Items at Top

Excel sheet download for windows 10