If you click on the Enlarge button in the dialog box of the ribbon command Home | Search 
or Home | Replace 
, the dialog box expands to offer additional options.
Clicking on Reduce makes the dialog box smaller again. Thus you can specify the appearance of the dialog box according to your preference for having the most options at your disposal or for having as much of the worksheet as possible visible while you are searching.
The enlarged search/replace dialog box offers the following additional options:
"Search in" section
Here, you can specify how to scan the document:
▪Search in
| Use this dropdown list to choose which parts of the table to scan: Cells, Comments or Frames (text frames and drawings containing text). |
▪Formulas
| Scan formulas as if they were just text strings. |
| For example, when you search for "sum", all cells using the SUM function will be found. |
▪Results
| Scan the results of formulas. |
| For example, when you search for "4", cells containing the calculation =2+2 will also be found. |
| (Only available for the search command, not for the replace command.) |
▪Values
| Scan all fixed values (e.g., numbers and text strings typed in manually). |
▪Whole document
| If this option is enabled, all worksheets in the document will be scanned. |
| If it is disabled, only the current worksheet will be scanned (or, respectively, all worksheets that are currently selected in the worksheet register.) |
▪Search by column
| If this option is enabled, the table will be scanned column by column. |
| If it is disabled, the table is scanned row by row. |
"Options" section
Here, you can specify the following options for searching:
▪Case sensitive
| The case of letters in the search term is ignored by default. Thus, if you search for "house", not only "house", but also "House", "HOUSE", "HouSe", etc. will be found. |
| If you enable this option, however, the program will only find those occurrences of the search term where the cases of the letters correspond exactly to the cases of the letters in the search term. Thus, if you search for "house", only "house" will be found. |
▪Whole cell match
| By default, PlanMaker finds all cells that contain the search text at any position. If you enter "win" in the Search for box, PlanMaker will also find cells containing "windows" or "sales, winter 2018". |
| However, if you enable this option, the entire cell content must match the search term. When searching for "win", only cells with the exact content "win" will be found. |
"Special" button
The Special button allows you to use the following wildcard characters in your search terms:
▪Single arbitrary character (^?) – this placeholder represents a single arbitrary character. For example, when you search for "fo^?d", PlanMaker finds occurrences of "fold", "fond", "food", etc.
▪Multiple arbitrary characters (^*) – this placeholder represents any number of arbitrary characters. For example, when you search for "f^*r", PlanMaker finds occurrences of "fair", "flyer", "freighter", etc.
▪Caret (^^) – searches for the character "^" (caret).
▪Line break (^a) – searches for manual line breaks (inserted with Ctrl+↵).
To insert such a wildcard into the search term, click on the Special button and then select the desired placeholder by clicking on it.
You can repeat and combine these wildcards at will within the same search term. Furthermore, you can use them in combination with normal text.
"Search all" button
You can click the Search all button to receive a list of all occurrences of the search term. When you click one of its entries, PlanMaker jumps to the corresponding occurrence in the document.
Note: This button is only available when the Search in option is set to Cells.