![]() Likewise if I were to scroll up you can see the first row stays there. If I were to scroll over here you could see the first column stays there so I can see what's in it. So just by typing it right the first time you can avoid having to set the data format.Ī handy feature in Numbers is Freezing Header columns and Header Rows. But I could also type this and you can see the formatting here is set to what I typed there. Since I can type a date like this and you can see the formatting here is set to what I typed. But I could actually switch it in this case to currency and it still keeps my options. The only difference is it's still set to Automatic Data Format. Now when I look here at the format you can see it actually guesses the formatting from what I typed. So I can do dollar sign and then include the comma and include the number of decimal places. Instead I can simply type it right the first time. I also want to add a thousand separator to it. Now it sets it to Currency with two decimal places. For instance I can type a value like this and then I can select it. Now when you want to format a cell you can do so in the right sidebar. So if I go over to the next one and I type p you can see it doesn't come up with those suggestions. When there are multiple ones like with pear and peach here I can do p and I can select the right one with the down arrow and hit Return to enter it. All you need to do is use the down arrow to select it and Return to accept it. So you start typing something, like letter A, and you can see suggestions from previous items in this column. Now even if you don't use pop-ups you still have an Auto-Complete function in Numbers. Even the old ones will have the new items in the pop-up. So I can click here and choose the right one. But now all of the items are included there in future pop-ups. Now this won't appear here as something new there but all you need to do is select all of these cells and reapply the data format to pop-up menu. So for instance if I want to add something else here I could just hit Delete and then type in a new name there. So when I go to this cell here to fill it in I have the right choices. When I then change them all to be a pop-up menu it automatically fills in the values it finds for that pop-up menu. ![]() So I select all of these cells here in this column including the ones that's already filled in. But instead of that what you can do is first select these cells. Then I can define in this list here exactly which values should appear in that pop-up menu. So, for instance, if I have these four items here that I want to be able to enter in any of these cells I can go to Cell and then change the data format to Pop-up Menu. Now if you have some repetitive data entry you can use a pop-up cell to make it a little bit easier. So instead of clicking once to select Column B, I double click and now you can see it selects everything but the Header or Footer cells of that column. If I want to select just the value cells, not the Header cells, all I need to do is double click here. So if I were to change something, like for instance change the text to be a different color, you can see it effects the Header row as well as the values. Or you could simply click on the Header here, where the letter is for the column, and then you could make a change. ![]() Now if you want to change the style or in some other way use all of the values in a column you could select the first item there, scroll all the way down to the bottom and select the last one. You can do this extending to the right as well as down. But if you've got a series that just doesn't work with addition like this one then it if you extend you'll see it just repeats that series. Now Numbers is smart about this series so if you, for instance, have 5 and 10 here and you drag down you see it completes the series in steps of five. ![]() Click and drag that dot and you can extend that series as much as you want. Now if I move my cursor near the bottom center you'll see a yellow dot appear. Start off by defining the series by having two numbers, like 1 and 2 here. Say you want to fill a column with sequential numbers. Let's start off by talking about filling cells. MacMost is brought to you thanks to a great group of 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 |