I tried to duplicate my name using fill handle, But Excel giving July, August, september.....instead of July, July, July......




Please help me.

It works in a logical order. Most times you will want the next month in a list, so August.

However if you want it repeated just give it a different patten like July and July - highlight both and drag down with the fill handle

Numbers work the opposite way (i.e will repeat unless you give it 1 & 2 then they will run in order

Or drag down holding the shift key?