Can I Find & Replace data in my Worksheet?

Yes, Enterprise CORE includes functionality that lets you locate specific data in your Worksheet and replace all instances with new values. This feature saves time, maintains consistency, and reduces manual entry errors.

How it works: 

Worksheet Cell-Level Find & Replace:

1. Enter Edit Mode. Open the Worksheet and switch to Edit Mode. 
2. Select a Cell. Locate the cell you want to modify and open its dropdown menu. 
3. Click the pencil (edit) button to reveal a side panel.
4. Modify the value as needed. 
5. Confirm Changes. A confirmation prompt will display, showing how many instances will be affected.
6. Proceed to update, and all related values in the Worksheet will be updated automatically. 
7. Save Updates. Click Save for the changes to take effect.

Tip: This approach allows precise, cell-level updates while ensuring all related instances in the Worksheet remain consistent.

Worksheet Column-Level Find & Replace:

1. Enter Edit Mode. Open the Worksheet and switch to Edit Mode. 
2. Click the single book icon in the column header to reveal the side panel. 
3. Select the Column. Navigate to the column containing the data you want to modify. 
4. Select the Item. Choose the specific item or value you want to update. 
5. Modify the value as needed. 
6. Confirm Changes. A confirmation prompt will display, showing how many instances will be affected.
7. Proceed to update, and all related values in the Worksheet will be updated automatically. 
8. Save Updates. Click Save for the changes to take effect.

Tip: Column-level Find & Replace is ideal for large datasets, ensuring consistency and saving time compared to editing individual cells.