Fill

Automatically fills cells with content.

To access this command...

Choose Sheet - Fill Cells.

The Office 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 leftmost cell.

Up

Fills a selected range of at least two rows with the contents of the bottommost 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.