Hi there When I want to paste a whole bunch of things in, it's pretty easy. I go up to the text I want to copy and press command see.then I go down to the empty sale and press the shift key and start going down arrow until I have selected all the ones I want. The other thing I have done is to press shift command down arrow to select I'll cThe whole column. Then I just press command V. There may be other ways to do it, but that's the way I have been doing it. You can also press command shift right arrow to select all the way to the end of the rope. Gigi
Sent from my iPhone > On Feb 21, 2015, at 7:18 AM, Phil Halton <philh...@gmail.com> wrote: > > >> On Feb 21, 2015, at 1:58 AM, Garth Humphreys <ghu...@gmail.com> wrote: >> >> Hi Phil, thanks for your help. Okay, starting to get somewhere. Never been a >> fan of formula editors, usually just prefer to type it straight in., but >> getting the hang of this one. The place holders keep getting in the way more >> than being helpful sometimes though. > *** you can select and delete these placeholders, and then type in your own > data. > >> I’d really like to be able to just arrow through the text like it was a >> normal text field but I guess it will come with use. The auto complete stuff >> seems pretty similar to excel in the most part, obviously you just hit tab >> rather than enter though. Excel will do the auto complete for a defined >> range,which I really like. Okay some more questions, >> Still don’t get how the name for a range works, so I have some data in 3 >> columns, let’s say Names, Age, and Sex. of 20 people. This data exists from >> A2:C21 and I have the Headings Name, Age, Sex in A1, B1 & C1. The formula >> editor offers me the first persons name as a range or Name as a range >> however selecting either of these did not work. Lets say I want to call this >> data set “Staff” and refer to it in formulas by that name, should I add a >> row above or a column before the data? Neither of these seemed to work.I >> could make the formula work by using absolute cell range but I’d like to get >> the defined name way of doing it to work. > *** Check the number of header rows/columns for the table. It sounds like you > have two header rows and the first persons name is in row two which is the > header row closest to the data rows. Remember, numbers will use the header > row closest to the data rows for a column title/range name. Look in the table > menu header rows submenu and check 1 for the number of header rows. Numbers > treats header/data/footer rows like different animals altogether.. > To refer to this data, you refer to the sheet name, then the table name, > then the actual data either by absolute cell references or by range names. I > really suggest reading the section on addressing in the help system for > better understanding of all this. It’s worth the read. > >> Also, in excel, if I want to make a cell reference absolute, I just type it >> in say D22 then hit F4 and it’ll expand to $D$22, is there some quick way to >> do this in Numbers. >> How about dragging down a formula over a lot of rows, like Control+D in >> excel to copy the first cell in a selection down the entire selection? >> *** I always just add the dollar sign manually, because I want control over >> which of the coordinates I make absolute and which I make relative. There’s >> no way I am aware of to do it automatically as you mentioned. >> Again, you’ll just have to slog through the help system to answer most of >> your questions. I do suggest that you get out of the habit of thinking in >> terms of excel and learn numbers for its own ways. > > good luck > >> Thanks again, >> Garth >>>> On 21 Feb 2015, at 11:55 am, Phil Halton <philh...@gmail.com> wrote: >>>> >>>> >>>> On Feb 19, 2015, at 11:21 PM, Garth Humphreys <ghu...@gmail.com> wrote: >>>> >>>> Just started playing with numbers on the mac for the first time, I’m an >>>> excel user at work. >>>> 1. Can you define a range with a name so you can just reference the range >>>> with that name? >>> Yes, place your range name in a header row, (it must be the header row >>> closest to the data rows), and the formula editor will make that range name >>> available when selecting ranges/cells. >>> >>>> 2 What’s the syntax for referencing a table or range on a different sheet >>>> and or file? e.g., I’m trying to do a Vlookup where the table is on a >>>> different sheet, what’s the best way? >>>> The formula editor is great for this. simply start typing the name of the >>>> sheet and the editor will attempt to auto complete the sheet name. when >>>> you hear the completed sheet name, press enter and the editor will start >>>> providing table names. use the right arrow to move through the available >>>> tables, or just start typing the name of the table and again, the formula >>>> editor will attempt to auto complete. press enter when you hear the table >>>> name you want. next, the editor will start providing range names. follow >>>> the same steps as you do with sheet and table names. Again, whenever a >>>> name is called for in the formula, just start typing the name of the >>>> desired sheet, table, or range and numbers will do its best to auto >>>> complete. >>> >>> Spend some time working in the formula editor to get familiar with its >>> operation and you’ll love it, its miles ahead of excel in this regard IMO. >>> >>> for absolute ranges, use the (dollar sign in front of the cell/range, just >>> like in excel. >>> >>> if you don’t want to use the auto complete, , I think the exact syntax is >>> to type the sheet name, followed by two colons, then the table name, >>> followed by the range/cell name. I can’t remember right now what the >>> separator is between table and cell/range, but a good read of the numbers >>> help system will answer all the specifics, its a really thorough help >>> system. >>> >>>> That’ll do for a start, thanks for any assistance. >>>> >>>> Garth >>>>> On 19 Feb 2015, at 8:04 am, waterwogs...@gmail.com wrote: >>>>> >>>>> Thanks so much! >>>>>> On Wednesday, February 18, 2015 at 8:11:51 AM UTC-8, waterw...@gmail.com >>>>>> wrote: >>>>>> Wondering if anyone knows how to do in-cell editing in Numbers? >>>>> >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google Groups >>>>> "MacVisionaries" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send an >>>>> email to macvisionaries+unsubscr...@googlegroups.com. >>>>> To post to this group, send email to macvisionaries@googlegroups.com. >>>>> Visit this group at http://groups.google.com/group/macvisionaries. >>>>> For more options, visit https://groups.google.com/d/optout. >>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google Groups >>>> "MacVisionaries" group. >>>> To unsubscribe from this group and stop receiving emails from it, send an >>>> email to macvisionaries+unsubscr...@googlegroups.com. >>>> To post to this group, send email to macvisionaries@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/macvisionaries. >>>> For more options, visit https://groups.google.com/d/optout. >>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "MacVisionaries" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to macvisionaries+unsubscr...@googlegroups.com. >>> To post to this group, send email to macvisionaries@googlegroups.com. >>> Visit this group at http://groups.google.com/group/macvisionaries. >>> For more options, visit https://groups.google.com/d/optout. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to macvisionaries+unsubscr...@googlegroups.com. >> To post to this group, send email to macvisionaries@googlegroups.com. >> Visit this group at http://groups.google.com/group/macvisionaries. >> For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to macvisionaries+unsubscr...@googlegroups.com. > To post to this group, send email to macvisionaries@googlegroups.com. > Visit this group at http://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
