Calc. how to mark (select) a comprehensive table (6700x9800)?

Hello!
Please, I have the table , from a1 to god know where (6700 x 9800).
I have to mark (select) the whole area.

I tried like this:

shitf+end+arrov right+end + arrow down

What happened?
When I clicked end, the whole row got marked (even without right arrow, as it was in tutorial).
BUT, when I tried to mark those 9800 rows down, I also clicked END ,then downwards arrow, but each click marked just one single row.

It means, I shoudl d o it 9800 times to get to the end of the table???
ANy help, please?
many thanks!

p.s It is CALC, not WRITER

How did you create an array “6700 x 9800” in size? The maximum number of columns in Calc is presently 1024. Bug fdo#50916 is the related enhancement request to get this increased.

It were both big numbers for columns and rows, I did not rememeber both properly. But both were hudge, and it ws not to selct both by mouse.

Ctrl+Shift+End