Copy contents of XL spreadsheet to another

  johnincrete 09:19 10 Jun 2009

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 2009

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 2009

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

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

Halloween Photoshop & Illustrator tutorials: 20 step-by-step guides to creating spook-tacular…

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?