I used to be able to copy and paste multi-line content in Excel into a single cell, all I need to do is double click the new cell or use Alt + Enter, and paste using Ctrl + V.

However this is no longer working for me. Every time I copy multi-line data and double click the new cell or use Alt + Enter the paste option is no longer available to paste and the selected cell loose the dotted flashing border around my selected copy data.

This has just started happening. Can anyone please help.

Thanks in advance

  • Is this happening in all workbooks or one specifically? What version of Excel? Has there been a recent update? – CharlieRB Oct 17 '16 at 13:15
  • Do you have a wireless keyboard? I have seen this behavior when the battery needs to be replaced. – bvaughn Oct 18 '16 at 13:53

Test Alt + Enter in another program, in Word it should repeat something you just typed. Just to ensure your keyboard is ok.

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.