Example: Autofill example How to Autofill formulas like the following example. Looking at the following example. For the example, you want to know the sum of each area So select the full area like on the following picture. and pull it down or double click on the bottom right corner. It will autofill. et VOILA. You can download this example here.