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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s