[access-uk] Re: Excel Drop Down Lists
- From: "Guy Barlow Workforce Analyst, PCP&R" <Guy.Barlow@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Wed, 29 Feb 2012 09:23:09 -0000
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 Lists
> Hi 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 any
> other
> 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] On
Behalf
> Of
> 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 but
there
> is another use of drop down lists where there is a small graphical
arrow
> in
> the cell and JAWS can't recognise this. Placing the JAWS cursor over
the
> graphic with the help of a sighted colleague and then issuing a left
mouse
> click 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 Lists
>
>
>> Hi Colin,
>>
>> Just hold down the alt key and then down arrow. At least that is the
key
>> sequence in JAWS.
>>
>> John.
>>
>> -----Original Message-----
>> From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On
Behalf
>> Of
>> 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 arrow
on
>> the
>> 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
Other related posts:
