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:
Select the cell(s) that you wish to cut.
Now:
Go to the Edit menu, and select Cut. Or,
Right-click so that the Quick-task Menu appears, and select Cut. Or,
Press Ctrl+X on your keyboard.
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:
Select the cell(s) that you wish to copy.
Now:
Go to the Edit menu, and select Copy. Or,
Right-click so that the Quick-task Menu appears, and select Copy. Or,
Press Ctrl+C on your keyboard. Or,
In Advanced Mode, click the Copy button (shown below).
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:
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 select one cell, but cut (copied) more than one cell, then all of the cut (copied) cell will be pasted. For example, perhaps you cut a group of four cells (two-rows by two-columns), but only selected one cell when you pasted. All four cells will be pasted. The top, left cell of the pasted group will be at the cell that was selected.
If you select a group of cells with the same dimensions as the group that you cut (copied), then the cut (copied) cells will be pasted directly into the selected cells. An example is cutting a two-row by two-column group of cells, then selecting a two-row by two-column group of cells when you paste.
If you select a group of cells that does NOT have the same dimensions as the group that you cut (copied), all of the selected cells will be filled with data when you paste - even if you selected more cells than you cut (copied). If you selected less cells than you cut (copied), then you will lose some data. For example, perhaps you cut a two-row by two-column cell group, but only selected a one-row by two-column group when you pasted. The first row will appear, but the second row of the cut cells will NOT be pasted.
If you will be pasting formats, the formatting will be applied to all of the cells that you select.
Go to the Edit menu. Here, you have a few pasting options:
Paste Formulas: The cell contents will be pasted along with their formulas. When you click on a cell, its formula, such as =SUM(A1:A20), will appear in the text box above the sheet. This pasting option is useful if you have used formulas and would like to be able to update or modify them. Formats will not be pasted.
Paste Values: The cell contents will be pasted, but their formulas will be lost. When you click on a cell, the value will appear in the text box above the sheet. Formats will not be pasted.
Paste Formats: This option will not paste the actual cell contents; that is, the formulas or values of the selected cells will NOT be changed. Instead, the formatting (font, alignment, color, etc.) of the cut (copied) cells will be pasted. For more help, see Formatting Text and Numbers.
Paste: This standard option will paste the formulas and the formats of the cut (copied) cells.
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: