And of course once you open the context menu one of the first few options is “Sort ascending”, and the next is “Sort Descending”. Those are for sorting rather than filtering. You do not need the submenu for the sorting options, only the filtering options. Sorry if that explanation was not needed, just thought I’d add it so it’s clear for anyone that’s interested.
> On 11 Jan 2015, at 4:26 am, Jürgen Fleger <[email protected]> wrote: > > 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] >> <mailto:[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] > <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.
