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

AutoFill the Data 5. Now, one way to put in the dates for the next month would be to type them all. Do you want to know a faster way?   Click once on cell A2 to select it. Do you see the little AutoFill handle at the bottom of the cell? It’s a little black square. Move the mouse over the handle. When the cursor changes from a fat white plus sign to a thin black cross, hold your left mouse button down. Drag down to cell A20 and release. Charlotte’s Website sells eggs, chicken wings, and little sausages wrapped in pastry. Eggs, Legs, and Pigs in a Basket. Under product type, “eggs.” AutoFill works here, too. Click once on Eggs to select it. Double click the handle and the word Eggs fills all the way down. Look, it goes down as far as the column to the right. So don’t worry, it won’t go on beyond zebra.

AutoFill Handle