Contents
Index 🔎︎

# 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.

## 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:

- 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.