Re: Jaws use with Excel


george b <gbmagoo@...>
 

You can also do

Alt plus h plus o and then arrow down to what you want and hit enter.

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

wow don't recall tht key stroke must have been recently added lol
----- Original Message -----
From: "Sieghard Weitzel" <sieghard@...>
To: <main@jfw.groups.io>
Sent: Wednesday, January 18, 2017 10:17 AM
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 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.