moderated Re: Microsoft Excel And Filters
Van Lant, Robin
I use filters a lot.
Go to a cell in your header row, then hit the Filter button on the Data ribbon to turn on filters for that entire row of headers.
When you want to filter a particular column, go do that column header and hit alt down arrow to expand the filter choices.
I’m usually filtering on txt in the cells. The easiest way I find to do this is to Shift tab back three times till I hear Select all. You’ll be passing over a cancel button and an OK button.
Then you arrow down the list of options, checking an unchecking the boxes you want to see or hide. Annoyingly I cannot find a way to page down or use first letter navigation to quickly move through a long list.
If you know you want to see most of the rows, but hide just a few, leave the Select All option at the top check and arrow down to find the few options you want to filter out.
If you want to hide a majority of rows and only see certain items, then uncheck the Select All option at the top and move down to place a check in the text items you want.
Once you have that done, you just tab once to the OK button and hit enter. .JAWS does not read this button clearly; it sounds something more like type the text you want OK.
Happy to talk more if you have specific questions as you try it.
From: email@example.com <firstname.lastname@example.org> On Behalf Of Hicks Steven (CORNWALL IT SERVICES) via Groups.Io
Sent: Thursday, February 27, 2020 3:14 AM
Subject: Microsoft Excel And Filters
Has anyone managed to work out how to use filters with Microsoft excel and JAWS?
127 Public Square, Cleveland, OH 44114
If you prefer not to receive future e-mail offers for products or services from Key, send an email to mailto:DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.