Navicat simplifies the data manipulation process with just a few clicks. In this tutorial, we will show you how to modify data in multiple cells easily. To select a range of cells, now you can directly drag on the first cell, and drop to the target cell. Moreover, you can directly edit data in multiple cells. To do this, enter a new value directly in the highlighted cells. To save the changes, click the bottom toolbar or move to another row. Besides this, you can update the data by the Find and Replace feature. To do this, 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.
