Hi, the best resource I found to learn and deepening my knowledge of Numbers was „Mastering the Mac with VoiceOver“ by Jim Sniffen. It’s free and available in the iBooks Store. All the best Jürgen
> Am 30.03.2015 um 04:33 schrieb Phil Halton <[email protected]>: > > I’ll take a stab at this. > if you create a header row or a header column in your table and place a text > description in that header cell, then you can reference that label in the > formula editor to refer to the entire row/column. > for example, if you have one header row with contents columnA, columnB, > columnC etc across row 1. then you could have a formula tlike =sum(columnA) > and that would sum all cells in column a. > Tables have header areas with a max of 5 rows, a data area with unspecified > number of rows, and a footer area with a max of 5 rows. > The header row closest to the data area is used as labels for the data . > Also, there can be header columns up to a max of 5, and the column closest to > the data area is used as labels for the data rows. > So, with a single header column containing labels row 2, row3, row4, etc. You > could reference a single data cell with an address of colB,row4 for example. > When in the editor, just start typing the name of the row or column header > label and it will auto complete for you if possible. > > Hope this is what your asking for, I’m a bit tired and not giving my best > thought to the question. Hope it gets you started. > Also, I highly recommend reading the section on relative and absolute > addressing and all other general topics in the numbers help system. reading > that and then experimenting with simple formulas will answer more questions > for you than you might think. > >> On Mar 29, 2015, at 6:40 PM, Eileen Misrahi <[email protected]> wrote: >> >> Hello All, >> >> I'm in the same boat as Laura, but have applied some of the same principles >> that I've used in Excel. What surprised me was that VO announced the header >> for each column when in a particular cell. I was wondering how specify the >> defined ranges when creating a simple formula. It was difficult to ascertain >> the coordinates of the column and row like in Excel. I just opened the >> formula dialog list and chose "sum" to get it inserted to tabulate the >> column. Any suggestions regarding the above would be appreciated. >> >> Thanks in advance. >> >> Best, >> Eileen >> >> Sent from my iPhone >> >>> On Mar 29, 2015, at 3:18 PM, Eugenia Firth <[email protected]> wrote: >>> >>> Hi Laura >>> If you know how to use Excel, you should know that numbers will except >>> Excel files. One of the things you should know right away so that you don't >>> take forever to figure it out, is that when you press the = to start your >>> formula, the first thing to do is to press the right arrow key. That get >>> you in the correct cursor position to start the rest to your formula. >>> >>> Gigi >>> >>> Sent from my iPhone >>> >>>> On Mar 29, 2015, at 3:47 PM, Laura Bratton <[email protected]> wrote: >>>> >>>> Hi All, >>>> Can anyone recommend a good resource for learning how to use numbers? >>>> Thank you, >>>> Laura >>>> >>>> -- >>>> 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. >>> >>> -- >>> 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. >> >> -- >> 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. > > -- > 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. -- 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.
