Re: [JAWS-Users] Sorting a 2010 Excel worksheet
Greg, I modified the original instructions. See if this helps. Instructions You need to select all of your data, including the column headings. Use your applications key to bring up the context menu. Select sort. >From the Sort menu, select custom. You are now in a dialog box which JAWS does not read well. Use the tab key to move around in it. The most important things you need to find are as follows: --The checkbox that indicates whether or not the top row is a headings row for the columns of data, or if it is actual data. If you have column headings, make sure it is checked. --Tab until you get to a combo box, or maybe it is a list box, for which column you want to use for sorting. JAWS can be very uncooperative with reading the contents. --There are 2 more combo/list boxes that allow you to set information about sorting on this column I.E. A-Z, Z-A, ascending, descending, etc. Depending on what you want your sort to look like, you may not need to deal with this. Again, JAWS is not always cooperative with reading this information. Now you have to add a level to your sort. Use the Tab key and go past the Cancel button until you come to Add a level. Use space to select. Now when you continue tabbing through the dialog box you will come to a combo box that is labeled "Then by". This will have all of your column headers listed. Just like before there will be 2 other combo boxes that allow you to change other details about sorting on this column of data. Figuring out which column header goes in the first level and which one goes in the second level usually takes some playing around. The way things are worded makes me think the sort will work differently than it comes out. I usually run each sort separately just to avoid frustration. Someday I will take the time to play around with it. HTH, Annette Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Greg Washington Sent: Wednesday, February 7, 2018 9:37 AM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] Sorting a 2010 Excel worksheet I need to sort a Excel 2010 worksheet by two columns. I am using latest Jaws 2018 on a Windows 10 computer. I found the following instructions on line but as they say Jaws doesn't work well with them. Does anyone have any suggestsions on how to improve Jaws functionality in sorting Excel worksheets? Any help would be appreciated. Instructions You need to select all of your data, including the column headings. Use your applications key to bring up the context menu. Select sort. >From the Sort menu, select custom. You are now in a dialog box which JAWS does not read well. Use the tab key to move around in it. The most important things you need to find are as follows: --The checkbox that indicates whether or not the top row is a headings row for the columns of data, or if it is actual data. If you have column headings, make sure it is checked. --Tab until you get to a combo box, or maybe it is a list box, for which column you want to use for sorting. JAWS can be very uncooperative with reading the contents. --There are 2 more combo/list boxes that allow you to set information about sorting on this column I.E. A-Z, Z-A, ascending, descending, etc. Depending on what you want your sort to look like, you may not need to deal with this. Again, JAWS is not always cooperative with reading this information. --There should be another set of 3 combo/list boxes that will allow you to select the second column you want to use for your sort, as well as its criteria. I can never remember which column will need to be in the first set of boxes, verses which one goes in the second set. You will have to play around with it. For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Sorting a 2010 Excel worksheet
OK, thanks. -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Dave...Oregonian Sent: Wednesday, February 7, 2018 3:10 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Sorting a 2010 Excel worksheet Greg, Nope. 2007 is exactly the same. You still need to tab around a lot and if you invoke a second sort column using the Add sort button, you need to use the JAWS cursor to find that combo box to get things moving on that column. Dave Oregonian, woodworker, Engineer, Musician, and Pioneer - Original Message - From: "Greg Washington" <gregw...@comcast.net> To: <jaws-users-list@jaws-users.com> Sent: Wednesday, February 07, 2018 11:32 Subject: Re: [JAWS-Users] Sorting a 2010 Excel worksheet Dave, Thanks for responding. Also I want to apologize to Annette for not acknowledging her as the source of the instructions I copied into my original email. They were (are) helpful. Perhaps its my addled memory but I thought there was another easier way to sort in Excel. Perhaps I'm thinking about Excel 2007. Best, Greg -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of David G. Carlson Via iPhone Sent: Wednesday, February 7, 2018 12:11 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Sorting a 2010 Excel worksheet About as good as you will get. Trial and error required. Dave Sent from my iPhone On Feb 7, 2018, at 6:36 AM, Greg Washington <gregw...@comcast.net> wrote: I need to sort a Excel 2010 worksheet by two columns. I am using latest Jaws 2018 on a Windows 10 computer. I found the following instructions on line but as they say Jaws doesn't work well with them. Does anyone have any suggestsions on how to improve Jaws functionality in sorting Excel worksheets? Any help would be appreciated. Instructions You need to select all of your data, including the column headings. Use your applications key to bring up the context menu. Select sort. >From the Sort menu, select custom. You are now in a dialog box which JAWS does not read well. Use the tab key to move around in it. The most important things you need to find are as follows: --The checkbox that indicates whether or not the top row is a headings row for the columns of data, or if it is actual data. If you have column headings, make sure it is checked. --Tab until you get to a combo box, or maybe it is a list box, for which column you want to use for sorting. JAWS can be very uncooperative with reading the contents. --There are 2 more combo/list boxes that allow you to set information about sorting on this column I.E. A-Z, Z-A, ascending, descending, etc. Depending on what you want your sort to look like, you may not need to deal with this. Again, JAWS is not always cooperative with reading this information. --There should be another set of 3 combo/list boxes that will allow you to select the second column you want to use for your sort, as well as its criteria. I can never remember which column will need to be in the first set of boxes, verses which one goes in the second set. You will have to play around with it. For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Sorting a 2010 Excel worksheet
Greg, Nope. 2007 is exactly the same. You still need to tab around a lot and if you invoke a second sort column using the Add sort button, you need to use the JAWS cursor to find that combo box to get things moving on that column. Dave Oregonian, woodworker, Engineer, Musician, and Pioneer - Original Message - From: "Greg Washington" <gregw...@comcast.net> To: <jaws-users-list@jaws-users.com> Sent: Wednesday, February 07, 2018 11:32 Subject: Re: [JAWS-Users] Sorting a 2010 Excel worksheet Dave, Thanks for responding. Also I want to apologize to Annette for not acknowledging her as the source of the instructions I copied into my original email. They were (are) helpful. Perhaps its my addled memory but I thought there was another easier way to sort in Excel. Perhaps I'm thinking about Excel 2007. Best, Greg -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of David G. Carlson Via iPhone Sent: Wednesday, February 7, 2018 12:11 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Sorting a 2010 Excel worksheet About as good as you will get. Trial and error required. Dave Sent from my iPhone On Feb 7, 2018, at 6:36 AM, Greg Washington <gregw...@comcast.net> wrote: I need to sort a Excel 2010 worksheet by two columns. I am using latest Jaws 2018 on a Windows 10 computer. I found the following instructions on line but as they say Jaws doesn't work well with them. Does anyone have any suggestsions on how to improve Jaws functionality in sorting Excel worksheets? Any help would be appreciated. Instructions You need to select all of your data, including the column headings. Use your applications key to bring up the context menu. Select sort. >From the Sort menu, select custom. You are now in a dialog box which JAWS does not read well. Use the tab key to move around in it. The most important things you need to find are as follows: --The checkbox that indicates whether or not the top row is a headings row for the columns of data, or if it is actual data. If you have column headings, make sure it is checked. --Tab until you get to a combo box, or maybe it is a list box, for which column you want to use for sorting. JAWS can be very uncooperative with reading the contents. --There are 2 more combo/list boxes that allow you to set information about sorting on this column I.E. A-Z, Z-A, ascending, descending, etc. Depending on what you want your sort to look like, you may not need to deal with this. Again, JAWS is not always cooperative with reading this information. --There should be another set of 3 combo/list boxes that will allow you to select the second column you want to use for your sort, as well as its criteria. I can never remember which column will need to be in the first set of boxes, verses which one goes in the second set. You will have to play around with it. For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Sorting a 2010 Excel worksheet
Dave, Thanks for responding. Also I want to apologize to Annette for not acknowledging her as the source of the instructions I copied into my original email. They were (are) helpful. Perhaps its my addled memory but I thought there was another easier way to sort in Excel. Perhaps I'm thinking about Excel 2007. Best, Greg -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of David G. Carlson Via iPhone Sent: Wednesday, February 7, 2018 12:11 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] Sorting a 2010 Excel worksheet About as good as you will get. Trial and error required. Dave Sent from my iPhone On Feb 7, 2018, at 6:36 AM, Greg Washington <gregw...@comcast.net> wrote: I need to sort a Excel 2010 worksheet by two columns. I am using latest Jaws 2018 on a Windows 10 computer. I found the following instructions on line but as they say Jaws doesn't work well with them. Does anyone have any suggestsions on how to improve Jaws functionality in sorting Excel worksheets? Any help would be appreciated. Instructions You need to select all of your data, including the column headings. Use your applications key to bring up the context menu. Select sort. >From the Sort menu, select custom. You are now in a dialog box which JAWS does not read well. Use the tab key to move around in it. The most important things you need to find are as follows: --The checkbox that indicates whether or not the top row is a headings row for the columns of data, or if it is actual data. If you have column headings, make sure it is checked. --Tab until you get to a combo box, or maybe it is a list box, for which column you want to use for sorting. JAWS can be very uncooperative with reading the contents. --There are 2 more combo/list boxes that allow you to set information about sorting on this column I.E. A-Z, Z-A, ascending, descending, etc. Depending on what you want your sort to look like, you may not need to deal with this. Again, JAWS is not always cooperative with reading this information. --There should be another set of 3 combo/list boxes that will allow you to select the second column you want to use for your sort, as well as its criteria. I can never remember which column will need to be in the first set of boxes, verses which one goes in the second set. You will have to play around with it. For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] Sorting a 2010 Excel worksheet
About as good as you will get. Trial and error required. Dave Sent from my iPhone On Feb 7, 2018, at 6:36 AM, Greg Washingtonwrote: I need to sort a Excel 2010 worksheet by two columns. I am using latest Jaws 2018 on a Windows 10 computer. I found the following instructions on line but as they say Jaws doesn't work well with them. Does anyone have any suggestsions on how to improve Jaws functionality in sorting Excel worksheets? Any help would be appreciated. Instructions You need to select all of your data, including the column headings. Use your applications key to bring up the context menu. Select sort. >From the Sort menu, select custom. You are now in a dialog box which JAWS does not read well. Use the tab key to move around in it. The most important things you need to find are as follows: --The checkbox that indicates whether or not the top row is a headings row for the columns of data, or if it is actual data. If you have column headings, make sure it is checked. --Tab until you get to a combo box, or maybe it is a list box, for which column you want to use for sorting. JAWS can be very uncooperative with reading the contents. --There are 2 more combo/list boxes that allow you to set information about sorting on this column I.E. A-Z, Z-A, ascending, descending, etc. Depending on what you want your sort to look like, you may not need to deal with this. Again, JAWS is not always cooperative with reading this information. --There should be another set of 3 combo/list boxes that will allow you to select the second column you want to use for your sort, as well as its criteria. I can never remember which column will need to be in the first set of boxes, verses which one goes in the second set. You will have to play around with it. For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
[JAWS-Users] Sorting a 2010 Excel worksheet
I need to sort a Excel 2010 worksheet by two columns. I am using latest Jaws 2018 on a Windows 10 computer. I found the following instructions on line but as they say Jaws doesn't work well with them. Does anyone have any suggestsions on how to improve Jaws functionality in sorting Excel worksheets? Any help would be appreciated. Instructions You need to select all of your data, including the column headings. Use your applications key to bring up the context menu. Select sort. >From the Sort menu, select custom. You are now in a dialog box which JAWS does not read well. Use the tab key to move around in it. The most important things you need to find are as follows: --The checkbox that indicates whether or not the top row is a headings row for the columns of data, or if it is actual data. If you have column headings, make sure it is checked. --Tab until you get to a combo box, or maybe it is a list box, for which column you want to use for sorting. JAWS can be very uncooperative with reading the contents. --There are 2 more combo/list boxes that allow you to set information about sorting on this column I.E. A-Z, Z-A, ascending, descending, etc. Depending on what you want your sort to look like, you may not need to deal with this. Again, JAWS is not always cooperative with reading this information. --There should be another set of 3 combo/list boxes that will allow you to select the second column you want to use for your sort, as well as its criteria. I can never remember which column will need to be in the first set of boxes, verses which one goes in the second set. You will have to play around with it. For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/