Editing Functions

Functions that enable you to copy and move data in the data entry grid are available by right-clicking the mouse and from the Edit menu at the top of the form. Forms 25, 26 and 27 provide Cut, Copy, Delete Rows, Duplicate Rows, Insert, Paste Insert and Paste Overwrite functions. Form 26A rows should be unique, so the Duplicate Rows function is not available.

• 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
    
    
• Paste 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.
  
  

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

  • Keyboard shortcut: Ctrl-V

     

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

• Duplicate Row - 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.