Everyone knows that if you select two cells with numbers and drag them to other cells, a series of numbers will line up in an arithmetic progression. But it turns out, opportunities Excel are not limited to arithmetic progression alone.
It is quite easy to set up the desired progression. Moreover, it will be enough to enter only the first value, then bring the mouse cursor to the lower right corner until a black cross is formed. (in general, everything is the same as with normal filling). But you need to drag the cells down not with the left, but with the right mouse button!
After that, a context menu will appear, where you need to select the last item "progression" :
And choose the type of progression (arithmetic, geometric), step, limit value, etc.
We will get:
