Excel: Legs, Eggs, Pigs Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

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.
 

 

  Microsoft Excel 2007 Exam 77-602 Topic: 1. Creating and Manipulating Data

  1.1.1.  Fill a series  1.1.2.  Copy a series