Fill

Automatically fills cells with content.

Toiminnon aloitustavat:

Choose Sheet - Fill Cells.


Huomautus-kuvake

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.

Right

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

Up

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

Left

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

Sheet

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

Series

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

Filling cells using context menus: