Hi,

How do you auto fill the cells in a column

Eg:

1 text1
2
3
4 text2
5
6
row 2 and 3 should be filled with text1 and 5, 6 should be filled with text2. Double clicking the corner of text1 cell is not what I am looking for. Please help