/text/scalc/01/02140000.xhp

filling;selection lists selection lists;filling cells MW inserted 2 index entries Fill Automatically fills cells with content.

The $[officename] Calc context menus have additional options for filling the cells. Sheet Series 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.