# Find, Replace, Go To and Modify in Tables
# Find
Use the “Edit | Find” (Ctrl+F) menu command or the “Find” button on the Data Options toolbar to find specified text or numbers in a Table. The Find Dialog Box appears:
- Specify the exact entry you wish to find. This can be made case sensitive by checking the “Match case” box.
- Choose to search the “whole” table or a just a “selection”. Note – if a selection is required, it must be highlighted before choosing the find command.
- Choose to search “up” or “down” from the current cell. Once the end of the table is reached, the search reverts back to the beginning of the table.
- Click the “Find Next” button to find the first matching entry, and again for each subsequent matching entry. GSA displays a warning message if the specified text is not found.
# Go to
To find a specific record or page, use the “Edit | Go To” (Ctrl+G) menu command or the “Go To” button on the Data Options toolbar. The record/page can be specified in several ways:
| n | n go to record/page |
|---|---|
| n + | records n go forward by |
| - n | records n go back by |
| + | go to next non-blank record |
| - | go to previous non-blank record |
| * | go to highest non-blank record/page |
# Replace
Use the “Edit | Replace” (Ctrl+H) menu command or the “Go To” button on the Data Options toolbar to perform a search, as for Find, and also replace the specified text or numbers. The Replace Dialog Box appears. This operates as for Find dialog with additions:
- Specify the new entry you wish to replace the existing entry.
- Upon finding a matching entry, click the “replace” button, or you can choose to “replace all” matching entries.
# Modify
Use the “Edit | Modify” (Ctrl+M) menu command or the Modify button on the Data Options toolbar to modify numerical cell entries. Cells containing text remain unmodified. The Table View Modify dialog box appears. The modifications specified here are applied to every cell value in the “selection” or the “whole” table view. Specify the “modify by” value to be used in one of the following ways:
- Add– add the value in the Modify By box.
- Factor– factor by the value in the box.
- Power– raise to the power of the value in the box.
- Absolute– modify the selection to the absolute value (the modify by is ignored in this case).