You can copy data to and from cells using the Copy methods for the sheet.

When you copy data to a cell (or range of cells), the data replaces the data in the destination cell (or cells). If the operation copies a range of cells and pastes them to an overlapping location, the values of all the cells you are pasting are replaced with the values of the cells in the copied range.

You can specify whether formulas are automatically updated when cells or ranges of cells are copied. For more information on automatic recalculation, refer to Recalculating and Updating Formulas Automatically.

For more information on customizing Clipboard operations, such as copy, refer to Customizing Clipboard Operation Options.

Return to the overall list of tasks in Rearranging Data on a Sheet.