Then, select those cells, and drag the fill handle to repeat the pattern.

Let’s take a look.

The fill handle works in both directions.

When we drag up, it repeats the pattern backwards.

you’re free to also create a repeatable pattern by combining text and numbers.

Custom patterns work with dates as well.