Similar to other Microsoft® applications, you can use the Find, Replace, Select or Sort options to allow you to quickly find values or make multiple updates to your data. These options are located on the Home ribbon and can be used in the active workspace grid.
The Find option will take you to the cell which contains the value you enter in the Find dialog. Additionally, you can use the Ctrl button and the F key to return the Find dialog.
The Replace option will perform multiple replacement on values in the cells based on your input. The following conditions and exceptions impact how the Replace feature will function in the workspace:
•Fields which don’t allow direct typing in the cell, such as the period filter cells on Column Definitions, do not allow Replace to occur.
•Fields with drop-down lists will allow the replace to occur as long as the replacement text matches the beginning of a string in the list.
•Fields which are checkboxes, disabled cells, or are read-only will not allow the Replace function to change the value.
The Sort option will sort the data in the current open set or workspace.
The Select option will select all the data in the current open set or workspace. You can choose to “Select All” or “Select None” to clear your selection. You can then choose to Copy or Cut the information selected.