Thanks Guy - this is really useful to know. I'll pay particular attention next time I come across one of these spreadsheets with inaccessible dropdowns and come back if I need any further assistance.
Regards. Kevin Lloyd E-mail: kevin.lloyd3@xxxxxxx----- Original Message ----- From: "Guy Barlow Workforce Analyst, PCP&R" <Guy.Barlow@xxxxxxxxxxxx>
To: <access-uk@xxxxxxxxxxxxx> Sent: Wednesday, February 29, 2012 9:23 AM Subject: [access-uk] Re: Excel Drop Down Lists
Hello There are two different types of drop down lists in Excel one that is created using the data validation wizard and one which is created using the Excel tool kit. The main difference from a visual perspective is the drop down arrow: the drop down arrow for a data validation list only appears when that cell becomes active and the ddrop down list created using the Tool kit is visible at all times. The Data validation method is highly accessible for screen readers and is easy to set up whilst the Tool kit version I've found cannot be accessed via a screen reader. However there is a work around for this latter method if you have unprotected access to the spreadsheet. The tool kit method references a list held on the spreadsheet using the Match formula so it is possible to directly pick from the list in this area of the spredsheet and then return to the main area. I'd be happy to assist anyone if needed using and setting up both methods Kind Regards Guy Guy Barlow Strategic Information Analyst (Performance and Organisational Intelligence) Essex County Council | telephone: 01245430392 | extension: 20392 | -----Original Message----- From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf Of Kevin Lloyd Sent: 28 February 2012 20:32 To: access-uk@xxxxxxxxxxxxx Subject: [access-uk] Re: Excel Drop Down Lists Hi John. Not sure I can at the moment as I don't have an example at hand. I have to deal with a lot of excel spreadsheets at work and, in general, most drop downs can be set via the alt + down arrow and then pressing enter when the selection has been made. However, there are some I come across where JAWS doesn't announce the existence of the drop down box in the cell and there is no way of opening it. I don't know enough about creating drop down lists in excel to know if there are a number of different ways of creating them where one approach results in the accessible drop down and the other in a non-accessible... Regards. Kevin Lloyd E-mail: kevin.lloyd3@xxxxxxx----- Original Message ----- From: "John Gregory" <jgm.gregory@xxxxxxxxxxxx>To: <access-uk@xxxxxxxxxxxxx> Sent: Tuesday, February 28, 2012 8:12 PM Subject: [access-uk] Re: Excel Drop Down ListsHi Kevin, I created a drop box in an Excel sheet and just moved to the cell and pressed alt and down arrow and the box opened. Not really aware of anyother kind of drop box, but if you could give an example I might be able to replicate? John. -----Original Message----- From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] OnBehalfOf Kevin Lloyd Sent: 28 February 2012 19:22 To: access-uk@xxxxxxxxxxxxx Subject: [access-uk] Re: Excel Drop Down Lists Hi John. That works for some drop down boxes integrated into excel sheets butthereis another use of drop down lists where there is a small graphicalarrowin the cell and JAWS can't recognise this. Placing the JAWS cursor overthegraphic with the help of a sighted colleague and then issuing a leftmouseclick will open the drop down list but otherwise, I haven't found any other way of activating this latter type of drop down. Regards. Kevin Lloyd E-mail: kevin.lloyd3@xxxxxxx----- Original Message ----- From: "John Gregory" <jgm.gregory@xxxxxxxxxxxx>To: <access-uk@xxxxxxxxxxxxx> Sent: Monday, February 27, 2012 10:57 PM Subject: [access-uk] Re: Excel Drop Down ListsHi Colin, Just hold down the alt key and then down arrow. At least that is thekeysequence in JAWS. John. -----Original Message----- From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] OnBehalfOf Colin Phelan Sent: 27 February 2012 20:50 To: access-uk@xxxxxxxxxxxxx Subject: [access-uk] Excel Drop Down Lists Hi All, Does anyone know how to access a drop down list from the little arrowonthe right of a cell in excel please? Thanks Colin ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq ** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq Click https://www.mailcontrol.com/sr/Sufx82K71x!TndxI!oX7Ujl7!50yUj9OC8xRNIWJ5 fE+QQVOZLfd7Vsi1i4J975+gtNWqLTw22qjfskgLULbMA== to report this email as spam.This email (including any attachments) is intended only for the recipient(s) named above. It may contain confidential or privileged information and should not be read, copied or otherwise used by any other person unless express permission is given. If you are not a named recipient, please contact the sender and delete the email from your system. It is the recipient's responsibility to ensure that appropriate measures are in place to check for software viruses.** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=unsubscribe] ** If this link doesn't work then send a message to: ** access-uk-request@xxxxxxxxxxxxx ** and in the Subject line type ** unsubscribe ** For other list commands such as vacation mode, click on the ** immediately-following link:- ** [mailto:access-uk-request@xxxxxxxxxxxxx?subject=faq] ** or send a message, to ** access-uk-request@xxxxxxxxxxxxx with the Subject:- faq