Here are some examples of advanced searches.

You want to search for specific data in a column?
Simply click the search icon in the column heading and type the first letters of the search element. The table is sorted by the selected column and the first element that matches the search is automatically selected.
For example:

• Click on the magnifying glass:
  
• The Table is sorted by the selected column and the Edit control appears:
  
• The user starts typing the desired word:
  

You can also right-click the column heading and select "Find" in the context menu. The column heading becomes an Edit control, allowing the user to type the desired word.
For example:

• The user selects the "Find" option:
  
• The Table is sorted by the selected column and the Edit control appears:
  
• The user starts typing the desired word:
  

Some of your controls contain a lot of text? You can easily search for specific content in these controls!
Simply use the "Find" option in the context menu.
You can also press Ctrl + F. In this case, the search is performed on the content of all the controls in the window.

To search in a document:

1. On the "Home" tab, in the "Editing" group, click "Find" (or press Ctrl + F).
2. In the window that is displayed, specify:
   • the word or phrase to be found,
   • search options: case-sensitive, whole word.
3. Start the search.
4. The list of results is displayed in the search window.
   
   • When you select one of the occurrences in the search window, it is also selected in the document.
   • The arrow buttons can be used to navigate between the different occurrences. The search words are highlighted in the text.

Note: To replace a previously performed search, simply click on "Replace" at the top of the window.

1. On the "Home" tab, in the "Editing" group, click "Replace" (or press Ctrl + H).
2. In the window that is displayed, specify:
   • the word or phrase to be found,
   • search options: case-sensitive, whole word,
   • the new text.
3. Start the search.
4. The list of results is displayed in the search window.
   
   • When you select one of the occurrences in the search window, it is also selected in the document.
   • The arrow buttons can be used to navigate between the different occurrences. The search words are highlighted in the text.
5. Choose "Replace" to replace only the selected occurrence.
6. Choose "Replace all" to replace all the occurrences.

To search in a spreadsheet:

1. On the "Home" tab, in the "Editing" group, click "Find" (or press Ctrl + F).
2. In the window that is displayed, specify:
   
   • the word, phrase or value to be found,
   • search options: case-sensitive, in all sheets, in formulas.
3. Start the search:
   • When you click "Find", the occurrences are highlighted and the first occurrence is selected.
     
     The "Next" button highlights the next element that matches the search.
   • When you click "Find all", the list of cells that match the search is displayed.
     
     When you select one of the occurrences in the search window, it is also selected in the worksheet.

1. On the "Home" tab, in the "Editing" group, click "Replace" (or press Ctrl + H).
2. In the window that is displayed, specify:
   
   • the word, phrase or value to be found,
   • search options: case-sensitive, in all sheets, in formulas.
   • the new text.
3. Start the search.
   • When you click "Find", the different occurrences are selected and the first occurrence is highlighted. The "Next" button highlights the next element that matches the search.
   • When you click "Find all", the list of cells that match the search is displayed.
4. Choose "Replace" to replace only the selected occurrence.
5. Choose "Replace all" to replace all the occurrences.