Fill Awardee Cc Number with airSlate SignNow

Fill number release

Hi this is Gary with MacMost Now. On today's episode I want to show you how to fill cells in Numbers. So I'm often asked how do you fill cells in Numbers. For instance you may want to copy and then paste a number into multiple cells, you may want to have them automatically fill as you expand a spreadsheet. There is all sorts of different ways to fill cells in Numbers. So let's look at them all. Here is a standard blank spreadsheet. The most common thing you may want to do is to simply fill a series of cells with the same number. So here I have put a number into a cell, I'm going to select it, and then select Edit and then Copy or Command C. Then I'm going to select a series of cells. I can do that by selecting one and then shift selecting another. You can also drag the little dot here at the bottom right hand corner and select your area. Then I'm going to Edit and Paste, or Command V. You can see it simply fills all those cells with that same number. I can select an area, paste it and it will do it like that. Now this also works if you have a series of cells and even if there is formulas in them. So for instance this first cell here is just a number and then there is another number and this third cell here is actually a formula adding these two together. Now if I select all of them, Command Shift and select all three there, and I Command C (copy), then I select say the cell below that and Shift Select there to select that whole area, and I Paste, you can see that it pasted it all in. It is not pasting the number there in the last cell, it is actually pasting the formula, shifting it down as you would expect. So I can Undo that there and select say only that cell, copy, select a bunch of cells here, paste and you can see it is a bunch of zeros because this on here is trying to add these two together. I can put values in them and you can see it will adjust according to those values. Now let's do this taking the entire table into consideration. I've got a large table here. I'm going to shrink it down to just the size I need. I'm going to insert an extra Footer Row here. It is very common to want to have totals. So for instance, let's shrink this all the way so that I just have one sample row here and put this as the -sum of everything in B, and then I'm actually going to copy that and paste that here, and sum of B and sum of C, and sum of D. Then I'm going to make this a formula where it takes this number and adds this number...