[access-uk] Re: Excel Drop Down Lists

  • From: "Kevin Lloyd" <kevin.lloyd3@xxxxxxx>
  • To: <access-uk@xxxxxxxxxxxxx>
  • Date: Tue, 28 Feb 2012 20:32:13 -0000

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

Other related posts: