Copying, Moving, and Deleting Rows and Columns

When copying, moving, and deleting rows and columns, keep in mind the following points:

  • Moving a row or column will delete the source row or column after you paste the contents in a new position.

  • Copying a row or column will keep the source row or column after you paste the contents in a new position.

  • If you copy or move a row or column, you can paste it only in the same grid.

  • You must copy or move the entire row or column.

To copy or move rows and columns in grids, select the desired rows or columns, and then right-click or click the down arrow in the header, and select either Copy or Move. Then, select the row or column that you want to move the rows or columns, and right-click or click the down arrow in the header, and select Paste Before or Paste After.

To delete rows or columns, select the desired rows or columns, and then right-click or click the down arrow in the header and select Delete.