Add Letter Headings in Excel Drop Down List
This video shows the easy steps to add letter headings in a drop down list on an Excel worksheet.
This makes it easy to get to a specific letter, in a long list of items.
To use the list, type any letter in the drop down cell.
Next, click the drop down arrow, and the list will open at the letter that you typed.
To get the Letter Headings in Excel Drop Down List workbook, go to this page:
https://www.contextures.com/exceldrop...
0:00 Introduction
0:22 Drop Down Lists
0:43 Sample File Macros
1:16 Create List of Letters
1:54 Add Letters to List
2:22 Use the Drop Down
2:44 Remove Letters from List
3:23 Get the Workbook
Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips