In the dialog box of the ribbon command Home | Search 
or Home | Replace 
, you can click on the Enlarge button, which expands the dialog box and offers additional options.
Clicking on Reduce makes the dialog box smaller again. This allows you to decide for yourself whether you would prefer to have many settings options or whether you would rather see as much of the worksheet as possible when searching.
The enlarged Search and 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 select which parts of the worksheet to scan: Cells, Comments or Frames (text frames and drawings containing text). |
▪Formulas
| If this option is enabled, all formulas in cells will be scanned. |
| For example, you can search for "Sum" to find all cells that use the SUM function. |
▪Results
| If this option is enabled, all results of formulas will also be scanned. |
| For example, when you search for "4", cells containing the calculation =2+2 will also be found. |
| (This option is only available for the search command but not for the replace command.) |
▪Values
| If this option is enabled, all fixed values will be scanned (thus, manually entered numbers, strings, etc.). |
▪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 all worksheets that are currently selected in the worksheet register). |
▪Search by column
| If this option is enabled, the worksheet will be scanned column by column. |
| If it is disabled, the worksheet will be 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 in any position. If you enter "win" in the Search for field, PlanMaker will also find cells containing "windows" or "sales, winter 2018". |
| If you enable this option, however, 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 wildcard by clicking on it.
You can repeat and combine these wildcards as desired within your search term. Furthermore, you can use them in combination with normal text.
"Search all" button
You can click on the Search all button to obtain a list of all occurrences of the search term. When you click on one of its entries, PlanMaker jumps to the corresponding occurrence in the document.
Note: This button is only available when the option Search in is set to Cells.