Using Excel’s Autofill

So what happens if you need to fill out a bunch of cells in a row or column?  Do you need to fill out each and every cell?  No of course not!  Just use Excel’s auto fill feature.  This is a faster and more intuitive way of copy and pasting.  Imagine having to do up a proforma invoice for the next 5 years.  Instead of typing in all 5 years fill in the first 2 years and drag to autofill the rest of the cells.

1.Type your labels (Years).

2. Start entering in the actual years (2013, 2014).

Screen Shot 2013-04-06 at 9.29.54 PM

3. Select your data and drag the fill handle (little box on the bottom right side of your selection) to the right (or up or down) and Excel automatically fill in the cells for you.

Screen Shot 2013-04-06 at 9.30.14 PM

While this is a fairly simple example, the example below show where this feature comes in handy.

Screen Shot 2013-04-06 at 10.00.28 PM

Here I filled in a calculation for the class average  for math and dragged the fill handle over to calculate the class average for the other subjects.

This is a very handy feature that anyone who uses Excel should know.

Advertisements