Skip to Main Content
Spreadsheet Opened in the Desktop App
- Go to the right hand side of the Home ribbon, click on the magnifying glass icon.
- Select Find from the drop down menu.
- In the Find what box type in the keywords, or parts of words you want to search for.
- Click Find All.
- For example, if you type in psych the results returned will include all words with psych anywhere in the word.
- Expand the box (click and drag on bottom right corner) to view the titles properly in the Value column.
- To see the title and related information on the spreadsheet, hover over and click on the row of the title you are interested in. It will then be highlighted (thin green line around the title cell) and in most cases is in the top or bottom row of the spreadsheet visible on your screen.
Spreadsheet Opened in a Browser
- Go to the right hand side of the Home ribbon, click on the magnifying glass icon.
- Select Find from the drop down menu.
- In the Find what box type in the keywords, or parts of words you want to search for.
- Click Find All.
- For example, if you type in psych the results returned will include all words with psych anywhere in the word.
- You cannot expand the Find pop-up box when opened in a browser, so to see any titles that haven’t displayed fully in the Value column, hover over the title and it will display in a tool-tip.
- To see the title and related information on the spreadsheet click on the row of the title you are interested in. It will then be highlighted in green on the spreadsheet, as will any titles from the search near the selected title.
