Excel: Legs, Eggs and Pigs Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

AutoFill A Series Our little web site sells about 100 egg baskets a day. Suppose we sold another 5 baskets every day. What would our revenue be?   Try it: In cell D2 type 100. In cell D3 type 105. AutoFill. Select 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 the C column on the left.