Select certain cells in a column

  • Thread starter Thread starter egildone
  • Start date Start date
E

egildone

I need to copy certain cells in a column and past them into a word
document, but when I select them by using Ctrl+C I can select the
individual cells but when I try to paste them into word I get all the
cells between the first and last. I have tried using both paste and
paste special. What I mean is I select cell 3,6,9,12 using Ctrl+C it
selects the individual cells OK, but when I try to paste them into word
I get all the cells between 3 and 12. Is there a way to copy and paste
cells that are not contiguous and past them into a word document other
than one at a time?

Ed
 
egildone said:
I need to copy certain cells in a column and past them into a word
document, but when I select them by using Ctrl+C I can select the
individual cells but when I try to paste them into word I get all the
cells between the first and last. I have tried using both paste and
paste special. What I mean is I select cell 3,6,9,12 using Ctrl+C it
selects the individual cells OK, but when I try to paste them into word
I get all the cells between 3 and 12. Is there a way to copy and paste
cells that are not contiguous and past them into a word document other
than one at a time?

Ed
Click to expand...
OK, I read the documentation and discovered I can select non contigous
cells and copy them but you are limited to 24 cells in one operation.

I answered my own question! It always help to read the documentation.

Ed
 
Hi, I've waited a while to see whther there were better solutions.
One way would be to insert a help column do a series of 123 123 123 down the
column and then sort to show every third row.
You can then copy paste as per usual.
You could put some of this into a macro.
 
Back
Top