Copying Large columns and rows not working

[Rick187]

Hi,

I have 90,000 rows in a spreadsheet, some are blank and some contain text.

I want to copy all 90,000 rows for the column to another spreadsheet, but when I paste it in the other spreadsheet, only about 1200 rows get pasted, and the rest do not. Does anyone know why this is happening and how to fix this?

Any help would be appreciated.

Thanks.

 

[gaz_chops]

How are you copying & pasting?

 

[Rick187]

I've tried highlighting the whole column and copying

I've tried using CTRL + Shift + down but that only highlights the first 600 rows, then I have to keep pressing it for about 10 mins for it to get to the bottom of the spreadsheet, even when I do it this way and press CTRL + C, when I paste it in the other spreadsheet, only the first 1200 rows or so get pasted.