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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…