Most users in Excel would be used to creating a fill series or auto fill by dragging the auto fill handle to the right or downwards. This would give you an increasing fill series.

You can also easily create a decreasing fill series using the same principle. Firstly fill in the first two of your series. In my example below I have filled in Sunday in G2 and Saturday in F2.

The just highlight both cells.

Drag the fill series to the left.

It’s as easy as that. Give it a go.

Other Excel Tips For You

1. Shrink Your Cell Data In Excel

2.Count How Many Numbers In An Excel List Are Greater Than The Average

3. Highlight All Cells That Contain A Formula In Excel

Want To Learn Excel Formulas Fast?