Cut, Copy, and Paste

Cutting, copying, and pasting text are useful if you want to move data from one location to another. EasySpreadsheet allows you to copy cell data, formulas, or formats, and paste them into other cells.

Cutting

Cutting will put data (or formulas, or formats) onto an imaginary clipboard. The cell(s) that you cut will become empty - the data, formulas, and cell formatting will be removed. The cell contents that you removed can then be pasted (from the imaginary clipboard) to another location in your sheet.

To cut:

  1. Select the cell(s) that you wish to cut.

  2. Now:

  1. The contents of the cells that you cut will be removed, and placed on the imaginary clipboard. You are now ready to paste.

 

Copying

Like cutting, copying will put data (or formulas, or formats) onto an imaginary clipboard. Unlike cutting, the cells that you copy will NOT become empty - the data, formulas, and cell formatting will NOT be removed. The cell contents that you copied can then be pasted (from the imaginary clipboard) to another location in your sheet.

To copy:

  1. Select the cell(s) that you wish to copy.

  2. Now:

  1. The contents of the cells that you copied will placed on the imaginary clipboard. You are now ready to paste.

 

Pasting

After cutting or copying cells, you can paste the data (or formulas, or formats) found on the imaginary clipboard back into your sheet.

To paste:

  1. Select the cell(s) that you wish to paste to.

If you will be pasting formulas or values (data), be aware that the number of cells that you select makes a difference:

If you will be pasting formats, the formatting will be applied to all of the cells that you select.  

  1. Go to the Edit menu. Here, you have a few pasting options:

Note: You may also paste by right-clicking to access the Quick-task Menu. Click Paste Special, and a window will appear, allowing you to paste All, Formulas, Values, or Formats. Or, for a standard paste (formulas and formats), click Paste. Also note that the keyboard shortcut for a standard paste is Ctrl+V.

 

See Also:

AutoFill

Copying and Pasting Formats