1

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?

Improve this question
1
  • Dave, thanks for editing. I haven't enough reputation...
    – asiniy
    May 27, 2014 at 10:27

1 Answer 1

Reset to default
0

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
9
  • I know it. How can I avoid confuse of excel?
    – asiniy
    May 27, 2014 at 5:13
  • You didn't read my answer: select the same size of array that you copied.
    – LDC3
    May 27, 2014 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, 2014 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, 2014 at 13:23
  • It didn't ask me to shift down
    – asiniy
    May 27, 2014 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.