Put the series in a Custom List (Tools/Options/Custom List). Enter D in
a cell. Drag across or down.



In article ,
"Mohd Rosdi" wrote:

Dear Expert,

My data patern D, D, N, N, O, O, O, R . If I type D in a1 I want next to
follow with the rest of the pattern and repeat the same patern to as many
cell I want.

tq.