Automatically fills cells with content.
The LibreOffice Calc context menus have additional options for filling the cells.
Filling cells using context menus:
Call the context menu when positioned in a cell and choose Selection List.
A list box containing all text found in the current column is displayed. The text is sorted alphabetically and multiple entries are listed only once.
Click one of the listed entries to copy it to the cell.