[access-uk] Re: Excel Drop Down Lists
- From: "Damon Rose" <damon.rose@xxxxxxxxx>
- To: <access-uk@xxxxxxxxxxxxx>
- Date: Wed, 29 Feb 2012 15:33:37 -0000
We had these at work too. You had the choice of yes or no but actually I
don't think the yes or no were in the cell itself.
-----Original Message-----
From: access-uk@xxxxxxxxxxxxx [mailto:access-uk@xxxxxxxxxxxxx] On Behalf
Of John Gregory
Sent: 28 February 2012 21:32
To: access-uk@xxxxxxxxxxxxx
Subject: [access-uk] Re: Excel Drop Down Lists
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
http://www.bbc.co.uk/
This e-mail (and any attachments) is confidential and may contain personal
views which are not the views of the BBC unless specifically stated.
If you have received it in error, please delete it from your system.
Do not use, copy or disclose the information in any way nor act in reliance on
it and notify the sender immediately.
Please note that the BBC monitors e-mails sent or received.
Further communication will signify your consent to this.
** 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: