217 days ago,
Navicat not only provides you with standard spreadsheet tools, but also a grid view for you to manipulate your data. In this tutorial, we will show you how to copy a row, column, or group of cells by pasting the copied data in Navicat or other editing tools.
The easiest way to select a row is to click on the row header. To select several rows that are next to each other, you can click the row header of the first row, and then click the last row while pressing the SHIFT key. To select rows that are not next to each other, hold the CTRL key and click the row header of each row you want to select. Selecting columns works the same way.
For data pasting into other editing tools like Excel: First, open Excel. Then, place the cursor in anywhere you want, and paste the data into the spreadsheet by pressing CTRL+V or right-clicking on the popup menu. Now, we will show you how to select and copy a range of cells. You can drag on the first cell, and drop to the target cell easily.
Then, simply press CTRL+C or right-click from the popup menu to copy the data.
Now open another table in Navicat, select the range of cells you wish to paste and press CTRL+V or right-click from the popup menu.