0

If you select a cell in Excel containing text or a numeric value and copy to clipboard, then paste into an application like Notepad or Word, it always pastes a line-break.

enter image description here enter image description here enter image description here

If you double-click the cell and select-all the contents in edit mode, you can copy-paste this but thats quite cumbersome as you now can't use only the keyboard, and it adds extra clicks.

I wondered if there might be a special keyboard shortcut to copy as if I was editing the cell contents?

Mr. Boy
  • 5,554

2 Answers2

0

Double click on the desired cell (rather than just single clicking/selecting it), hit ctrl + a to copy the contents, and paste it

0

select cell press F2 then Shift + Home and then Ctrl + c and paste to the destination

farooq
  • 159