2/4
Select the cell "A 1" and press "Ctrl+shift+ keyboard key" to select the whole column of data in the cell "A 1".
3/4
Select the "A 1" cell, press "Ctrl+shift+ keyboard right key", then press and hold "Ctrl+shift" and press the keys of the keyboard to select all data.
4/4
If there are blank cells in the selection process, automatic selection will stop, and you can continue to select blank cells in the corresponding direction.