Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

Use the Search box as a quick way to look up particular items in a list. The Search box is in the title bar at the top of the SharePoint or Lists app. It lets you search for text in any list item in the currently open list. 

The Search box is located in the title bar at top of the app.

Search for items in a list

  1. Open the list you want to search in.

  2. Select the Search box at the top of app window.

  3. Enter the word or words you want to search for.

    As you type, an Items menu appears immediately below the Search box with a list of the first five (or fewer) matches for your search term.

  4. Select any item in that list to open that item and see all its details.

    Alternately, just below that list, you can select Show more results to get a complete list of the items that match your search term.  

You can then peruse the results or select one or more items to edit or open. See Edit list items for more information. 

How searching works

When you use the search box, you're searching through the list in all the columns that contain text, except for  columns that contain automatically generated measurements like date and time or file size. 

  • If you search for a single word, the Results will show the items that contain that word.

  • If you search for multiple words, the Results will show all the items that contain all of those words.

    For example, if you search for blue gold, the Results list will only show items that have both blue and gold in them. The results list won't include items that only contain blue or only contain gold. Said another way, the words in a multi-word search are treated as if they are joined by an AND operator. There is no OR operator for searching in a list.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!