main@jfw.groups.io | Jaws use with Excel

Plmrlx@...

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

#44994

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.

Plmrlx@... #44993 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
More All Messages By This Member
Soronel Haetir #44994 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. toggle quoted message Show quoted text 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@...
More All Messages By This Member
Dave... #44995 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 toggle quoted message Show quoted text ----- 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@...
More All Messages By This Member
Dave... #44996 ...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 toggle quoted message Show quoted text ----- 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@...
More All Messages By This Member
Sieghard Weitzel <sieghard@...> #44997 Good thing you mentioned this because Alt+Shift+L doesn't do anything in Excel 2016. toggle quoted message Show quoted text -----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@...
More All Messages By This Member
Dave... #44998 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 toggle quoted message Show quoted text ----- 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@...
More All Messages By This Member
Soronel Haetir #45004 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. toggle quoted message Show quoted text 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@...
More All Messages By This Member
Dave... #45005 Just have one of those cells in focus, like always. Perhaps "positioned on one of the column headers" would have stated it better? Dave Oregonian, woodworker, Engineer, Musician, and Pioneer toggle quoted message Show quoted text ----- Original Message ----- From: "Soronel Haetir" <soronel.haetir@...> To: <main@jfw.groups.io> Sent: Tuesday, January 17, 2017 10:44 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@...
More All Messages By This Member
Sieghard Weitzel <sieghard@...> #45020 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. toggle quoted message Show quoted text -----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@...
More All Messages By This Member
Dave... #45021 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 toggle quoted message Show quoted text ----- 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@...
More All Messages By This Member
Ann Byrne #45022 shift+f11 creates a sheet. toggle quoted message Show quoted text 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@...
More All Messages By This Member
Sieghard Weitzel <sieghard@...> #45023 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 toggle quoted message Show quoted text -----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@...> 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@...
More All Messages By This Member
Joseph Weakland #45025 wow didn't know about the shftf11 command thanks:) toggle quoted message Show quoted text ----- Original Message ----- From: "Ann Byrne" <annakb@...> 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@...> 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@...
More All Messages By This Member
Palmer Loux <Plmrlx@...> #45028 Thanks will try! Sent from my iPhone toggle quoted message Show quoted text On Jan 17, 2017, at 11:01 AM, "Dave Carlson" <dgcarlson@...> 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@...> 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@...
More All Messages By This Member
Dave... #45035 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 toggle quoted message Show quoted text ----- 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@...
More All Messages By This Member
Sieghard Weitzel <sieghard@...> #45038 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 toggle quoted message Show quoted text -----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@...
More All Messages By This Member
Dave... #45044 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 toggle quoted message Show quoted text ----- 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@...
More All Messages By This Member
Sieghard Weitzel <sieghard@...> #45045 Thanks, Dave, that is exactly the sort of thing I was looking for, now I like Excel 2016 a lot more than before. toggle quoted message Show quoted text -----Original Message----- From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Dave Carlson Sent: Tuesday, January 17, 2017 8:38 PM 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@...
More All Messages By This Member
jeff armstrong <jeffarmstrong1380@...> #45046 Hello; Sorry I'm coming into this late but I use lists a lot and so long as I am just re-sorting the same list I did last time, Once I highlight the list and make sure that I include the column headings, I just use (Alt+D, followed by s) which is the old data-sort shortcut and then just hit enter Jeff Armstrong NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You. toggle quoted message Show quoted text -----Original Message----- From: Sieghard Weitzel Sent: Tuesday, January 17, 2017 7:58 PM To: main@jfw.groups.io 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@...
More All Messages By This Member
Pablo Morales #45049 Sieghard There are easier ways to do that. To do all those tasks just press Insert+shift+s, then press R, to rename a sheet D, to delete a sheet M, to move a shit I, to insert a sheet Easy toggle quoted message Show quoted text -----Original Message----- From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Sieghard Weitzel Sent: Tuesday, January 17, 2017 8:58 PM To: main@jfw.groups.io 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@...
More All Messages By This Member