Differences

This shows you the differences between two versions of the page.

--- en:process_steps:range_cell:rangecopymove [2024/02/24 14:41]
tiger
+++ en:process_steps:range_cell:rangecopymove [2024/02/24 14:43] (current)
tiger
@@ Line 15: / Line 15: @@
   * you can choose what you want to copy/move: values, formats, formulas or all of them
-Range copy/move takes into account filters and hidden data - only visible, filtered data will be copied/moved. For example:
+Range copy/move takes into account filters and hidden data  - only visible, filtered data will be copied/moved. For example:
-You filter the worksheet wsExample by a value in Column B. Row 4 and row 7 matches the filter criteria. Column C is hidden on wsExample. Then you copy the range wsExample!A1:D7 to another location. Only the two filtered rows (4 and 7) and the 3 visible columns (A, B, D) will be copied.
+  * You filter the worksheet wsExample by a value in Column B. Rows 4 and row 7 matches the filter criteria.
+  * Column C is hidden on wsExample. Then you copy the range wsExample!A1:D7 to another location. Only the two filtered rows (4 and 7) and the 3 visible columns (A, B, D) will be copied.