This is a much better way of filtering/searching than I had previously mentioned - I didn't know about the headers via vo shift backslash. It reminds me a lot of the way you can choose the filters in excel. Also, once selected, you can tweak the filter in the formatter to allow greater latitude in the filter matching (e.g. exact, begins with, ends with, contains etc) Also, you don't need to view the filter results in the scroll area as I had said earlier, but can work directly in the table, skipping hidden rows/columns by using the arrow keys alone - great stuff. I thought I had read that you couldn't edit the table or add/delete rows when filtering was turned on, so that you need to uncheck the filters checkbox in the formatter before doing any editing. Is this so? I'll have to recheck that in the help system.
I'm beginning to like numbers a lot. The formula editor is a breeze to work with and everything is accessible. Keep the tips coming Nick and all Apr 4, 2014, at 8:16 AM, Nicholas Parsons <mr.nicholas.pars...@gmail.com> wrote: > One thing you might like to try to find a particular cell is the filter and > sort options. > Press VO-shift-\ to jump into the headers. > Press VO-down-arrow and VO-up-arrow until you get to the column reference > cell, and then select it with VO-space. > Navigate until you get to the header of the column in which your expense is > listed, e.g. item description or whatever. > Press VO-shift-m to bring up the context menu, navigate to the filter table > submenu, and select the item you're after. > Alternatively, select sort and filter from the toolbar, and then interact > with the format inspector to choose your filter options. > > Also, I need to confess and apologise. In a related thread on this list a > short while back, we were discussing navigating in Numbers, and I said I > preferred VO-arrow keys to navigate around. I need to take that back now. > Navigating with just the arrow keys is actually proving to be better. In > particular, VoiceOver doesn't detect which rows have been filtered or hidden > if you navigate using the VO keys, but if you just use the arrow keys then > you won't come across hidden rows or columns. Using just the arrow keys, you > can't wrap around to the next row and column once you get to the end of a > row, but that's not such a big deal. > > Best, > Nic > > -- > 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. -- 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.
