Open Excel on your computer. It’s in the All Apps section of the Start Windows Start menu in Windows, and the Applications folder in macOS.
Open the file you want to search. Press Ctrl+O, select the file, then click Open.
Click Find & Select. It’s the magnifying glass icon at the end of the ribbon bar, near the top-right corner of Excel. A menu will expand.
Click Find…. This opens the “Find and Replace” window.
Type the word or characters you want to find. This goes into the “Find what” box.
Click Find Next. It’s at the bottom of the window, near the center. This will search the current spreadsheet for the what you’ve typed. The first instance is now outlined in green.
Click Find Next to find the next instance. You can keep clicking this button to move through every instance of the word or characters you’ve typed.
Click Find All to view all matches at once. A list of matching values will appear at the bottom of the “Find and Replace” window.
Click Close when you’re finished.
Comments
0 comment