Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Copy - copies one or more cells to the Windows clipboard. The cell contents can then be pasted into other cells or even into other applications (including text editors or spreadsheets). 
    • Keyboard shortcut: Ctrl-C

  • Cut - is identical to Copy except that the data is removed from the selected cells.
    • Keyboard shortcut: Ctrl-X

  • Insert - creates a new row above the currently selected cell and pastes data from the clipboard into that new row, beginning at the cell immediately above the selected cell.

  • Overwrite - pastes the data into an existing (possibly empty) row, beginning at the selected cell.

    • Keyboard shortcut: Ctrl-V 

      Div
      stylemargin-top: 20px;margin-bottom: 30px;
      Note

      If you have copied or cut only part of a row, it is essential that you paste into the same columns; otherwise the data you paste may end up in an unintended column and fail validation.

 

  • Duplicate Rows - copies an entire row or set of rows to the row after the last used row. You can select one or more cells in the grid, possibly in several adjacent rows; you do not need to select the entire row.

  • Insert Rows - adds one or more empty rows after the currently selected cell(s). To insert multiple rows, select cells in as many rows as you want to insert, then choose Insert Rows.

  • Delete Rows - deletes all the rows in which you have selected cells. There is no need to select the entire row.