Fill a Column with Values

[#1]

There are two ways to repeat a set of values down a data table column.

Using a Fill Command

1. Highlight the values that you want to repeat and right-click.
2. Select Fill > Repeat sequence to end of table.

Fill Menu

Using Copy and Paste

1. Highlight the values and select Edit > Copy.
2. Highlight the destination cells and select Edit > Paste.

The paste operation cycles through the cells in your selection repeatedly until your destination cells are filled.