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