Copy contents of XL spreadsheet to another

  johnincrete 09:19 10 Jun 09
Locked

I'm going crazy| It's so simple & I sure I've done it before.
I have two spreadsheets. One has one column headed "Title" and the other has several including one header "Title". I want to copy the single column to the corresponding column in the bigger spreadsheet.
Easy - select single column, copy, go to second spreadsheet & paste but good old Excel says the receiving cells must be the same size as the cells to be pasted - there are over 400 lines. What am I doing wrong?

  VoG II 09:32 10 Jun 09

Copy the cells that you want (not the entire column).

On the second sheet click in a single cell at the top of the range where you want to paste, then paste.

  johnincrete 09:58 10 Jun 09

Thanks - of course my problem was I was selecting the column

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac