It is going to move this from sum of B2 to D2 to B3 to D3. If I want to post a bunch of numbers in here and then do a formula that adds these together, do the sum of these three here, of course when I copy and paste it below, copy paste right there, and if I do some numbers here it is going to figure it out and it is going to do it for each row. Now when it comes to formulas Numbers is pretty smart too. If I do like the first of the year and I select this or I just drag it down it is going to be smart enough to realize that in terms of dates I probably don't want to repeat that same date over and over again but that I want to increment it for each one. Numbers is smart enough to realize I am doing a sequence here and it is going to complete that sequence. What is really cool is say if I were to enter 1, 2, 3 and then I would select all three of these cells and drag. The same thing happens to the right, drag it out to repeat the value there. You can drag that and you can see that it will repeat the value there. Notice that a yellow dot appears at the center bottom. Now another thing you can do is you can put a value into a cell and then you can simply select the cell. Likewise if I had two cells and I selected both of them and then I selected a range of cells that made sense and I did a paste you can see it copies them and it knows it is supposed to copy the two of these over and over again. Then I can select any range of cells I want and paste and it will paste that same value in there. For instance, I can type a number in here and then I can simply select it and copy. Well, there are several different ways to do it. So say you need to fill a lot of cells with a value. I'm going to show you how to autofill cells. Let me show you how you can fill cells in Numbers. Check out Using Autofill In Numbers at YouTube for closed captioning and more options.

Numbers for mac turn off autofill