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.


Want a licensed version of Microsoft Office for next to nothing?

Microsoft Office is without a doubt the most popular office productivity suite out there. We use it in our schools, workplaces, and homes.  But with the full version of Office 2013 Plus being more than most people can afford, I’m sure there are a few unlicensed copies out there.  How does a legitimate version of Microsoft Office sound?  If your company is participating in the Home Use Program with Microsoft you may be eligible to get your copy for next to nothing.  More details of the program can be found here.

Screen Shot 2013-04-04 at 7.56.12 PM Screen Shot 2013-04-04 at 8.06.19 PM

There are currently two version currently being offered.

The version for Windows includes Word, Excel, PowerPoint, Outlook, OneNote, Access, Publisher, InfoPath and Lync.

Also offered is Office:mac. This version includes Word, Powerpoint, Excel and Outlook.

Click Here to see if you are eligible.