ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pasting to Multiple Selections. (https://www.excelbanter.com/excel-discussion-misc-queries/63705-pasting-multiple-selections.html)

JayQue

Pasting to Multiple Selections.
 
Is there any way you can copy from a contiguous range and paste it to
multiple cells or range that are non contiguous i.e. multiple columns of a
different worksheet? Further can you tell excel not to copy data to hidden
columns?

raf

Pasting to Multiple Selections.
 
On Sat 01/07/06 10:11:01, JayQue wrote:
Is there any way you can copy from a contiguous range and paste it to
multiple cells or range that are non contiguous i.e. multiple columns of a
different worksheet? Further can you tell excel not to copy data to hidden
columns?


I do not think you can copy to non continuous cells or columns. Excel
copies the sections and paste the same sequence of cells or columns. The
hidden columns are still part of the sequence therefore it will paste to
those hidden columns.


All times are GMT +1. The time now is 05:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com