Moving Data Using the Clipboard

• ActiveX Instructions
• DLL Instructions

Overview

You can cut unformatted data from a selected cell or block of cells to the Clipboard, and paste unformatted data from the Clipboard into a selected cell or block of cells. Use the standard Clipboard keys to move data to (Ctrl+X) and paste data from (Ctrl+V) the Clipboard.

When pasting data from the Clipboard, if a block of cells is selected, the block is replaced with the Clipboard contents. If the contents of the Clipboard are bigger than the selected block, the contents of the Clipboard are truncated at the edge of the block.

If no cells are selected, the contents of the Clipboard are pasted into the sheet starting at the active cell. The contents of the cells to the right of and below the active cell are replaced by the contents of the Clipboard.

By default, column and row headers are included when data is cut and pasted and the pasted headers overwrite the selected headers. You can specify that column and row headers are not included when data is cut and column and row headers are not overwritten when data is pasted.