Forum Discussion
Copy from multiple cells - paste into one
Hi, Can anyone help? I would like to copy from multiple cells in one spreadsheet but paste into just one cell in another spreadsheet. Is this possible? Thanks E.g. Literal understanding S...
My coworker is using excel on a mac. He's able to select multiple cells, copy using cmd-c, then double click on another cell (so that the cursor is in that cell), then uses cmd-v to paste all the information from those multiple cells into one. He said he was able to do the same on his windows machine when he was using windows.
Is there a way for me to do that in my excel? I'm using Windows 11, Microsoft® Excel® for Microsoft 365 MSO (Version 2211 Build 16.0.15831.20098) 64-bit
TIA
Is there a way for me to do that in my excel? I'm using Windows 11, Microsoft® Excel® for Microsoft 365 MSO (Version 2211 Build 16.0.15831.20098) 64-bit
TIA
This will work when copying multiple lines of text from a text editor, such as Word or Notepad, but will not work when copying multiple cells from Excel because you lose the copied selection (the spark lines or dancing ants) as soon as you open another cell for editing (double click / F2 / formula bar).