How to Search for Words in Excel
Launch MS Excel., Find the Excel file you want to open., Open the file., Click a cell., Open the Find/Replace With window., Type in the words you want to find.
Step-by-Step Guide
-
Step 1: Launch MS Excel.
Do this by clicking on its icon in your desktop.
It is the green X icon with spreadsheets in its background.
If you don’t have an Excel shortcut icon on your desktop, find it in your Start menu and click the icon there. -
Step 2: Find the Excel file you want to open.
Click “File” in the upper left corner of the window then click “Open.” A file browser will appear.
Browse your computer for the Excel file you want to open. , Once you’ve located the file, click on it to select then click “Open” in the lower-right portion of the file browser. , Once you're in the worksheet, click on any cell on the worksheet to ensure that the window is active. , Hit the key combination Ctrl + F on your keyboard.
A new window will appear with two fields: “Find” and “Replace with.” , Enter the exact word or phrase you want to search for, and click on the “Find” button in the lower right of the Find window.
Excel will begin searching for matches of the word, or words, you entered in the search field.
All words in the document that matches those you entered will be highlighted to help you better locate them. -
Step 3: Open the file.
-
Step 4: Click a cell.
-
Step 5: Open the Find/Replace With window.
-
Step 6: Type in the words you want to find.
Detailed Guide
Do this by clicking on its icon in your desktop.
It is the green X icon with spreadsheets in its background.
If you don’t have an Excel shortcut icon on your desktop, find it in your Start menu and click the icon there.
Click “File” in the upper left corner of the window then click “Open.” A file browser will appear.
Browse your computer for the Excel file you want to open. , Once you’ve located the file, click on it to select then click “Open” in the lower-right portion of the file browser. , Once you're in the worksheet, click on any cell on the worksheet to ensure that the window is active. , Hit the key combination Ctrl + F on your keyboard.
A new window will appear with two fields: “Find” and “Replace with.” , Enter the exact word or phrase you want to search for, and click on the “Find” button in the lower right of the Find window.
Excel will begin searching for matches of the word, or words, you entered in the search field.
All words in the document that matches those you entered will be highlighted to help you better locate them.
About the Author
Andrew Flores
Brings years of experience writing about crafts and related subjects.
Rate This Guide
How helpful was this guide? Click to rate: