Edit Menu

The Edit menu contains a series of practical data editing commands.

Undo / Redo operation

These simple commands allow you to cancel or restore the last operation made.

Copy, Cut and Paste

It is possible to copy/paste cells, rows or selected text (unless protected), just as you can do it in Excel.

  • Select the line or the area of data to be copied
  • In the Edit menu, select the Copy or Cut command
  • Move to the row or the area where the information should be copied
  • From the Edit menu, select Paste

The user can also copy/paste by using the icons  or press Ctrl+C to copy, Ctrl+X to cut and Ctrl+V to paste.
There are also commands such as Copy rows, Delete rows and Paste rows: in this case they refer to a full row or rows and not to a cell selection. For this purpose the commands Copy, Cut and Paste should not be used.

Select all

This command selects all the active table.

Copy row from above (F4 or Cmd + 4)

This command is very practical and allows you to copy the contents of the cell above to the one you are in. Applicable to a single cell, several cells or an entire row.

Execute command (F6 or Cmd + 6)

This command performs various practical functions depending on the cell in which you are located. More information on the Interface page.

Insert rows... (Ctrl+ +)

This command inserts blank rows above the selected row:

  • Position the cursor below the line where the empty rows are to be inserted
  • From the Edit menu, select the Insert rows ... command
  • In the window that appears, type the number of rows to be inserted
  • Confirm with OK.

Add rows...

To insert blank rows below the selected row, follow these steps:

  • Move the cursor above the row where additional rows need to be inserted
  • From the Edit menu, select the Add rows command
  • In the window that appears, key in the number of rows to insert
  • Confirm by clicking on OK

There is still another procedure to add blank rows:

  • Move the cursor above the row where additional rows need to be inserted
  • Click on the following icon  on the Tool bar, one time for each row that you want to add. This procedure is advised when the amount of rows to be added is rather limited. The sequence for the shortcut key is: Ctrl+Enter.

Duplicate rows...

This command duplicates the selected row (s).

Copy rows ... (Ctrl + Shift + C)

This command copies the selected rows. If rows are copied, the command Insert copied rows is automatically activated, which can be exploited by positioning the mouse at the point where you want to insert the previously copied rows.

Delete rows... (Ctrl+ -)

In order to delete one or more rows, select the row or rows that need to be deleted and from the Edit menu, click on the Delete rows command.

Protect/Unprotect rows

Using the Protect rows command, from the Edit menu, the user activates rows protection to avoid making any changes by mistake.
The protected rows cannot be edited until, by using the Unprotect rows command, the protection is being removed.

To put protection into effect:

  • Select the desired row(s) to protect
  • From the Edit menu, select the Protect rows command
  • Confirm the number of rows to be protected by clicking on OK.

Protected rows have light grey row numbers. In order to edit them again, first remove the protection by the Unprotect rows command in the Edit menu.

 

Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | Email