Date   

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@sbcglobal.net>
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@live.ca>
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@sbcglobal.net> 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@live.ca>
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@sbcglobal.net>
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@gmail.com>
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@gmail.com> 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@gmail.com

















--
Soronel Haetir
soronel.haetir@gmail.com









Re: Jaws use with Excel ... sorting

Dave...
 

Once you select the range to sort, you can simply press the Application Key
(or shift+F10) and select sort.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer

----- Original Message -----
From: "Palmer Loux" <Plmrlx@gmail.com>
To: <main@jfw.groups.io>
Sent: Tuesday, January 17, 2017 12:28
Subject: Re: Jaws use with Excel ... sorting


Or place focus in excel table control a to select all?
Then alt to ribbon and in home tab tab all the way to sort? Hoping to do it
shorter with shortcut

Sent from my iPhone

On Jan 17, 2017, at 3:16 PM, "Ann Byrne" <annakb@sbcglobal.net> wrote:

When you are sorting in Excel, you need to select the range of data to be
sorted, not just the column. If only a column is sorted, it will be out
of sync with the rest of the worksheet. So if you are sorting by last
name, and have Alan Allen, John Johnson, and Fred Frederick, and sort only
the lastn ame column you will end up with Alan allen, Fred Johnson, and
John Fredericks.

So.

1. Select the range you are sorting: f5, go to; first cell colon last
cell, enter. Now with it all selected, go to the ribbon and tell it what
you want to sort.

At 07:57 AM 1/17/2017, you 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



Re: Changing font style and size in Word with Jaws

 

Thanks, Control+D also works in Word 2016 as does Ann’s method with Control+Shift+P which takes you directly to the size and Control+Shift+F which takes you to the font (same as Control+D.

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Marquette, Ed
Sent: Tuesday, January 17, 2017 5:45 PM
To: main@jfw.groups.io
Subject: Re: Changing font style and size in Word with Jaws

 

In Word 2013 (and prior versions), one selects the text.  Then press control + d.  That brings up a dialog box.  From there, you can choose the font type, the size, the color, and attributes.

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Sieghard Weitzel
Sent: Tuesday, January 17, 2017 6:30 PM
To: main@jfw.groups.io
Subject: Changing font style and size in Word with Jaws

 

Hi,

 

I don’t use Word a lot, but in Word 2016 I am having a heck of a time finding where I can easily and quickly change the font size, pick other fonts or choose font colours. Can somebody give me some pointers on how to best do this with Jaws?

 

Thanks,

Sieghard

 


This E-mail message is confidential, is intended only for the named recipients above and may contain information
that is privileged, attorney work product or otherwise protected by applicable law. If you have received this
message in error, please notify the sender at 402-346-6000 and delete this E-mail message.
Thank you.


Re: Jaws use with Excel

Dave...
 

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@sbcglobal.net>
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@live.ca>
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@sbcglobal.net> 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@live.ca>
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@sbcglobal.net>
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@gmail.com>
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@gmail.com> 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@gmail.com

















--
Soronel Haetir
soronel.haetir@gmail.com









Re: Changing font style and size in Word with Jaws

Marquette, Ed <ed.marquette@...>
 

In Word 2013 (and prior versions), one selects the text.  Then press control + d.  That brings up a dialog box.  From there, you can choose the font type, the size, the color, and attributes.

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Sieghard Weitzel
Sent: Tuesday, January 17, 2017 6:30 PM
To: main@jfw.groups.io
Subject: Changing font style and size in Word with Jaws

 

Hi,

 

I don’t use Word a lot, but in Word 2016 I am having a heck of a time finding where I can easily and quickly change the font size, pick other fonts or choose font colours. Can somebody give me some pointers on how to best do this with Jaws?

 

Thanks,

Sieghard

 


This E-mail message is confidential, is intended only for the named recipients above and may contain information
that is privileged, attorney work product or otherwise protected by applicable law. If you have received this
message in error, please notify the sender at 402-346-6000 and delete this E-mail message.
Thank you.


Re: Sound Card

John ESherrer
 

I had a Plantonic headphone that came with its own USB soundcard.  I do not remember if it stopped the computer soundcard, but an extra USB sound card might work.

John Sherrer

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Michael Mote
Sent: Tuesday, January 17, 2017 1:33 PM
To: main@jfw.groups.io
Subject: Re: Sound Card

 

You may want to check out the Virtual Audio Cable program.  I think there is a cost involved, but I think it would meet your needs.

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Tony
Sent: Tuesday, January 17, 2017 2:05 PM
To: main@jfw.groups.io
Subject: Sound Card

 

Back in the dark ages I had a sound card that allowed me to have 3 stereo output streams.  Any ideas for something similar would be appreciated.

 

Tony

 


Re: Jaws use with Excel ... sorting

Dale Alton <blinkydale@...>
 

I find Shift+tab is quicker for the headers.

Denver Dale

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Ann Byrne
Sent: Tuesday, January 17, 2017 6:25 PM
To: main@jfw.groups.io
Subject: Re: Jaws use with Excel ... sorting

then alt+a, followed by s, and another s. You will be on an okay
button. Tab six times or so to check "my data has column headers",
and then tab to the combo box to select which column you are
sorting. Aledgedly alt+a, then s, then a is a quick sort of either
the first or last column; but you can't customize it and choose a
middle column.
At 02:28 PM 1/17/2017, you wrote:
Or place focus in excel table control a to select all?
Then alt to ribbon and in home tab tab all the way to sort? Hoping
to do it shorter with shortcut

Sent from my iPhone

On Jan 17, 2017, at 3:16 PM, "Ann Byrne" <annakb@sbcglobal.net> wrote:

When you are sorting in Excel, you need to select the range of
data to be sorted, not just the column. If only a column is
sorted, it will be out of sync with the rest of the worksheet. So
if you are sorting by last name, and have Alan Allen, John Johnson,
and Fred Frederick, and sort only the lastn ame column you will end
up with Alan allen, Fred Johnson, and John Fredericks.

So.

1. Select the range you are sorting: f5, go to; first cell colon
last cell, enter. Now with it all selected, go to the ribbon and
tell it what you want to sort.

At 07:57 AM 1/17/2017, you 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




Re: Jaws use with Excel ... sorting

Ann Byrne
 

then alt+a, followed by s, and another s. You will be on an okay button. Tab six times or so to check "my data has column headers", and then tab to the combo box to select which column you are sorting. Aledgedly alt+a, then s, then a is a quick sort of either the first or last column; but you can't customize it and choose a middle column.

At 02:28 PM 1/17/2017, you wrote:
Or place focus in excel table control a to select all?
Then alt to ribbon and in home tab tab all the way to sort? Hoping to do it shorter with shortcut

Sent from my iPhone

On Jan 17, 2017, at 3:16 PM, "Ann Byrne" <annakb@sbcglobal.net> wrote:

When you are sorting in Excel, you need to select the range of
data to be sorted, not just the column. If only a column is sorted, it will be out of sync with the rest of the worksheet. So if you are sorting by last name, and have Alan Allen, John Johnson, and Fred Frederick, and sort only the lastn ame column you will end up with Alan allen, Fred Johnson, and John Fredericks.

So.

1. Select the range you are sorting: f5, go to; first cell colon
last cell, enter. Now with it all selected, go to the ribbon and tell it what you want to sort.

At 07:57 AM 1/17/2017, you 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




Re: Jaws use with Excel ... sorting

Nicole Massey <nyyki@...>
 

Excel will alert you if you need to expand your selection and do it for you
if you tell it to, so it's not a big risk. This is true from '97 all the way
to 2013. (haven't tried Excel 2016, but it'd be sort of dumb for them to
change this alert) It's safer to pick a single column than try to select
everything yourself, as sometimes if you select more Excel doesn't alert
you, while going from the single column angle it always does.

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Palmer
Loux
Sent: Tuesday, January 17, 2017 2:29 PM
To: main@jfw.groups.io
Subject: Re: Jaws use with Excel ... sorting

Or place focus in excel table control a to select all?
Then alt to ribbon and in home tab tab all the way to sort? Hoping to do it
shorter with shortcut

Sent from my iPhone

On Jan 17, 2017, at 3:16 PM, "Ann Byrne" <annakb@sbcglobal.net> wrote:

When you are sorting in Excel, you need to select the range of data to be
sorted, not just the column. If only a column is sorted, it will be out of
sync with the rest of the worksheet. So if you are sorting by last name,
and have Alan Allen, John Johnson, and Fred Frederick, and sort only the
lastn ame column you will end up with Alan allen, Fred Johnson, and John
Fredericks.

So.

1. Select the range you are sorting: f5, go to; first cell colon last
cell, enter. Now with it all selected, go to the ribbon and tell it what
you want to sort.

At 07:57 AM 1/17/2017, you 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



Re: Jaws use with Excel ... sorting

Palmer Loux <Plmrlx@...>
 

Or place focus in excel table control a to select all?
Then alt to ribbon and in home tab tab all the way to sort? Hoping to do it shorter with shortcut

Sent from my iPhone

On Jan 17, 2017, at 3:16 PM, "Ann Byrne" <annakb@sbcglobal.net> wrote:

When you are sorting in Excel, you need to select the range of data to be sorted, not just the column. If only a column is sorted, it will be out of sync with the rest of the worksheet. So if you are sorting by last name, and have Alan Allen, John Johnson, and Fred Frederick, and sort only the lastn ame column you will end up with Alan allen, Fred Johnson, and John Fredericks.

So.

1. Select the range you are sorting: f5, go to; first cell colon last cell, enter. Now with it all selected, go to the ribbon and tell it what you want to sort.

At 07:57 AM 1/17/2017, you 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



Re: Jaws use with Excel

Palmer Loux <Plmrlx@...>
 

Thanks will try!

Sent from my iPhone

On Jan 17, 2017, at 11:01 AM, "Dave Carlson" <dgcarlson@sbcglobal.net> wrote:

...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@sbcglobal.net>
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@gmail.com>
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@gmail.com> 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@gmail.com









Re: Changing font style and size in Word with Jaws

 

Thanks, I like it when there is an easy solution.

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Betsy Binney
Sent: Tuesday, January 17, 2017 4:54 PM
To: main@jfw.groups.io
Subject: Re: Changing font style and size in Word with Jaws

 

Control Shift P to change the size

Control Shift F to change the font name

Betsy 


On Jan 17, 2017, at 6:29 PM, Sieghard Weitzel <sieghard@...> wrote:

Hi,

 

I don’t use Word a lot, but in Word 2016 I am having a heck of a time finding where I can easily and quickly change the font size, pick other fonts or choose font colours. Can somebody give me some pointers on how to best do this with Jaws?

 

Thanks,

Sieghard

 


Re: Changing font style and size in Word with Jaws

Betsy Binney
 

Control Shift P to change the size
Control Shift F to change the font name

Betsy 

On Jan 17, 2017, at 6:29 PM, Sieghard Weitzel <sieghard@...> wrote:

Hi,

 

I don’t use Word a lot, but in Word 2016 I am having a heck of a time finding where I can easily and quickly change the font size, pick other fonts or choose font colours. Can somebody give me some pointers on how to best do this with Jaws?

 

Thanks,

Sieghard

 


Re: Jaws use with Excel

Joseph Weakland
 

wow didn't know about the shftf11 command thanks:)

----- Original Message -----
From: "Ann Byrne" <annakb@sbcglobal.net>
To: <main@jfw.groups.io>
Sent: Tuesday, January 17, 2017 5:15 PM
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@live.ca>
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@sbcglobal.net> 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@live.ca>
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@sbcglobal.net>
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@gmail.com>
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@gmail.com> 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@gmail.com

















--
Soronel Haetir
soronel.haetir@gmail.com










Changing font style and size in Word with Jaws

 

Hi,

 

I don’t use Word a lot, but in Word 2016 I am having a heck of a time finding where I can easily and quickly change the font size, pick other fonts or choose font colours. Can somebody give me some pointers on how to best do this with Jaws?

 

Thanks,

Sieghard

 


Re: Jaws use with Excel

 

Thanks, Ann, that is a nice shortcut to know, the ribbon key combination isn't bad, but Shift+F11 is certainly easier and faster.
Do you know a shortcut for renaming a sheet and also for moving/copying one?
I miss how in Excel 2010 and earlier I could use the Jaws cursor, find a list of all the sheets along the bottom and just right click on one to get to all these options.


Regards,
Sieghard

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Ann Byrne
Sent: Tuesday, January 17, 2017 3:15 PM
To: main@jfw.groups.io
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@live.ca>
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@sbcglobal.net> 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@live.ca>
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@sbcglobal.net>
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@gmail.com>
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@gmail.com> 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@gmail.com

















--
Soronel Haetir
soronel.haetir@gmail.com









Re: Jaws use with Excel

Ann Byrne
 

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@live.ca>
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@sbcglobal.net> 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@live.ca>
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@sbcglobal.net>
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@gmail.com>
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@gmail.com> 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@gmail.com

















--
Soronel Haetir
soronel.haetir@gmail.com









Re: Jaws use with Excel

Dave...
 

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@live.ca>
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@sbcglobal.net> 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@live.ca>
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@sbcglobal.net>
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@gmail.com>
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@gmail.com> 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@gmail.com

















--
Soronel Haetir
soronel.haetir@gmail.com


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@sbcglobal.net> 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@live.ca>
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@sbcglobal.net>
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@gmail.com>
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@gmail.com> 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@gmail.com

















--
Soronel Haetir
soronel.haetir@gmail.com


Re: Jaws use with Excel ... sorting

 

Hi Ann,

If I right click on a column header or use the Application Key or Shift+F10 and then arrow to sort and press enter on A to Z that column is sorted alphabetically and all other columns are maintained. For example, if I have a last name column, a first name column, one for address, city and phone number and I sort the last name column A to Z the correct first name, address, city and phone number is moved and stays with the last name it belongs to. I do not have to select the entire range of the table to sort correctly.

Regards,
Sieghard

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Ann Byrne
Sent: Tuesday, January 17, 2017 12:59 PM
To: main@jfw.groups.io
Subject: Re: Jaws use with Excel ... sorting

You want to be sure to sort the whole row, not just the column, so that all the associated data follows your change. So if you sort the last name column, but the first name column doesn't get sorted, the pieces won't belong together.
At 02:45 PM 1/17/2017, you wrote:
Ann,

Yes, but if you have the drop-down menus enabled on the column
headings, a sort from there will sort the entire column. We may be
talking at cross purposes here.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


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


When you are sorting in Excel, you need to select the range of data to
be sorted, not just the column. If only a column is sorted, it will be
out of sync with the rest of the worksheet. So if you are sorting by
last name, and have Alan Allen, John Johnson, and Fred Frederick, and
sort only the lastn ame column you will end up with Alan allen, Fred
Johnson, and John Fredericks.

So.

1. Select the range you are sorting: f5, go to; first cell colon last
cell, enter. Now with it all selected, go to the ribbon and tell it
what you want to sort.

At 07:57 AM 1/17/2017, you 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