Repeating Input Data using Picklist

To make it easier to enter the same data over and over again you can use the facilities Pick List. When compared to the guessing AutoComplete completion of data that you type, Pick List displays a list of all kinds of data that you have entered into a "drop-down list". From the list you can click on the data to be repeated typing in the active cell.

Steps:

1. Type the data first.
2. To repeat the data that has been typed, place the active cell in an empty cell in the column that contains the data to be repeated, then click with the right mouse a floating menu that is displayed, select Pick From List to perform drop-down list that contains the data that has been ever typed.
3. Click the data to be repeated in the cell so that the data is entered into the cell and vanished drop-down list.