On working with data in table area via clipboard, the following operations are available:
Copy.
Move.
Paste.
To copy cell values or selected cell range to clipboard:
Click the
Copy button of the Home ribbon tab:
Select the Copy context menu item of the cell or cell range.
Press CTRL+C.
To move cell values or selected cell range to clipboard:
Click the
Cut button of the Home ribbon tab.
Select the Cut context menu item of the cell or cell range.
Press CTRL+X.
To paste values of the cell or selected cell range from clipboard to the current table area location:
Click the
Paste button of the Home ribbon tab.
Select the Paste context menu item of the cell or cell range.
Press CTRL+V.
If pasted range is out of the table area, then paste will be performed inside table area.
If the size of selected for paste cell range is less, then the range size where data is pasted will be broaden right and button to the size of pasted range.
If the size of selected for paste range is greater, then only the range corresponding to the size of psted range wille be filled in.
If the range is selected for cell paste, the range will be entirely filled with data from the cell.
See also: