Let say I have an excel sheet with structure like

enter image description here

I select a few cells (at one column) and click Ctrl+C. After that I want to paste it. I select one cell(B116):

enter image description here

And click Ctrl+V. It gives me an error:

enter image description here

Excel think that I need to copy just one column or merge it. But I want excel just to create a few rows and moving all content down. How can I do it?

  • Dave, thanks for editing. I haven't enough reputation... – asiniy May 27 '14 at 10:27

What you are trying to do, confuses Excel. When you paste an array by selecting one cell (and the pasted area goes into a merged cell), Excel does not know how you want the information pasted into the cells. If you highlight the same number of cells as the copied array, Excel will not have a problem and will paste the information.

|improve this answer|||||
  • I know it. How can I avoid confuse of excel? – asiniy May 27 '14 at 5:13
  • You didn't read my answer: select the same size of array that you copied. – LDC3 May 27 '14 at 5:21
  • Do you mean I need to insert much rows before paste? This is my trouble! I have many copy-paste operations and don't wont to insert rows before each paste – asiniy May 27 '14 at 5:39
  • I believe that Excel looks to see if there is anything in the cells, if so, it will ask if you want to shift down, up right or left before pasting. – LDC3 May 27 '14 at 13:23
  • It didn't ask me to shift down – asiniy May 27 '14 at 14:50

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.