----- Original Message -----
From: "Dale Alton" <blinkydale@...>
To: <main@jfw.groups.io>
Sent: Wednesday, January 18, 2017 18:29
Subject: Re: Jaws use with Excel ... sorting


I find data bases to be a pain.

Denver Dale


-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Lisle, Ted
(CHFS DMS)
Sent: Wednesday, January 18, 2017 6:45 AM
To: main@jfw.groups.io
Subject: Re: Jaws use with Excel ... sorting

That's way cool. I always wanted to have that option available, simply
because spreadsheets are easier to mess with than most databases.

Ted

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Sieghard
Weitzel
Sent: Tuesday, January 17, 2017 4:39 PM
To: main@jfw.groups.io
Subject: 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@...>
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