Unable to copy from a worksheet to paste NOT into A1 on another worksheet

[Jennifre]

I've divvied up data sorted by a column, so it could be divided by rows, and assigned to several people to analyze. I put each person's data into their own worksheet. We used a shared Excel doc via Office online, and each worked in our indiv worksheets.

I'd like to rejoin the data now. Yet copying all of one worksheet, hoping to paste all their data into row A.101 instead of A1.

Putting my cursor at A101, typing ctrl+P, I get an error saying I need to paste into A1 or R1C1 (which seems to correspond to nothing in my worksheet.

I also created a test worksheet, copied all of another worksheet and tried to paste into C8, and got the same error.

I ended up doing it via a workaround, but, is there really no easier way to paste an entire worksheet content into another worksheet, wherever I'd like to paste it??

Thanks!

 

[Fluff]

If you select all cells then no.
Select the start cell you want to copy, then Ctrl A to select just the data, then you can paste to whatever row you want.