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 by pasting the copied data in Navicat or to 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. Selecting columns works the same way. To select rows that are not next to each other, hold the Command key and click the row header of each row you want to select. For data pasting into other editing tools like TextEdit: First, open TextEdit. Then, paste the data in by using Cmd-V or control-click from the popup menu.