How to Search for Words in Excel

An Excel document can be overwhelming to look through. Thankfully, you can use the search function to conveniently locate a particular word, or group of words, in an Excel worksheet. Launch MS Excel. Do this by clicking on its icon in your...
Part 1 of 2:

Opening an Excel Worksheet

  1. How to Search for Words in Excel Picture 1How to Search for Words in Excel Picture 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.
    1. If you don't have an Excel shortcut icon on your desktop, find it in your Start menu and click the icon there.
  2. How to Search for Words in Excel Picture 2How to Search for Words in Excel Picture 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.
  3. How to Search for Words in Excel Picture 3How to Search for Words in Excel Picture 3
    Open the file. Once you've located the file, click on it to select then click 'Open' in the lower-right portion of the file browser.
Part 2 of 2:

Searching for Words

  1. How to Search for Words in Excel Picture 4How to Search for Words in Excel Picture 4
    Click a cell. Once you're in the worksheet, click on any cell on the worksheet to ensure that the window is active.
  2. How to Search for Words in Excel Picture 5How to Search for Words in Excel Picture 5
    Open the Find/Replace With window. Hit the key combination Ctrl + F on your keyboard. A new window will appear with two fields: 'Find' and 'Replace with.'
  3. How to Search for Words in Excel Picture 6How to Search for Words in Excel Picture 6
    Type in the words you want to find. 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.
    1. 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.
4 ★ | 1 Vote