Forum Discussion
Autofill
Hi
I'm trying to create an excel document but when I want a sequence of a day of a week it doesn't work. Ex: If I write the word Monday if I drag the cursor it should follow with Tuesday, Wedn...
In addition - if you try to autofill from one cell with number 1, Excel has not enough information how to autofill and just copy the cell. Try to add 2 into next cell, select both and fill handle - it shall be autofilled by series now.
- Alternatively, enter 1 in A1 and use the *right* mouse button to drag the fill handle. Select "Fill Series" from the context menu that pops up when you release the mouse button after the drag.
Try dragging with the right mouse button when a cell contains a date for some useful options as well.
