Apple Intelligence is now available on iPhone, iPad, and Mac!

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Copying multiple cells results in one cell

I want to combine the data in two separate spreadsheets. I copied the desired cells in Spreadsheet A but when I pasted in Spreadsheet B all the data was in one huge cell. Same thing if I highlight by rows or columns. What's going on?


Current Pro Desktops

Posted on Dec 29, 2021 8:56 PM

Reply
Question marked as Top-ranking reply

Posted on Dec 29, 2021 9:04 PM

I suspect you clicked once too often on the cell expected to receive the first copied value.


Select the desired cells in the source document.

Copy.

Click ONCE on the cell in which the first piece of copied data is to be placed.

Paste.


What went wrong:

The first click on a cell selects that cell.

A second click on the same cell places the insertion point in that cell.


Regards,

Barry

1 reply
Question marked as Top-ranking reply

Dec 29, 2021 9:04 PM in response to Diddie K

I suspect you clicked once too often on the cell expected to receive the first copied value.


Select the desired cells in the source document.

Copy.

Click ONCE on the cell in which the first piece of copied data is to be placed.

Paste.


What went wrong:

The first click on a cell selects that cell.

A second click on the same cell places the insertion point in that cell.


Regards,

Barry

Copying multiple cells results in one cell

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.