How To Access Icloud Numbers On Iphone

hi this is gary with macmost.com. let me showyou how you can fill cells in numbers. we're looking at numbers version 3.0. i'mgoing to show you how to autofill cells. so say you need to fill a lot of cells witha value. well, there are several different ways to do it. for instance, i can type anumber in here and then i can simply select it and copy. then i can select any range ofcells i want and paste and it will paste that

How To Access Icloud Numbers On Iphone, same value in there. likewise if i had two cells and i selectedboth of them and then i selected a range of cells that made sense and i did a paste youcan see it copies them and it knows it is supposed to copy the two of these over andover again.

now another thing you can do is you can puta value into a cell and then you can simply select the cell. notice that a yellow dotappears at the center bottom. you can drag that and you can see that it will repeat thevalue there. the same thing happens to the right, drag it out to repeat the value there. what is really cool is say if i were to enter1, 2, 3 and then i would select all three of these cells and drag. numbers is smartenough to realize i am doing a sequence here and it is going to complete that sequence.so it will even do this for date values. if i do like the first of the year and i selectthis or i just drag it down it is going to be smart enough to realize that in terms ofdates i probably don't want to repeat that

same date over and over again but that i wantto increment it for each one. now when it comes to formulas numbers is prettysmart too. if i want to post a bunch of numbers in here and then do a formula that adds thesetogether, 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 isgoing to do it for each row. it is going to move this from sum of b2 to d2 to b3 to d3. what is really cool is that if i were to shrinkthis down here so this is the entire table and say i want to add another row it is goingto figure out that while i need to enter unique values for these, this is a formula that iprobably want to repeat. there you go. it

put the formula in there and now it will work.and as many as i add it is always going to add this formula into the row. of course ican always delete it but chances are if you are doing something like this you want thisto autofill and repeat for as many as you are going to add in. so autofill is even smart enough to realizethat you are doing things like, for instance, do january here and i'm going to drag thisout. look at that. it even recognizes that i am doing the months of the year and it isalso smart enough to realize if i am doing a sequence. so if i do say 5, 10, 15 and iselect these and i drag down you can see it is going to increase by fives.