Forum Discussion
Peterbrookway
Feb 12, 2020Copper Contributor
copying multiple separated cells in one column and pasting into a new column
How can I copy multiple separated cells in one column (eg a1, a3, a11) and paste into a new column keeping the same distance apart (eg to c1, c3, c11).
The basically pasted cells go to c1, c2, c3) ie. no vertical separation.
1 Reply
- SergeiBaklanDiamond Contributor
Afraid no changes from the time of this discussion https://techcommunity.microsoft.com/t5/excel/in-excel-how-do-you-copy-non-adjacent-cells-and-paste-them-the/m-p/167526