Because if you just enter one date it gets that you probably don't want to repeat that same date over and over again. But with date values it's actually even easier. You can type a date like this and another date and then you can use the yellow dot to autofill. Or I can do something like this and you can see I get it by tenths. Then select them both and use the yellow dot and drag down and see I get it by fives. So I could put values like this in the first two cells. ![]() You can do the same for columns across like this. I'm going to Shift Click to select both of these cells, grab the yellow dot at the bottom and notice when I drag it gets that this is a pattern where it starts with one and increases by one for every row. All it needs for that is two cells to show what the pattern is. Instead of one I want to increment by one each time. Now what if I want to have a pattern of values. You can get a dot on the right side and autofill like that. If I click and drag that yellow dot down you can see how it autofills everything that I add to the selection. Notice when I do so there's that little yellow dot there. Then move your pointer over it and hover towards the bottom center. Now the second method is to use a special autofill feature in Numbers. So this group that is 2 by 3 here I can Copy and then Paste like this and you can see how it just repeats that pattern. I could also select a range and paste it and you can see how out repeats those values. So, for instance, if I put a 2 here and a 3 here and then I select these three cells I can copy and paste it somewhere else, like that. Now this also works if you have multiple values. So if I wanted to put that value that I copied in column D I could just double-click there and Command V to paste. So if I double-click on B, right there, you can see how it selects all of the cells in that column but not the Header. A quick way to do that for an entire column is to double-click on the Header, here. ![]() Then if I Paste, using Command V, it will paste the same value with all those cells. Or I could click in the first cell and then hold the Shift key down and then click in the last cell. So I select this cell, drag the little dot at the bottom of the right hand corner of the selection to select a range of cells. But I could also paste it in a range of cells. Of course I can Paste it in any other cell. Now if I want to autofill a bunch of cells I can just Copy that one value. So, for instance, I'll put a value here in cell B2. The first is simply to use Copy and Paste. Now if you need to fill a range of cells in Numbers with a single value or a pattern of values you can do so easily using one of three Autofill methods. Join us and get exclusive content and course discounts. There you can read more about the Patreon Campaign. MacMost is brought to you thanks to a great group of more than 1000 supporters. Video Transcript: Hi, this is Gary with.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |