moderated Re: Microsoft Excel And Filters
Van Lant, Robin
Yes. You’ll want to leave the Select All option checked and arrow down to the last in the list below it, which is “(blanks)” and uncheck that. Wish there was a quicker way to get to it, but arrowing down is the only way I’ve found.
From: email@example.com <firstname.lastname@example.org> On Behalf Of
Hicks Steven (CORNWALL IT SERVICES) via Groups.Io
Thanks so much, that is fantastic!
What I have is a colum going down, I just want to filter that colum so the blank cells are filtered out and the column only lists the cells where the entry is not blank e.g. contains a number.
I Think that it is the alt+down arrow that I could have been missing.
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.
Has anyone managed to work out how to use filters with Microsoft excel and JAWS?
This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you
are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This
communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for
which you are receiving the information.