Re: Jaws use with Excel


Sieghard Weitzel <sieghard@...>
 

I agree, Control+PageDown and Control+PageUp work for me whereas sometimes for no reason Jaws Key+Control+S does not bring up a list of available sheets. This seems to be intermittent because for the same workbook it usually works but sometimes it doesn't.

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Dave Carlson
Sent: Wednesday, January 18, 2017 9:21 AM
To: main@jfw.groups.io
Subject: Re: Jaws use with Excel

Palmer,

No reason why those keystrokes should not work. Does that workbook even have multiple sheets?

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Palmer Loux" <Plmrlx@...>
To: <main@jfw.groups.io>
Sent: Wednesday, January 18, 2017 09:03
Subject: Re: Jaws use with Excel


Ok we are having trouble with getting to the next sheet in a workbook the
old command of control page up or down does not do that thanks folks this is
awesome info gathering!

Sent from my iPhone

On Jan 18, 2017, at 11:38 AM, "Dave Carlson" <dgcarlson@...>
wrote:

George,

It's likely that there is another assignment to that key combination on
the
laptop that is interfering with the Excel combination. You could map a
different key combination in the Excel keyboard manager, or reassign the
one
that's conflicting.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "george b" <gbmagoo@...>
To: <main@jfw.groups.io>
Sent: Wednesday, January 18, 2017 08:21
Subject: Re: Jaws use with Excel


Well using a laptop with the caps lock used as jaws key / insert it does
not
work

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Sieghard
Weitzel
Sent: January 18, 2017 08:18
To: main@jfw.groups.io
Subject: Re: Jaws use with Excel

It does work for me. Jaws Key which is the Insert or Zero on the Numpad
pressed together with the Shift key and then an "S" as in "Sheet". Also
pretty easy to remember.
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of george b
Sent: Wednesday, January 18, 2017 6:02 AM
To: main@jfw.groups.io
Subject: Re: Jaws use with Excel

Dave,

That did not work for me in excel 2016

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Dave
Carlson
Sent: January 17, 2017 20:38
To: main@jfw.groups.io
Subject: Re: Jaws use with Excel

Sieghard,

Use the JAWS shortcut JAWS + Shift + S to bring up a menu of
copy/move/insert/rename/protect/hide sheets.


Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Sieghard Weitzel" <sieghard@...>
To: <main@jfw.groups.io>
Sent: Tuesday, January 17, 2017 17:58
Subject: Re: Jaws use with Excel


How about renaming, moving/copying or deleting a sheet? Any shortcuts for
that?
Here are the ribbon shortcuts:
Rename sheet: Alt+H followed by "O" for Format and "R" for rename Move or
copy sheet: Alt+H followed by "O" and "M"
Delete sheet: Alt+H followed by "D" for delete and "S" for sheet Insert
sheet: Alt+H followed by "I" for insert and "S" or, as previously
mentioned,
Shift+F11

Regards,
Sieghard

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Dave
Carlson
Sent: Tuesday, January 17, 2017 5:50 PM
To: main@jfw.groups.io
Subject: Re: Jaws use with Excel

Cool. Either I never knew this, or did in my younger days and completely
forgot. Appreciate the tip.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Ann Byrne" <annakb@...>
To: <main@jfw.groups.io>
Sent: Tuesday, January 17, 2017 15:15
Subject: Re: Jaws use with Excel


shift+f11 creates a sheet.
At 04:31 PM 1/17/2017, you wrote:
Sieghard,

I use 2007 and I also use the Alt + h then i then s to insert a sheet.

Don't think F6 creates a sheet - not sure where that came from.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Sieghard Weitzel" <sieghard@...>
To: <main@jfw.groups.io>
Sent: Tuesday, January 17, 2017 13:44
Subject: Re: Jaws use with Excel


What version of Excel do you use? F6 doesn't add a new sheet to a
workbook for me (I am using Excel 2016). I have to use Alt+H followed
by "I" for insert and "S" for Sheet.


-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Soronel Haetir
Sent: Tuesday, January 17, 2017 10:44 AM
To: main@jfw.groups.io
Subject: Re: Jaws use with Excel

And how do you focus on the headers row?

The arrows don't do that, neither does tab and f6 adds a new sheet to
the workbook.

On 1/17/17, Dave Carlson <dgcarlson@...> wrote:
Give it a couple tries. I find that the keystroke can dump me into
the ribbon, but when I escape from the ribbon, the drop down menus
are there.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Sieghard Weitzel" <sieghard@...>
To: <main@jfw.groups.io>
Sent: Tuesday, January 17, 2017 08:18
Subject: Re: Jaws use with Excel


Good thing you mentioned this because Alt+Shift+L doesn't do
anything in Excel 2016.

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Dave Carlson
Sent: Tuesday, January 17, 2017 8:02 AM
To: main@jfw.groups.io
Subject: Re: Jaws use with Excel

...and I should point out that I'm using Excel 2007 on a Windows 7
machine,

if that has any bearing on different experiences.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Dave Carlson" <dgcarlson@...>
To: <main@jfw.groups.io>
Sent: Tuesday, January 17, 2017 07:59
Subject: Re: Jaws use with Excel


There is another approach that is pretty easy, and is good if you
expect to filter a column more often than once.

When focused on the row of column headers (any column header cell is
fine) Press Alt+Shift+L. Now each column title will announce the
title and "auto filter drop down". When on the column of choice,
press
Alt+DownArrow to bring up a list of filters and sorts you can
Alt+perform
on
that column.

To turn off that feature, press Ctrl+Shift+L on any of the column
titles.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Soronel Haetir" <soronel.haetir@...>
To: <main@jfw.groups.io>
Sent: Tuesday, January 17, 2017 07:42
Subject: Re: Jaws use with Excel


I am not aware of any method easier for the blind than the
applications key. You are certainly right that clicking the column
label is not particularly easy for us.

On 1/17/17, Palmer Loux <Plmrlx@...> wrote:
I have a question relating to sorting and filtering information on
a worksheet with JAWS is there an easy way to filter and sort? For
sorting I am thinking putting focus in a cell in a column you are
wanting to sort then pressing application key, arrow to sort, right
arrow to sub menu and then down arrow to your choice For filtering
information the video I have seen has you going to top of column
and clicking a drop down arrow which can be visually challenging
any other ideas?thanks, Palmer

--
Soronel Haetir
soronel.haetir@...

--
Soronel Haetir
soronel.haetir@...

























Join {main@jfw.groups.io to automatically receive all group messages.