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
Want To Learn Excel Formulas Fast?