![]() A Few BugsĪs awesome as this new feature is, there are a few things I'd like to be improved. You can see that the results include phrases like Fuji Apple and Granny Smith Apple, which contain the search term but don't start with it. ![]() In the example below I am searching for apple. ![]() This means the item you are searching for does NOT need to start with the search term. The search currently performs a “contains” type search for whole words. You can select a result with your mouse or use the arrow keys and press Enter. A list of results will appear that match your search term. With the new update, you can now type your search directly in the cell that contains the dropdown list. Video Tutorialĭownload the List Search Add-in How to Search Data Validation Lists It also contains some features that are not available yet in the native search feature in Excel. If you are NOT on the latest version of Excel for Microsoft 365, then the add-in will still be a great solution for you. I originally wrote this post when the feature wasn't available, and it contains info on an add-in I developed called List Search, that allows you to search drop down lists in cells. It's a feature I've been waiting on for a long time, and I'm happy it's here! Once the feature is fully flighted, it eventually moves to the Monthly and other channels. It is also flighted, which means not all users on the Beta Channel will have it immediately. It's important to note that the feature is currently on the Insiders Beta channel for Microsoft 365. In January of 2022, Microsoft released an update that lets you search dropdown (data validation) lists in the desktop version of Excel. ![]() Skill level: Beginner New Feature to Search Dropdown Lists Bottom line: Learn a fast and easy way to search any data validation list or in-cell drop-down list with the new Excel feature or free tool.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |