Fill Cells

Automatically fills cells with content.

כדי לגשת לפקודה הזאת…

Choose Sheet - Fill Cells.

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

Populate a cell range with automatically generated pseudo random numbers with the selected distribution function and its parameters.

You can reuse the values in the current column to fill the cell.

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.