Making a note in excel
|
brian albriton
Excel not only has data but occasionally one needs to make a note about the data. How would I do this in excel?
Brian Albriton iPhone 2136103315 cocanut50@...
|
|
|
|
Dave...
Brian,
You can add comments to cells. When on a cell, press the
Application key or Shift+F10 and select insert comment from the context
menu.
Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer
----- Original Message -----
From: brian albriton
Sent: Saturday, January 20, 2018 09:36
Subject: Making a note in excel Excel not only has data but occasionally one needs to make a note about the data. How would I do this in excel?
Brian Albriton iPhone 2136103315
|
|
|
|
Richard Turner <richardturner42@...>
Hi Brian,
Dave’s write, if you use the application key you can arrow to insert comment and hit enter. Type your comment and hit enter. Then, I believe you can tab to the next cell or arrow down, etc. To bring up a list of cells with comments, its control+shift+apostrophe.
I do not know if there is a setting to have Jaws automatically read the comments.
HTH, Richard
From: main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of brian albriton
Sent: Saturday, January 20, 2018 9:36 AM To: main@jfw.groups.io Subject: Making a note in excel
Excel not only has data but occasionally one needs to make a note about the data. How would I do this in excel?
Brian Albriton iPhone 2136103315
|
|
|
|
Sieghard Weitzel <sieghard@...>
Hi Dave and Richard,
This is useful although if I go to Insert Comment and type something pressing enter doesn’t do anything and neither does tab, I have to press escape first before I can navigate to a different cell, then if I go back it will say the cell content along with “includes comment. The Control+Shift+Apostrophy also works great, but it would be really nice if Jaws could be made to speak the comment after the cell content, e.g. it would say “2” or whatever value is in the cell and then “Comment: Number of items in stock” or something along those lines. This would allow you to still perform calculations including the value of that cell but to have some more useful information, e.g. I could have the names of products in column A and across the top I could have sizes and maybe for this particular order some sizes are “In Stock” and some are “Backordered”. I have received Excel sheets where the person who made that sheet colour coded this and then provided a legend as to what colour means what, but it would be nice to be able to add a comment which Jaws then reads automatically instead of having to check the colour of the cell content. I wouldn’t be surprised if this is possible, if anybody knows maybe they can share it. If indeed it is not possible then I think FS should add this functionality.
Regards, Sieghard
From: main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Richard Turner
Sent: Saturday, January 20, 2018 10:05 AM To: main@jfw.groups.io Subject: Re: Making a note in excel
Hi Brian,
Dave’s write, if you use the application key you can arrow to insert comment and hit enter. Type your comment and hit enter. Then, I believe you can tab to the next cell or arrow down, etc. To bring up a list of cells with comments, its control+shift+apostrophe.
I do not know if there is a setting to have Jaws automatically read the comments.
HTH, Richard
From: main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of brian albriton
Excel not only has data but occasionally one needs to make a note about the data. How would I do this in excel?
Brian Albriton iPhone 2136103315
|
|
|
|
Michal Nowicki
Hi Guys,
The reason Tab and Enter do not get you back into the spreadsheet is that in Office applications, comments, like headers and footers (including page numbers), appear in a separate pane.
As far as I know, there is no way to get JAWS to read comments automatically in Excel. Since there are ways to do this in Word, I find this surprising.
Michal
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Sieghard Weitzel
Sent: Saturday, January 20, 2018 3:22 PM To: main@jfw.groups.io Subject: Re: Making a note in excel
Hi Dave and Richard,
This is useful although if I go to Insert Comment and type something pressing enter doesn’t do anything and neither does tab, I have to press escape first before I can navigate to a different cell, then if I go back it will say the cell content along with “includes comment. The Control+Shift+Apostrophy also works great, but it would be really nice if Jaws could be made to speak the comment after the cell content, e.g. it would say “2” or whatever value is in the cell and then “Comment: Number of items in stock” or something along those lines. This would allow you to still perform calculations including the value of that cell but to have some more useful information, e.g. I could have the names of products in column A and across the top I could have sizes and maybe for this particular order some sizes are “In Stock” and some are “Backordered”. I have received Excel sheets where the person who made that sheet colour coded this and then provided a legend as to what colour means what, but it would be nice to be able to add a comment which Jaws then reads automatically instead of having to check the colour of the cell content. I wouldn’t be surprised if this is possible, if anybody knows maybe they can share it. If indeed it is not possible then I think FS should add this functionality.
Regards, Sieghard
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Richard Turner
Hi Brian,
Dave’s write, if you use the application key you can arrow to insert comment and hit enter. Type your comment and hit enter. Then, I believe you can tab to the next cell or arrow down, etc. To bring up a list of cells with comments, its control+shift+apostrophe.
I do not know if there is a setting to have Jaws automatically read the comments.
HTH, Richard
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of brian albriton
Excel not only has data but occasionally one needs to make a note about the data. How would I do this in excel?
Brian Albriton iPhone 2136103315
|
|
|
|
Dave...
I'm thinking that comments can be made to speak, but
perhaps they need to be enabled in the Excel options?
Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer
----- Original Message -----
From: Sieghard Weitzel
Sent: Saturday, January 20, 2018 13:21
Subject: Re: Making a note in excel Hi Dave and Richard,
This is useful although if I go to Insert Comment and type something pressing enter doesn’t do anything and neither does tab, I have to press escape first before I can navigate to a different cell, then if I go back it will say the cell content along with “includes comment. The Control+Shift+Apostrophy also works great, but it would be really nice if Jaws could be made to speak the comment after the cell content, e.g. it would say “2” or whatever value is in the cell and then “Comment: Number of items in stock” or something along those lines. This would allow you to still perform calculations including the value of that cell but to have some more useful information, e.g. I could have the names of products in column A and across the top I could have sizes and maybe for this particular order some sizes are “In Stock” and some are “Backordered”. I have received Excel sheets where the person who made that sheet colour coded this and then provided a legend as to what colour means what, but it would be nice to be able to add a comment which Jaws then reads automatically instead of having to check the colour of the cell content. I wouldn’t be surprised if this is possible, if anybody knows maybe they can share it. If indeed it is not possible then I think FS should add this functionality.
Regards, Sieghard
From: main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Richard Turner
Hi Brian,
Dave’s write, if you use the application key you can arrow to insert comment and hit enter. Type your comment and hit enter. Then, I believe you can tab to the next cell or arrow down, etc. To bring up a list of cells with comments, its control+shift+apostrophe.
I do not know if there is a setting to have Jaws automatically read the comments.
HTH, Richard
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
brian albriton
Excel not only has data but occasionally one needs to make a note about the data. How would I do this in excel?
Brian Albriton iPhone 2136103315
|
|
|
|
Howard Traxler <howard@...>
Does the comment then exist along wigth the numeric
datum or formula? Does it have any effect on the processing of the
datum?
Howard
|
|
|
|
Dave...
Yes, it does, and no it does not affect any of the formula
or processing.
Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer
----- Original Message -----
From: Howard Traxler
Sent: Saturday, January 20, 2018 20:32
Subject: Re: Making a note in excel Does the comment then exist along wigth the numeric
datum or formula? Does it have any effect on the processing of the
datum?
Howard
|
|
|
|
Kevin Hourigan <kevinthourigan@...>
To the sighted I think it just shows a little red triangle to click on to read it, and has no affect on the workings of the spread sheet.
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Howard Traxler
Sent: January 20, 2018 8:32 PM To: main@jfw.groups.io Subject: Re: Making a note in excel
Does the comment then exist along wigth the numeric datum or formula? Does it have any effect on the processing of the datum? Howard
|
|
|
|
Richard B. McDonald
the below is correct, and also if the mouse is hovered over that little red indication a tooltip pops up displaying the contents of the note to a sighted user.
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Kevin Hourigan
Sent: Sunday, January 21, 2018 8:27 AM To: main@jfw.groups.io Subject: Re: Making a note in excel
To the sighted I think it just shows a little red triangle to click on to read it, and has no affect on the workings of the spread sheet.
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Howard Traxler
Does the comment then exist along wigth the numeric datum or formula? Does it have any effect on the processing of the datum? Howard
|
|
|
|
Richard B. McDonald
No, that is not an *Excel* option. There is, I think, a *JAWS* option to have a cell's note (if any) read along with its value and coordinates.
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Dave...
Sent: Saturday, January 20, 2018 5:23 PM To: main@jfw.groups.io Subject: Re: Making a note in excel
I'm thinking that comments can be made to speak, but perhaps they need to be enabled in the Excel options?
Dave
----- Original Message ----- From: Sieghard Weitzel Sent: Saturday, January 20, 2018 13:21 Subject: Re: Making a note in excel
Hi Dave and Richard,
This is useful although if I go to Insert Comment and type something pressing enter doesn’t do anything and neither does tab, I have to press escape first before I can navigate to a different cell, then if I go back it will say the cell content along with “includes comment. The Control+Shift+Apostrophy also works great, but it would be really nice if Jaws could be made to speak the comment after the cell content, e.g. it would say “2” or whatever value is in the cell and then “Comment: Number of items in stock” or something along those lines. This would allow you to still perform calculations including the value of that cell but to have some more useful information, e.g. I could have the names of products in column A and across the top I could have sizes and maybe for this particular order some sizes are “In Stock” and some are “Backordered”. I have received Excel sheets where the person who made that sheet colour coded this and then provided a legend as to what colour means what, but it would be nice to be able to add a comment which Jaws then reads automatically instead of having to check the colour of the cell content. I wouldn’t be surprised if this is possible, if anybody knows maybe they can share it. If indeed it is not possible then I think FS should add this functionality.
Regards, Sieghard
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Richard Turner
Hi Brian,
Dave’s write, if you use the application key you can arrow to insert comment and hit enter. Type your comment and hit enter. Then, I believe you can tab to the next cell or arrow down, etc. To bring up a list of cells with comments, its control+shift+apostrophe.
I do not know if there is a setting to have Jaws automatically read the comments.
HTH, Richard
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of brian albriton
Excel not only has data but occasionally one needs to make a note about the data. How would I do this in excel?
Brian Albriton iPhone 2136103315
|
|
|
|
Mario
I see an alt+shift+Apostrophe to make JAWS read a cell comment, but no
toggle quoted messageShow quoted text
keystroke to have JAWS do what you suggest. when you hear that a cell has a comment, alt+shift+apostrophe should read the comment.
-------- Original Message --------
From: Richard B. McDonald [mailto:richardbmcdonald@gmail.com] Sent: Sunday, Jan 21, 2018 3:48 PM EST To: main@jfw.groups.io Subject: Making a note in excel No, that is not an *Excel* option. There is, I think, a *JAWS* option to have a cell's note (if any) read along with its value and coordinates. *From:*main@jfw.groups.io [mailto:main@jfw.groups.io] *On Behalf Of *Dave... *Sent:* Saturday, January 20, 2018 5:23 PM *To:* main@jfw.groups.io *Subject:* Re: Making a note in excel I'm thinking that comments can be made to speak, but perhaps they need to be enabled in the Excel options? Dave Oregonian, woodworker, Engineer, Musician, and Pioneer ----- Original Message ----- *From:*Sieghard Weitzel <mailto:sieghard@live.ca> *To:*main@jfw.groups.io <mailto:main@jfw.groups.io> *Sent:*Saturday, January 20, 2018 13:21 *Subject:*Re: Making a note in excel Hi Dave and Richard, This is useful although if I go to Insert Comment and type something pressing enter doesn’t do anything and neither does tab, I have to press escape first before I can navigate to a different cell, then if I go back it will say the cell content along with “includes comment. The Control+Shift+Apostrophy also works great, but it would be really nice if Jaws could be made to speak the comment after the cell content, e.g. it would say “2” or whatever value is in the cell and then “Comment: Number of items in stock” or something along those lines. This would allow you to still perform calculations including the value of that cell but to have some more useful information, e.g. I could have the names of products in column A and across the top I could have sizes and maybe for this particular order some sizes are “In Stock” and some are “Backordered”. I have received Excel sheets where the person who made that sheet colour coded this and then provided a legend as to what colour means what, but it would be nice to be able to add a comment which Jaws then reads automatically instead of having to check the colour of the cell content. I wouldn’t be surprised if this is possible, if anybody knows maybe they can share it. If indeed it is not possible then I think FS should add this functionality. ** *Regards,* *Sieghard* ** *From:* main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner *Sent:* Saturday, January 20, 2018 10:05 AM *To:* main@jfw.groups.io <mailto:main@jfw.groups.io> *Subject:* Re: Making a note in excel Hi Brian, Dave’s write, if you use the application key you can arrow to insert comment and hit enter. Type your comment and hit enter. Then, I believe you can tab to the next cell or arrow down, etc. To bring up a list of cells with comments, its control+shift+apostrophe. I do not know if there is a setting to have Jaws automatically read the comments. HTH, Richard *From:* main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *brian albriton *Sent:* Saturday, January 20, 2018 9:36 AM *To:* main@jfw.groups.io <mailto:main@jfw.groups.io> *Subject:* Making a note in excel Excel not only has data but occasionally one needs to make a note about the data. How would I do this in excel? Brian Albriton iPhone 2136103315 cocanut50@carr.com <mailto:cocanut50@ca.rr.com>
|
|
|
|
Sieghard Weitzel <sieghard@...>
Fair enough, but if there is no way for Jaws to speak this information automatically when you move to a cell with a comment, there should definitely be a keystroke to make Jaws speak it.
From: main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Richard B. McDonald
Sent: Sunday, January 21, 2018 12:46 PM To: main@jfw.groups.io Subject: Re: Making a note in excel
the below is correct, and also if the mouse is hovered over that little red indication a tooltip pops up displaying the contents of the note to a sighted user.
From:
main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Kevin Hourigan
To the sighted I think it just shows a little red triangle to click on to read it, and has no affect on the workings of the spread sheet.
From:
main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Howard Traxler
Does the comment then exist along wigth the numeric datum or formula? Does it have any effect on the processing of the datum? Howard
|
|
|
|
Sieghard Weitzel <sieghard@...>
Hi Mario,
toggle quoted messageShow quoted text
Thanks, that does work, however, it reads my name each time before it reads the comment. I guess that is because I am the author of the comment. I'll have to get in touch with Jaws and ask them to fix this or to add a setting where this can be turned on or off. I can see how in a company where multiple people edit an Excel sheet this is useful, but I just want to hear the comment and I'm sure for most private users or those like me who have a small business would prefer just to hear the comment and nothing else.
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario Sent: Sunday, January 21, 2018 1:39 PM To: main@jfw.groups.io Subject: Re: Making a note in excel I see an alt+shift+Apostrophe to make JAWS read a cell comment, but no keystroke to have JAWS do what you suggest. when you hear that a cell has a comment, alt+shift+apostrophe should read the comment. -------- Original Message -------- From: Richard B. McDonald [mailto:richardbmcdonald@gmail.com] Sent: Sunday, Jan 21, 2018 3:48 PM EST To: main@jfw.groups.io Subject: Making a note in excel No, that is not an *Excel* option. There is, I think, a *JAWS* option to have a cell's note (if any) read along with its value and coordinates. *From:*main@jfw.groups.io [mailto:main@jfw.groups.io] *On Behalf Of *Dave... *Sent:* Saturday, January 20, 2018 5:23 PM *To:* main@jfw.groups.io *Subject:* Re: Making a note in excel I'm thinking that comments can be made to speak, but perhaps they need to be enabled in the Excel options? Dave Oregonian, woodworker, Engineer, Musician, and Pioneer ----- Original Message ----- *From:*Sieghard Weitzel <mailto:sieghard@live.ca> *To:*main@jfw.groups.io <mailto:main@jfw.groups.io> *Sent:*Saturday, January 20, 2018 13:21 *Subject:*Re: Making a note in excel Hi Dave and Richard, This is useful although if I go to Insert Comment and type something pressing enter doesn't do anything and neither does tab, I have to press escape first before I can navigate to a different cell, then if I go back it will say the cell content along with "includes comment. The Control+Shift+Apostrophy also works great, but it would be really nice if Jaws could be made to speak the comment after the cell content, e.g. it would say "2" or whatever value is in the cell and then "Comment: Number of items in stock" or something along those lines. This would allow you to still perform calculations including the value of that cell but to have some more useful information, e.g. I could have the names of products in column A and across the top I could have sizes and maybe for this particular order some sizes are "In Stock" and some are "Backordered". I have received Excel sheets where the person who made that sheet colour coded this and then provided a legend as to what colour means what, but it would be nice to be able to add a comment which Jaws then reads automatically instead of having to check the colour of the cell content. I wouldn't be surprised if this is possible, if anybody knows maybe they can share it. If indeed it is not possible then I think FS should add this functionality. ** *Regards,* *Sieghard* ** *From:* main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner *Sent:* Saturday, January 20, 2018 10:05 AM *To:* main@jfw.groups.io <mailto:main@jfw.groups.io> *Subject:* Re: Making a note in excel Hi Brian, Dave's write, if you use the application key you can arrow to insert comment and hit enter. Type your comment and hit enter. Then, I believe you can tab to the next cell or arrow down, etc. To bring up a list of cells with comments, its control+shift+apostrophe. I do not know if there is a setting to have Jaws automatically read the comments. HTH, Richard *From:* main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *brian albriton *Sent:* Saturday, January 20, 2018 9:36 AM *To:* main@jfw.groups.io <mailto:main@jfw.groups.io> *Subject:* Making a note in excel Excel not only has data but occasionally one needs to make a note about the data. How would I do this in excel? Brian Albriton iPhone 2136103315 cocanut50@carr.com <mailto:cocanut50@ca.rr.com>
|
|
|
|
Dave...
Sieghard,
toggle quoted messageShow quoted text
Here's a suggestion for eliminating the speaking of your name along with comments... In Excel you designate your name or initials to be used in such comments or giving creation credit. I think it's in the Options/General. Instead of your name or initials, use some other variant of your name that you recognize, but don't use anywhere else. Then try putting that variant into the dictionary manager for Excel and other Office applications to speak nothing. Let me know if that works. Dave Oregonian, woodworker, Engineer, Musician, and Pioneer
----- Original Message -----
From: "Sieghard Weitzel" <sieghard@live.ca> To: <main@jfw.groups.io> Sent: Monday, January 22, 2018 08:27 Subject: Re: Making a note in excel Hi Mario, Thanks, that does work, however, it reads my name each time before it reads the comment. I guess that is because I am the author of the comment. I'll have to get in touch with Jaws and ask them to fix this or to add a setting where this can be turned on or off. I can see how in a company where multiple people edit an Excel sheet this is useful, but I just want to hear the comment and I'm sure for most private users or those like me who have a small business would prefer just to hear the comment and nothing else. -----Original Message----- From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario Sent: Sunday, January 21, 2018 1:39 PM To: main@jfw.groups.io Subject: Re: Making a note in excel I see an alt+shift+Apostrophe to make JAWS read a cell comment, but no keystroke to have JAWS do what you suggest. when you hear that a cell has a comment, alt+shift+apostrophe should read the comment. -------- Original Message -------- From: Richard B. McDonald [mailto:richardbmcdonald@gmail.com] Sent: Sunday, Jan 21, 2018 3:48 PM EST To: main@jfw.groups.io Subject: Making a note in excel No, that is not an *Excel* option. There is, I think, a *JAWS* option to have a cell's note (if any) read along with its value and coordinates. *From:*main@jfw.groups.io [mailto:main@jfw.groups.io] *On Behalf Of *Dave.. *Sent:* Saturday, January 20, 2018 5:23 PM *To:* main@jfw.groups.io *Subject:* Re: Making a note in excel I'm thinking that comments can be made to speak, but perhaps they need to be enabled in the Excel options? Dave Oregonian, woodworker, Engineer, Musician, and Pioneer ----- Original Message ----- *From:*Sieghard Weitzel <mailto:sieghard@live.ca> *To:*main@jfw.groups.io <mailto:main@jfw.groups.io> *Sent:*Saturday, January 20, 2018 13:21 *Subject:*Re: Making a note in excel Hi Dave and Richard, This is useful although if I go to Insert Comment and type something pressing enter doesn't do anything and neither does tab, I have to press escape first before I can navigate to a different cell, then if I go back it will say the cell content along with "includes comment. The Control+Shift+Apostrophy also works great, but it would be really nice if Jaws could be made to speak the comment after the cell content, e.g. it would say "2" or whatever value is in the cell and then "Comment: Number of items in stock" or something along those lines. This would allow you to still perform calculations including the value of that cell but to have some more useful information, e.g. I could have the names of products in column A and across the top I could have sizes and maybe for this particular order some sizes are "In Stock" and some are "Backordered". I have received Excel sheets where the person who made that sheet colour coded this and then provided a legend as to what colour means what, but it would be nice to be able to add a comment which Jaws then reads automatically instead of having to check the colour of the cell content. I wouldn't be surprised if this is possible, if anybody knows maybe they can share it. If indeed it is not possible then I think FS should add this functionality. ** *Regards,* *Sieghard* ** *From:* main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner *Sent:* Saturday, January 20, 2018 10:05 AM *To:* main@jfw.groups.io <mailto:main@jfw.groups.io> *Subject:* Re: Making a note in excel Hi Brian, Dave's write, if you use the application key you can arrow to insert comment and hit enter. Type your comment and hit enter. Then, I believe you can tab to the next cell or arrow down, etc. To bring up a list of cells with comments, its control+shift+apostrophe. I do not know if there is a setting to have Jaws automatically read the comments. HTH, Richard *From:* main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *brian albriton *Sent:* Saturday, January 20, 2018 9:36 AM *To:* main@jfw.groups.io <mailto:main@jfw.groups.io> *Subject:* Making a note in excel Excel not only has data but occasionally one needs to make a note about the data. How would I do this in excel? Brian Albriton iPhone 2136103315 cocanut50@carr.com <mailto:cocanut50@ca.rr.com>
|
|
|
|
Steve Griffiths
Or you can just delete the name from the comment - when you select to Insert a comment, you're at the start of the line where the comment will go and your name is on the line above; press Backspace to delete it letter by letter. Thanks, Steve 🐾
-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Dave... Sent: 22 January 2018 16:43 To: main@jfw.groups.io Subject: Re: Making a note in excel Sieghard, Here's a suggestion for eliminating the speaking of your name along with comments... In Excel you designate your name or initials to be used in such comments or giving creation credit. I think it's in the Options/General. Instead of your name or initials, use some other variant of your name that you recognize, but don't use anywhere else. Then try putting that variant into the dictionary manager for Excel and other Office applications to speak nothing. Let me know if that works. Dave Oregonian, woodworker, Engineer, Musician, and Pioneer ----- Original Message ----- From: "Sieghard Weitzel" <sieghard@...> To: <main@jfw.groups.io> Sent: Monday, January 22, 2018 08:27 Subject: Re: Making a note in excel Hi Mario, Thanks, that does work, however, it reads my name each time before it reads the comment. I guess that is because I am the author of the comment. I'll have to get in touch with Jaws and ask them to fix this or to add a setting where this can be turned on or off. I can see how in a company where multiple people edit an Excel sheet this is useful, but I just want to hear the comment and I'm sure for most private users or those like me who have a small business would prefer just to hear the comment and nothing else. -----Original Message----- From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario Sent: Sunday, January 21, 2018 1:39 PM To: main@jfw.groups.io Subject: Re: Making a note in excel I see an alt+shift+Apostrophe to make JAWS read a cell comment, but no keystroke to have JAWS do what you suggest. when you hear that a cell has a comment, alt+shift+apostrophe should read the comment. -------- Original Message -------- From: Richard B. McDonald [mailto:richardbmcdonald@...] Sent: Sunday, Jan 21, 2018 3:48 PM EST To: main@jfw.groups.io Subject: Making a note in excel No, that is not an *Excel* option. There is, I think, a *JAWS* option to have a cell's note (if any) read along with its value and coordinates. *From:*main@jfw.groups.io [mailto:main@jfw.groups.io] *On Behalf Of *Dave.. *Sent:* Saturday, January 20, 2018 5:23 PM *To:* main@jfw.groups.io *Subject:* Re: Making a note in excel I'm thinking that comments can be made to speak, but perhaps they need to be enabled in the Excel options? Dave Oregonian, woodworker, Engineer, Musician, and Pioneer ----- Original Message ----- *From:*Sieghard Weitzel <mailto:sieghard@...> *To:*main@jfw.groups.io <mailto:main@jfw.groups.io> *Sent:*Saturday, January 20, 2018 13:21 *Subject:*Re: Making a note in excel Hi Dave and Richard, This is useful although if I go to Insert Comment and type something pressing enter doesn't do anything and neither does tab, I have to press escape first before I can navigate to a different cell, then if I go back it will say the cell content along with "includes comment. The Control+Shift+Apostrophy also works great, but it would be really nice if Jaws could be made to speak the comment after the cell content, e.g. it would say "2" or whatever value is in the cell and then "Comment: Number of items in stock" or something along those lines. This would allow you to still perform calculations including the value of that cell but to have some more useful information, e.g. I could have the names of products in column A and across the top I could have sizes and maybe for this particular order some sizes are "In Stock" and some are "Backordered". I have received Excel sheets where the person who made that sheet colour coded this and then provided a legend as to what colour means what, but it would be nice to be able to add a comment which Jaws then reads automatically instead of having to check the colour of the cell content. I wouldn't be surprised if this is possible, if anybody knows maybe they can share it. If indeed it is not possible then I think FS should add this functionality. ** *Regards,* *Sieghard* ** *From:* main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *Richard Turner *Sent:* Saturday, January 20, 2018 10:05 AM *To:* main@jfw.groups.io <mailto:main@jfw.groups.io> *Subject:* Re: Making a note in excel Hi Brian, Dave's write, if you use the application key you can arrow to insert comment and hit enter. Type your comment and hit enter. Then, I believe you can tab to the next cell or arrow down, etc. To bring up a list of cells with comments, its control+shift+apostrophe. I do not know if there is a setting to have Jaws automatically read the comments. HTH, Richard *From:* main@jfw.groups.io <mailto:main@jfw.groups.io> [mailto:main@jfw.groups.io] *On Behalf Of *brian albriton *Sent:* Saturday, January 20, 2018 9:36 AM *To:* main@jfw.groups.io <mailto:main@jfw.groups.io> *Subject:* Making a note in excel Excel not only has data but occasionally one needs to make a note about the data. How would I do this in excel? Brian Albriton iPhone 2136103315 cocanut50@... <mailto:cocanut50@...> This email and any attachment to it are confidential. Unless you are the intended recipient, you may not use, copy or disclose either the message or any information contained in the message. If you are not the intended recipient, you should delete this email and notify the sender immediately. Any views or opinions expressed in this email are those of the sender only, unless otherwise stated. All emails, incoming and outgoing, may be recorded by Guide Dogs and monitored for legitimate business purposes. Guide Dogs exclude all liability for any loss or damage arising or resulting from the receipt, use or transmission of this email to the fullest extent permitted by law. The Guide Dogs for the Blind Association Tel: 0118 983 5555 Email: guidedogs@... Website: https://www.guidedogs.org.uk Registered Office: Hillfields, Burghfield Common, Reading, Berkshire, RG7 3YG. A company limited by guarantee, registered in England and Wales (291646) and a charity registered in England and Wales (209617) and Scotland (SC038979).
|
|
|
|
Sieghard Weitzel <sieghard@...>
Hi Steve,
Perfect, that works, would be nice if Jaws actually read what’s in there, still something for FS to look at and hopefully fix.
From: main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Steve Griffiths
Sent: Monday, January 22, 2018 8:48 AM To: main@jfw.groups.io Subject: Re: Making a note in excel
|
|
|
|
Kevin Hourigan <kevinthourigan@...>
Greetings, When Jaws moves to a cell with a comment it announces the fact, and alt, shift apostrophe will read said comment. Please find some other keystrokes regarding comments below. CommentsAdd a comment alt, R, C, enter text, press escape Delete a comment Alt R D Edit a comment Alt R T Or shift F 2 List comments Control shift apostrophe Read a comment alt shift apostrophe
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Sieghard Weitzel
Sent: January 22, 2018 7:58 AM To: main@jfw.groups.io Subject: Re: Making a note in excel
Fair enough, but if there is no way for Jaws to speak this information automatically when you move to a cell with a comment, there should definitely be a keystroke to make Jaws speak it.
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Richard B. McDonald
the below is correct, and also if the mouse is hovered over that little red indication a tooltip pops up displaying the contents of the note to a sighted user.
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Kevin Hourigan
To the sighted I think it just shows a little red triangle to click on to read it, and has no affect on the workings of the spread sheet.
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Howard Traxler
Does the comment then exist along wigth the numeric datum or formula? Does it have any effect on the processing of the datum? Howard
|
|
|
|
Dave...
Also, Shift+F2 will allow adding a comment, as well as
editing. And of course application key (shift+f10) will open a context menu to
add/delete comments.
Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer
----- Original Message -----
From: Kevin
Hourigan
Sent: Monday, January 22, 2018 09:38
Subject: Re: Making a note in excel Greetings, When Jaws moves to a cell with a comment it announces the fact, and alt, shift apostrophe will read said comment. Please find some other keystrokes regarding comments below. CommentsAdd a comment alt, R, C, enter text, press escape Delete a comment Alt R D Edit a comment Alt R T Or shift F 2 List comments Control shift apostrophe Read a comment alt shift apostrophe
From:
main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Sieghard
Weitzel
Fair enough, but if there is no way for Jaws to speak this information automatically when you move to a cell with a comment, there should definitely be a keystroke to make Jaws speak it.
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Richard B. McDonald
the below is correct, and also if the mouse is hovered over that little red indication a tooltip pops up displaying the contents of the note to a sighted user.
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Kevin Hourigan
To the sighted I think it just shows a little red triangle to click on to read it, and has no affect on the workings of the spread sheet.
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of
Howard Traxler
Does the comment then exist along wigth the numeric datum or formula? Does it have any effect on the processing of the datum? Howard
|
|
|
|
Sieghard Weitzel <sieghard@...>
Another even easier way to add a comment since Shift+F2 for me at least is easier than Alt+r then C. Interestingly enough I just tested this at work where I still use Windows 7, Jaws and Office are the same as on my Windows 10 laptop, and here Jaws reads the comment I type just fine, I can up arrow and it reads the line with my name and if I press enter it actually exits the comments screen and puts me back on the cell where I was, e.g. if I put something in A1, then add a comment and press enter I’m back on A1. I will definitely have to submit something to FS about Jaws not reading the comments under Windows 10.
Regards, Sieghard
From: main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Dave...
Sent: Monday, January 22, 2018 10:01 AM To: main@jfw.groups.io Subject: Re: Making a note in excel
Also, Shift+F2 will allow adding a comment, as well as editing. And of course application key (shift+f10) will open a context menu to add/delete comments.
Dave
----- Original Message ----- From: Kevin Hourigan Sent: Monday, January 22, 2018 09:38 Subject: Re: Making a note in excel
Greetings, When Jaws moves to a cell with a comment it announces the fact, and alt, shift apostrophe will read said comment. Please find some other keystrokes regarding comments below. CommentsAdd a comment alt, R, C, enter text, press escape Delete a comment Alt R D Edit a comment Alt R T Or shift F 2 List comments Control shift apostrophe Read a comment alt shift apostrophe
From: main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Sieghard Weitzel
Fair enough, but if there is no way for Jaws to speak this information automatically when you move to a cell with a comment, there should definitely be a keystroke to make Jaws speak it.
From: main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Richard B. McDonald
the below is correct, and also if the mouse is hovered over that little red indication a tooltip pops up displaying the contents of the note to a sighted user.
From:
main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Kevin Hourigan
To the sighted I think it just shows a little red triangle to click on to read it, and has no affect on the workings of the spread sheet.
From:
main@jfw.groups.io [mailto:main@jfw.groups.io]
On Behalf Of Howard Traxler
Does the comment then exist along wigth the numeric datum or formula? Does it have any effect on the processing of the datum? Howard
|
|
|