AutoFill a Series This little web site sells about 100 egg baskets a day. Suppose we sold another 5 baskets every day. What would the sales revenue be?   8. Try This: Enter the Data In Cell D2 type 100. In Cell D3 type 105. And Do This: AutoFill a Series Select Cell D2 AND D3: both the 100 and the 105. Now you have selected enough of a Range for Excel to recognize that this is a Series, incrementing by 5s.   Double click the AutoFill handle and the Series will fill down to match Column C on the left.   What Do You See? When you AutoFill this Series, Microsoft Excel adds 5 more to the quantity in each Row.

AutoFill Options