The Copy Cell Values instruction can be used to copy data from one range to another in Excel.
Data being copied can include the contents of an individual cell (e.g. A1) or of a cell range (A1 to C11). For example, assume you want to copy the data below in columns A and B to columns D and E:
The "steps" in this article provide instructions on how to perform the copy in the screenshot above.
1. In an action step in your process, select the Copy cell values instruction viaMicrosoftf Excel > Copy > Copy cell values.
2. Select your source file, worksheet and cell range.
3. Select your target file, worksheet and starting cell.
4. Save and run the instruction. The data from the source range should have been successfully copied to the target range.
Tips and tricks:
You can configure the Copy cell values instruction to either copy or ignore the format of the source cells by checking or unchecking the following box:
You can also configure the instruction to either copy or ignore hidden rows in the source range: