Press Ctrl + F to open Find
Type the word, number, or phrase you want to search
Click Find Next to move through matches
Click Find All to see every match at once
Use Options to search within a sheet or workbook
Choose Match case to search with exact capitalization
Choose Match entire cell contents to find exact matches only
Use Ctrl + H to open Find and Replace
Enter the search term in Find what
Click Find Next, Find All, or Replace as needed
Use the search box in the ribbon if available
Filter data to search within specific rows or columns
Use the search feature in tables or pivot tables when needed