> 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 >> <mailto:philh...@gmail.com>> wrote: >> >> >>> On Feb 19, 2015, at 11:21 PM, Garth Humphreys <ghu...@gmail.com >>> <mailto: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 >>>> <mailto:waterwogs...@gmail.com> wrote: >>>> >>>> Thanks so much! >>>> On Wednesday, February 18, 2015 at 8:11:51 AM UTC-8, waterw...@gmail.com >>>> <http://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 >>>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>>> To post to this group, send email to macvisionaries@googlegroups.com >>>> <mailto:macvisionaries@googlegroups.com>. >>>> Visit this group at http://groups.google.com/group/macvisionaries >>>> <http://groups.google.com/group/macvisionaries>. >>>> For more options, visit https://groups.google.com/d/optout >>>> <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 >>> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >>> To post to this group, send email to macvisionaries@googlegroups.com >>> <mailto:macvisionaries@googlegroups.com>. >>> Visit this group at http://groups.google.com/group/macvisionaries >>> <http://groups.google.com/group/macvisionaries>. >>> For more options, visit https://groups.google.com/d/optout >>> <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 >> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >> To post to this group, send email to macvisionaries@googlegroups.com >> <mailto:macvisionaries@googlegroups.com>. >> Visit this group at http://groups.google.com/group/macvisionaries >> <http://groups.google.com/group/macvisionaries>. >> For more options, visit https://groups.google.com/d/optout >> <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 > <mailto:macvisionaries+unsubscr...@googlegroups.com>. > To post to this group, send email to macvisionaries@googlegroups.com > <mailto:macvisionaries@googlegroups.com>. > Visit this group at http://groups.google.com/group/macvisionaries > <http://groups.google.com/group/macvisionaries>. > For more options, visit https://groups.google.com/d/optout > <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.
