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).
While this is a fairly simple example, the example below show where this feature comes in handy.
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.