When I select specific cells within a column, Excel ends up copying the entire range of cells instead of just the ones I selected. I am using CTRL + LEFT MOUSE ClICK to select the cells. How do I copy the data just from the selected cells.

  • I don't experience this at all. I ctrl clicked on cellA1, cellA5 and cellA22 and the 3 cells were copied. Are you missing information in your post. Are these cells random? Are they part of a data table? Do you have any functions. How are you copying? – Dave May 8 '14 at 13:58
  • 2
    Doesn't happen with me. I select A1 then A10 (using CTRL + Click) and all cells in between are copied. – webworm May 8 '14 at 14:21
  • This indicates I must have a setting checked... – Dave May 8 '14 at 14:24
  • Indeed, because it seem foolish not to be able to copy only those cells selected. – webworm May 8 '14 at 14:27
  • 1
    This should work no problem assuming your noncontiguous selections are either in the same row or the same column. What it won't do is place the noncontiguous cells into noncontiguous cells. Or, if you're using formula or table references. – Raystafarian May 8 '14 at 14:33

It is not possible the way you try it. You can use the Clipboard, copy several fields/ranges one after the other and then paste them all in at once.

There are Addins that provide that feature though. In the source below Kutools is mentioned.

source: http://www.extendoffice.com/documents/excel/799-excel-copy-multiple-selections.html


Your cells are locked - thats what happened to me. Under format cells, go under the protection tab and make sure the 'Locked' box is NOT ticked. That should solve it.

  • Nope, doesn't work. Still getting the extra rows added in – Evil Washing Machine Dec 20 '16 at 11:43

I have a possible answer for you, but this solution only works if you are pasting directly into another (or the same) excel sheet. When pasting the selected values, right click where you wish to paste the values and select "Paste Special > Values".

Not only does this only paste the selected cells without the "in-betweens", it also removes blanks and compressses the selection without spaces.

I would suggest doing this and then moving it to whatever other document you might be using.


Try making sure the workbook is in Editable mode. If you loaded it directly from an email attachment or it's not "Trusted" and it opens in read only mode, then it will behave like this. When you multi-select cells/rows/columns it will include the unselected columns in between those selected when you cut or copy. If the workbook is editable (not in read only mode) then it will behave as you intend and only cut/copy the selected cells.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.