Example: Autofill example

How to Autofill formulas like the following example.

Looking at the following example.

autofill excel

For the example, you want to know the sum of each area

sum area excel

So select the full area like on the following picture.

select area cell

and pull it down or double click on the bottom right corner. It will autofill.

autofill excel


You can download this example here.