Define your data as a Excel Table, then you can add a "slicer" to select the first letter
.
- Define data as an Excel table:
https://support.microsoft.com/en-us/office/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664
. - Insert Slicer
https://support.microsoft.com/en-us/office/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d
.
I haven't tested this new feature, but you may find it useful
Better, searchable drop down lists in Excel
https://office-watch.com/2022/better-searchable-drop-down-lists-in-excel/
1 February 2022
Excel is getting a long overdue improvement to its drop-down list selector. At long last we’re getting AutoComplete or Search for pull-down lists.
You’ll be able to type a search into the drop-down list so Excel can show all the matching results. For example, type CO to reduce a long list of companies to one with only those two letters.
Or, in the drop down filter button, you can type into the "Search" to reduce hits
Same list above, typed just letter "D" to find entries with a "D" anywhere. As you type more char the list is slimmed down
ie type DE to filter further to 2 potential entries
Contact List Templates, or Advice
Creating a business phone directory
I am making a company contact list that will be changing and not sure which route to take.
Using Excel / Google Sheets as a contact list and mini-CRM
Videos
Hello all,
Looking for some advice. I am not an Excel novice, but this one is stumping me a little.
I need to create a robust and searchable contact list. Currently, I have this as several individual tables in an Outlook email, that I update as-and-when. I feel as though Excel has a solution, but I’m struggling to visualise it.
The individual tables I have are “departments”. Within the table itself the headings are: Company, Name, Email, Phone, and Notes.
The same people might appear in multiple tables for various reasons, but mostly the tables are unique.
I literally can’t visualise a way to do this that is clean. The best I have right now is stick it all in a single data set, and filter down. But I imagine there has to be a cleaner, and more optimal way to do this. Does anyone have any suggestions? I would be really grateful if so.
Define your data as a Excel Table, then you can add a "slicer" to select the first letter
.
- Define data as an Excel table:
https://support.microsoft.com/en-us/office/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664
. - Insert Slicer
https://support.microsoft.com/en-us/office/use-slicers-to-filter-data-249f966b-a9d5-4b0f-b31a-12651785d29d
.
I haven't tested this new feature, but you may find it useful
Better, searchable drop down lists in Excel
https://office-watch.com/2022/better-searchable-drop-down-lists-in-excel/
1 February 2022
Excel is getting a long overdue improvement to its drop-down list selector. At long last we’re getting AutoComplete or Search for pull-down lists.
You’ll be able to type a search into the drop-down list so Excel can show all the matching results. For example, type CO to reduce a long list of companies to one with only those two letters.
Or, in the drop down filter button, you can type into the "Search" to reduce hits
Same list above, typed just letter "D" to find entries with a "D" anywhere. As you type more char the list is slimmed down
ie type DE to filter further to 2 potential entries
Hi dawncorbett,
Thank you for posting in this Community.
There are several phone directory templates available in Excel. Like shown below:
Organizational telephone list (office.com)
Basic customer contact list (office.com)
Address and phone list (office.com)
Unfortunately, I am sorry none of them have the tabs A-Z. So, you may create them bu yourselves.
If you have further concerns, feel free to contact me.
Best Regards,
May