LibreOffice Calc how to fill blank cells with value of last known cell that is not empty

[dadao]

I have a CSV file opened in Calc, in Column1, the last cell with value is on row 8333, starting from 8334 onwards to the bottom of the file, the cells are all empty; I am wondering how to fill these empty cells with the value of Column1 on row 8333; even better is it possible that I can fill these blank cells with randomly selected values from rows (2 - 8333) for Column1. All the headers are on row 1.

Since the file has about 74k rows, so mouse clicking is tedious, is it possible to automatically select blank cells starting from 8334 to 74503?

[anon73440385]

Just put the range A8334:A74503 to the Name Box

If you want to change values in the range selected use Edit -> Find & Replace and assure Current selection only is checked.

[dadao]

I am using LibreOffice Version: 6.0.7.3, current selection only is grey out, how does find and replace work here?

[anon73440385]

From my pov it’s strange but the range selected must have at least one value to have the option available.

[mariosv]

Selecting a range or a cell [Ctrl+D] duplicates the cells above.