The Edit pulldown menu houses command for clipboard operations, deleting elements from cells, inserting and deleting lines and columns, duplicating cells, and editing of colors.

Screen snap: Edit pulldown menu

The Edit menu contains the following options

• "Cut" lets you cut selected cells to the clipboard. You can obtain the same action by clicking on the first icon of the second section of the 'General Functions' horizontal toolbar.
   
• "Copy" lets you copy selected cells to the clipboard. You can obtain the same action by clicking on the second icon of the second section of the 'General Functions' horizontal toolbar.
   
• "Paste" lets you paste clipboard content to the spreadsheet. You can obtain the same action by clicking on the last icon of the second section of the 'General Functions' horizontal toolbar.
   
• "Delete" opens to the following sub-menu when there are selected cell:

  

  1. "Delete All" lets you empty cells from their content and ornaments. Cells will become like it was at the sheet creation. You can obtain the same action by selecting "Delete Formulas" and then "Delete Formats".
      
  2. "Delete Formulas" lets you empty cells from their content. Cells' ornaments will not be deleted.
      
  3. "Delete Formats" lets you reset the cells' ornaments. Cells will become like it was at the sheet creation.
      
  4. "Delete Backgrounds" lets you reset the cells' background pattern. The default background pattern is the first in the "Pattern catalog" of the 'Cell Backgrounds' dialog box.
      
  5. "Delete Borders" lets you delete the cells' borders. You can obtain the same action by clicking on the first icon of the 'Cell Ornament' horizontal toolbar.
      
  6. "Delete Styles" lets you reset the cells' numeric format. The cells will get the default numeric format ("Standard") defined in the 'Numeric Format' dialog box.
      
  7. "Delete Positions" lets you reset cells' position parameters. The default position if left for text and right for numeric values, vertically centered on a single line, and writing from left to right.
      
  8. "Delete Fonts" lets you reset the cells' font. The default font is the "Style" font defined in the 'Font' dialog box.

  When frames are selected, "Delete" let you delete the selected frames.

• "Insert Rows" lets you insert lines at the selection level. The number of inserted lines depends from the selection lines number. Lines are inserted on top of the selection, so the selection and lines below are shifted down. Inserting and shifting only happens on the columns of the selection, then to insert a whole line you have to select a whole line. This command is not available if there are several selected areas or a whole column selected.
   
• "Delete Row" lets you delete lines at the selection level. All selection cells will be deleted and all the cells on bottom will be shifted up. To delete a whole line you have to select a whole line. This command is not available if there are several selected areas or a whole column selected.
   
• "Insert Columns" lets you insert columns at the selection level. The number of inserted columns depends from the selection columns number. columns are inserted on left of the selection, so the selection and right columns are shifted right. Inserting and shifting only happens on the lines of the selection, then to insert a whole column you have to select a whole column. This command is not available if there are several selected areas or a whole line selected.
   
• "Delete Column" lets you delete columns at the selection level. All selection cells will be deleted and all the cells on right will be shifted left. To delete a whole column you have to select a whole column. This command is not available if there are several selected areas or a whole line selected.
   
• "Copy to Bottom" lets you copy the content of first line from the selection to the remaining lines in the selection. The selection must contain more than one line to make this command avaible.
   
• "Copy to Right" lets you copy the content of first column from the selection to the remaining column in the selection. The selection must contain more than one column to make this command avaible.
   
• "Colors..." lets you edit the color list. It opens the 'Color' dialog box.