pasting content copied from nonadajacent cells

D

d.adams

I am trying to copy text from nonadjacent cells in a row in one spreadsheet
using Control/Select/Copy, and paste the text into adjacent cells in a row in
another spreadsheet. When I paste the content in, all the content from cells
between those I copied will paste in also. For instance if I copy C5, F5 and
H5, then paste into new spreadsheet, I'll get C5, D5, E5, F5, G5 and H5.
Excel help does not say anything about pasting content, only how to copy it.
 
G

Gord Dibben

This can only be done when copied cells are in same column or row.

Hold CTRL key and click on each of the non-contiguous cells C5, F5 and H5

Copy then paste.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Columns appearing from nowhere, formatting going weird 0
Need Help with a VBA subroutine 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
How to paste this down? 3
Average cells based on column header 6
formula help 3
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Adding cells but leaving blank if not populated 2

Top