Fill

Automatically fills cells with content.

To access this command...

Choose Sheet - Fill Cells.

The LibreOffice Calc context menus have additional options for filling the cells.

Down

Fills a selected range of at least two rows with the contents of the top cell of the range.

Fills a selected range of at least two columns with the contents of the left most cell.

Fills a selected range of at least two rows with the contents of the bottom most cell.

Fills a selected range of at least two columns with the contents of the far right cell.

Specifies the options for transferring sheets or ranges of a certain sheet to the same cells on other selected sheets.

Automatically generate series with the options in this dialog. Determine direction, increment, time unit and series type.

\<emph\>Filling cells using context menus:\</emph\>

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.