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.