Navicat simplifies the data manipulation process with just a few clicks.
To select a range of cells, you can directly drag on the first cell, and drop to the target cell. You can also edit data in multiple cells directly by entering a new value in the highlighted cells. To save the changes, click the bottom toolbar or move to another row.
You can update the data by the Find and Replace feature.
Select “Replace” from “Edit” in menu.
Then enter keywords to find and replace in the text boxes respectively. You can first look for the desired cells before replacing data directly.
The number of changes is also shown.
Click “tick” to confirm the changes.