Issue with an excel

[GeoTurbo53]

Hello guys. I have a question. I have an excel sheet where are arround ~200'000 lines. And i want to copy the first 30'000 lines. Is it possible to do it with one click without scrolling down and waiting until all 30'000 lines will be selected?

Another question. In the past i was scrolling down until 30'000 lines are selected and it was quite fast. But today when i tried - it was really slow, i needed to wait like 10 minutes until all 30'000 were selected.. Any idea why it changed?

Let me know, thanks!

 

[sci0n]

 

[Augusto Cury]

Hello guys. I have a question. I have an excel sheet where are arround ~200'000 lines. And i want to copy the first 30'000 lines. Is it possible to do it with one click without scrolling down and waiting until all 30'000 lines will be selected?

Another question. In the past i was scrolling down until 30'000 lines are selected and it was quite fast. But today when i tried - it was really slow, i needed to wait like 10 minutes until all 30'000 were selected.. Any idea why it changed?

Let me know, thanks!

Excel is not able to hand so many lines, you can divide it on your terminal
little tutorial to split in 1000 lines: https://betterprogramming.pub/how-to-split-a-large-excel-file-into-multiple-smaller-files-664f18f97900

if you want to split in 30k just write on the forth line, I hope that this will help ya

 

[GeoTurbo53]

View attachment 194656

Thanks a lot, it worked!