[access-uk] Re: Excel Drop Down Lists
- From: "John Gregory" <jgm.gregory@xxxxxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Tue, 28 Feb 2012 21:31:32 -0000
Hi Kevin,
Not overly into creating these list/boxes either, but if you do come across
an example, would be interesting to look at it.
John.
-----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
** 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:
