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?   9. 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. Exam 77-420 Microsoft Excel 2013 2. Create Cells and Ranges 2.1 Insert Data In Cells and Ranges: Autofill

AutoFill Options