OK, thanks for your answer. That was very clear to me. Now I’m able to figure out more. All the best Jürgen
> Am 10.01.2015 um 15:55 schrieb Phil Halton <[email protected]>: > > Yes, VO does not always speak the initial list of row/column headers when you > first enter the headers. But, arrowing up or down will speak either row or > column header. anyway, once you have your desired column selected and have > brought up the context menu, you have those sort and filter options as you > said. The context menu entry called “sort and filter options” is just a > heading for options that are listed below it. > Below sort and filter options you will find “filter table” which is a > submenu. in that submenu, you will find a listing of all the unique data > found in the selected column. If you press VO spacebar, or enter on any of > these entries, Numbers will filter the table showing only those rows that > contain the filtered data item. > For example, a table with a column containing the name of the month could be > filtered to show only “January” entries. > This is a shortcut method of filtering the table which can also be done in > the sort and filter inspector, where you can specify more sophisticated > filter rules. > Check out the sort inspector after you do this shortcut filtering method and > you’ll see that numbers created a rule to produce the filter you selected in > the context menu. You can add to it, modify the rule, or delete all or part > of it etc. > It’s important to know that once you’ve filtered a table, you can’t use the > VO arrow keys. you have to use the arrow keys by themselves to see the > filtered table rows/columns. If you use the VO arrow keys, Numbers will show > you the unfiltered table entries along with the desired filtered data. > > > > > >> On Jan 10, 2015, at 5:13 AM, Jürgen Fleger <[email protected] >> <mailto:[email protected]>> wrote: >> >> Hi Phil, >> >> I didn’t want to dought your instructions. I’m sorry if I raised this >> impression. I find it very useful if people take the time to answer very >> detailed. Thanks for that. And I agree, to assume people know to press Enter >> is something you can expect. >> >> What I find confusing: >> 1. My VO doesn’t anounces wether the column is highlighted or not. >> 2. After choosing a column I can open a context menue. There’s an entry >> called something like „Sorting and filter options“. I translated this entry >> name from german and so it might be a little bit different in your context >> menue. If I press on this entry nothing happens. Do you know something about >> this functionality? >> >> All the best >> Jürgen >> >> >> >>> Am 09.01.2015 um 15:59 schrieb Phil Halton <[email protected] >>> <mailto:[email protected]>>: >>> >>> Yes, I use V3.5 (2019). I don’t know what your question is, all I said was >>> that you could sort up or down (high or low or whatever you want to call >>> it). I detailed the method I use for sorting table rows using a specific >>> column as the sort key. I also showed how I sort subsets of rows and >>> columns. You can also use multiple sort keys. So, what method are you >>> saying doesn’t seem to work? Did you forget to press enter or VO space on >>> the header selections? You know after entering the headers and arrowing >>> down to either row or column headers, did you first press enter before >>> trying to arrow right or left to the specific column header to use? It’s >>> the only thing I can think of that you might have not done. I re-read my >>> message and that’s the only thing I left out. I just assumed people knew >>> that sort of thing. >>> >>> >>> >>>> On Jan 9, 2015, at 4:36 AM, Jürgen Fleger <[email protected] >>>> <mailto:[email protected]>> wrote: >>>> >>>> Hi Phil, >>>> did you try this method in Numbers version 3.5 (2109)? I’mnot quite sure >>>> but it seems not really to work that way anymore. All I can do is sorting >>>> up or down. But if you could try it out and tell wether it worked still >>>> for you in this version of Numbers it would be a motivation for me to play >>>> around a little more. >>>> Thanks and >>>> all the best >>>> Jürgen >>>> >>>> >>>>> Am 08.01.2015 um 21:51 schrieb Phil Halton <[email protected] >>>>> <mailto:[email protected]>>: >>>>> >>>>> In numbers, I sort table rows/columns by the following method. I don’t >>>>> know if this will work the same with a selection, but it might. A little >>>>> experimentation will tell the tale. >>>>> >>>>> for sorting tables by row or column. >>>>> 1, position VO anywhere in the table and press VO Shift Vertical bar (the >>>>> key above the return key). >>>>> 2, Press VO down or up arrow to select whether to work in rows or columns. >>>>> 3, VO right or left to select the desired column heading, or up and down >>>>> to select the desired row heading, and press VO space to select it. >>>>> >>>>> for example, if you wanted to sort by column C, you would arrow down to >>>>> Column headers after pressing VO shift vertical bar, then arrow right or >>>>> left until you get to Column C and then press VO space to make it the >>>>> selected column. >>>>> >>>>> 4, bring up the context menu with VO shift M. >>>>> 5, arrow down through the menu and select the desired sort option. >>>>> 6, exit the headers and return to the normal table mode by pressing VO >>>>> shift vertical bar again. >>>>> >>>>> This procedure sorts the entire table by either rows or columns. To sort >>>>> a subset of rows/columns in a table, you would first select the >>>>> rows/columns to be sorted, and then go into the sort/filter inspector. in >>>>> there you would add the row or column you wish to sort by by pressing the >>>>> “add” button, and then you can set sort options in the scroll area >>>>> before actually doing the sort by pressing the “sort now” button. >>>>> >>>>> I just messed around with this a little and I don’t believe you can sort >>>>> just a selection of data in a table row or column. That is, the entire >>>>> row or column will be included in the sort action with the selected field >>>>> being the sort key. >>>>> Hope this all makes sense. >>>>> >>>>>> >>>>>> Hi, >>>>>> try to jump to the head of the table at first by pressing VO + Shift + >>>>>> ‚. It might be another key combination on english keyboards but you >>>>>> might find it yourself. There you can choose wether to jump to column >>>>>> head or row head. Then you can open the context menue. >>>>>> But in terms of the sorting data entry in the menue I got the same >>>>>> results. I wonder wether there’s something broken. >>>>>> All the best >>>>>> Jürgen >>>>>> >>>>>> >>>>>>> Am 08.01.2015 um 17:53 schrieb Jim Fettgather <[email protected] >>>>>>> <mailto:[email protected]>>: >>>>>>> >>>>>>> This one really has me stumped. >>>>>>> After highlighting a row of numbers to be sorted in either a row or >>>>>>> column of numbers, then stop interacting with the table and VO left >>>>>>> arrow to the formatter group, because this seems to be where the sort >>>>>>> options are located, no matter what I select, the sort now option is >>>>>>> dimmed. >>>>>>> Evem doing VO Shift M, and then selecting sort options, I am >>>>>>> immediately returned back to the spreadsheet. >>>>>>> Is there a hidden secrent to be able to sort data in Numbers? >>>>>>> Thanks. >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> 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] >>>>> <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] >>> <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] > <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.
