Working with Data Using Clipboard

On working with data in table area via clipboard, the following operations are available:

Copying Data to Clipboard

To copy cell values or selected cell range to clipboard:

When data range autofilter is used on a data entry form sheet or in table area, data copying to clipboard is applied only to visible rows/columns.

Cutting Data to Clipboard

To cut cell values or selected cell range to clipboard:

When data range autofilter is used on a data entry form sheet or in table area, cutting data range to clipboard is applied to all rows/columns during filtering regardless of their visibility. Behavior will be identical for the entire data range regardless of filter position.

Pasting Data from Clipboard

To paste values of the cell or selected cell range from clipboard to the current table area location, press CTRL+V.

When the following is used for pasting:

The information message is displayed informing about the necessity to use shortcuts.

Features of Data Pasting from Clipboard

Behavior will be identical for the entire data range regardless of filter position.

Formatting Parameters on Pasting from Clipboard

The Interactive Data Entry Forms extension supports pasting of data on copying from the products:

Clipboard contents is pasted to a data entry form sheet:

NOTE. When data is pasted from MyOffice and Google Sheets, source formatting is not saved.

See also:

Data Entry and Saving | Building Data Entry Form | Working with Ready Data Entry Form