The Edit Menu

The Edit Menu

Edit->Undo (Ctrl+Z)

Undo the last action.

Edit->Redo (Ctrl+Shift+Z)

Redo the last undone action.

Edit->Cut (Ctrl+X)

Put selected item(s) into the clipboard and remove them from the original location. If you then do a Paste the item(s) will be be inserted at the new location.

Edit->Copy (Ctrl+C)

Copy selected item(s) to the clipboard.

Edit->Paste (Ctrl+V)

Paste item(s) from the clipboard to the selected cell(s).

Edit->Special Paste...

Special forms of Paste. See the sections Other Paste Modes and Arithmetic using Special Paste for more details.

Edit->Paste with Insertion

Move content of the paste area either to the right or down and paste item(s) from the clipboard to the selected cell(s).


Fills up the selected area with the values from the first item-set. All four directions are supported. Note that the term "item-set" describes the first set of values seen in the fill direction. If the fill direction is Left then the first item-set is the last column of the selection.

Edit->Find... (Ctrl+F)

Find cell containing given text.

Edit->Find Next (F3)

Find the next cell containing given text.

Edit->Find Previous (Shift+F3)

Find the previous cell containing given text.

Edit->Replace... (Ctrl+R)

Find and replace given text in cell(s).


Clear text, Comment, Validity or Conditional Cell Attributes from selected cell(s).


Delete everything from selected cell(s).

Edit->Conditional Cell Attributes...

Add or modify conditional cell attributes.


Set or modify the error checking criteria and error alert message for selected cell(s). See Validity Checking for more details.

Edit->Modify Cell (Ctrl+M)

To modify selected cell in-situ.

Edit->Transform Object...

Rotate, scale or move the selected object.