[JAWS-Users] problem with Excel 2010
I need to print out an Excel sheet each month, the same sheet with monthly additions. I am having a problem getting all of the cells printed without printing out everything. Example, I needed A through I to print, but I either had to print the entire spreadsheet or it only printed cells A through F. How can I select the cells I want to print? I am using both JAWS 2018 and JAWS 14. Thanks. Vicki For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] problem with excel
Hello, I have just resolved an issue where JAWS was not reading the contents of a cell. I am using Windows 7, Excel 2010 and the latest version of JAWS 16. In my spreadsheet, column C and D contain dollar amounts. When I was moving left to column C, JAWS was reading the cell contents correctly. When I moved over to column D, JAWS was saying blank. I checked all of my JAWS settings, which are correct. now, what the hell is JAWS doing wrong this time?, said I. I finally asked my wife what was going on. She reported that the values of column D were showing in the formula bar at the top of the spreadsheet. But, because the width of column D was 1 character, nothing was showing in the cell. I selected the entire column and AutoFit it. hey, it works!. And, no, I have no idea how I got column D to be just 1 character wide. So, it isn't always JAWS that is screwing up. However, I am having another problem with JAWS 16 and Excel 2010 which I may write about in another post. Reed -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Brian Lee Sent: February-11-15 7:55 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Hello Dwight, To change the format of a cell to a number without a decimal point you can use CTRL+Shift+Tilde. You might need to use the JAWS pass through command first, which is the JAWS key with the number 3. (Use the number three that is above the E and not the one on the number pad). Try it without the pass through first but my system must be using that keystroke for something else and I need to use the pass through command. To change the format of a cell to a number format that uses two decimal places, a thousand separator and a minus sign when applicable use CTRL+Shift+! (that is the control key with the shift key and the number 1) If you need to select a range to apply the formatting to then you can use CTRL+G and type in the first and last cell to be included in the range separated by a colon. For example, A7:g12 will select cells starting with a7 and ending with g12 once you press the enter key. You can then use the keystroke to apply the number format you want. If you want a different numbering format then use CTRL+1 and use the formatting dialog box to make your change. Take care. Brian Lee brianl...@charter.net -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Dwight Johnson Sent: Wednesday, February 11, 2015 6:38 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Using excel 2007, windows 8.1 and jaws 14 this began on Monday. I put a value such as 200 in a cell but jaws says 4 jan or some other date bbut the total at bottom of the column is correct. -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of John Justice Sent: Tuesday, February 10, 2015 9:51 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Jaws can be set to read the cells in many ways. There are specific settings in the Quick Settings section. 1. While focused on Excel, press INSERT+V to open the Quick Settings dialog. 2. Arrow down to the beginning of the texdt or use the Search window and type something like read cell contents. 3. The easiest way is to press the letter T twice. That takes you to a setting indicating that Jaws should read the cell contents. 4. Now use first letter navigation C, pressed twice. 5. You will be in the settings for cells. Here's the great part of Quick Settings. If you aren't sure, just highlight a setting, then tab over and there will be a text box explaining what each setting does. The text explanations change, depending on which parameter you have highlighted currently. Before doing anything, look through these. 6. You can try a change, make a note of it and then if you don't like the results, open up Quick Settings again and try another setting. Excel settings for Jaws are quite extensive. I suggest you figure out what you want to do and then try to find the setting that makes Jaws do that. Reading cell contents is one of those settings. You can also have Jaws read the column or row settings in Excel but that's for another message. JOHN AND LINDA JUSTICE PERSONAL E-MAIL: john_just...@verizon.net -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Mike Boyd Sent: Tuesday, February 10, 2015 1:41 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Could you please elaborate a little on Excel does not read the cells properly if at all? If JAWS does read something, what does it say? It could be that the excel window needs to be maximized is all. Mike blindb...@comcast.net -Original Message- From: Flor Lynch Sent
Re: [JAWS-Users] problem with excel
Thanks so much. -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Brian Lee Sent: Wednesday, February 11, 2015 9:55 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Hello Dwight, To change the format of a cell to a number without a decimal point you can use CTRL+Shift+Tilde. You might need to use the JAWS pass through command first, which is the JAWS key with the number 3. (Use the number three that is above the E and not the one on the number pad). Try it without the pass through first but my system must be using that keystroke for something else and I need to use the pass through command. To change the format of a cell to a number format that uses two decimal places, a thousand separator and a minus sign when applicable use CTRL+Shift+! (that is the control key with the shift key and the number 1) If you need to select a range to apply the formatting to then you can use CTRL+G and type in the first and last cell to be included in the range separated by a colon. For example, A7:g12 will select cells starting with a7 and ending with g12 once you press the enter key. You can then use the keystroke to apply the number format you want. If you want a different numbering format then use CTRL+1 and use the formatting dialog box to make your change. Take care. Brian Lee brianl...@charter.net -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Dwight Johnson Sent: Wednesday, February 11, 2015 6:38 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Using excel 2007, windows 8.1 and jaws 14 this began on Monday. I put a value such as 200 in a cell but jaws says 4 jan or some other date bbut the total at bottom of the column is correct. -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of John Justice Sent: Tuesday, February 10, 2015 9:51 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Jaws can be set to read the cells in many ways. There are specific settings in the Quick Settings section. 1. While focused on Excel, press INSERT+V to open the Quick Settings dialog. 2. Arrow down to the beginning of the texdt or use the Search window and type something like read cell contents. 3. The easiest way is to press the letter T twice. That takes you to a setting indicating that Jaws should read the cell contents. 4. Now use first letter navigation C, pressed twice. 5. You will be in the settings for cells. Here's the great part of Quick Settings. If you aren't sure, just highlight a setting, then tab over and there will be a text box explaining what each setting does. The text explanations change, depending on which parameter you have highlighted currently. Before doing anything, look through these. 6. You can try a change, make a note of it and then if you don't like the results, open up Quick Settings again and try another setting. Excel settings for Jaws are quite extensive. I suggest you figure out what you want to do and then try to find the setting that makes Jaws do that. Reading cell contents is one of those settings. You can also have Jaws read the column or row settings in Excel but that's for another message. JOHN AND LINDA JUSTICE PERSONAL E-MAIL: john_just...@verizon.net -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Mike Boyd Sent: Tuesday, February 10, 2015 1:41 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Could you please elaborate a little on Excel does not read the cells properly if at all? If JAWS does read something, what does it say? It could be that the excel window needs to be maximized is all. Mike blindb...@comcast.net -Original Message- From: Flor Lynch Sent: Monday, February 09, 2015 6:13 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Which version of Excel do you have installed? -Original Message- From: Eyþór Kamban Þrastarson Sent: Monday, February 09, 2015 11:53 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] problem with excel Hi I have a lenovo Yoga computer with office and Jaws 16installed. Excel does not read the cells correctly if at all. Anyone else have this problem and knows what‘s wrong? Best Eythor For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com For answers to frequently asked questions about this list visit
Re: [JAWS-Users] problem with excel
Using excel 2007, windows 8.1 and jaws 14 this began on Monday. I put a value such as 200 in a cell but jaws says 4 jan or some other date bbut the total at bottom of the column is correct. -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of John Justice Sent: Tuesday, February 10, 2015 9:51 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Jaws can be set to read the cells in many ways. There are specific settings in the Quick Settings section. 1. While focused on Excel, press INSERT+V to open the Quick Settings dialog. 2. Arrow down to the beginning of the texdt or use the Search window and type something like read cell contents. 3. The easiest way is to press the letter T twice. That takes you to a setting indicating that Jaws should read the cell contents. 4. Now use first letter navigation C, pressed twice. 5. You will be in the settings for cells. Here's the great part of Quick Settings. If you aren't sure, just highlight a setting, then tab over and there will be a text box explaining what each setting does. The text explanations change, depending on which parameter you have highlighted currently. Before doing anything, look through these. 6. You can try a change, make a note of it and then if you don't like the results, open up Quick Settings again and try another setting. Excel settings for Jaws are quite extensive. I suggest you figure out what you want to do and then try to find the setting that makes Jaws do that. Reading cell contents is one of those settings. You can also have Jaws read the column or row settings in Excel but that's for another message. JOHN AND LINDA JUSTICE PERSONAL E-MAIL: john_just...@verizon.net -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Mike Boyd Sent: Tuesday, February 10, 2015 1:41 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Could you please elaborate a little on Excel does not read the cells properly if at all? If JAWS does read something, what does it say? It could be that the excel window needs to be maximized is all. Mike blindb...@comcast.net -Original Message- From: Flor Lynch Sent: Monday, February 09, 2015 6:13 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Which version of Excel do you have installed? -Original Message- From: Eyþór Kamban Þrastarson Sent: Monday, February 09, 2015 11:53 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] problem with excel Hi I have a lenovo Yoga computer with office and Jaws 16installed. Excel does not read the cells correctly if at all. Anyone else have this problem and knows what‘s wrong? Best Eythor For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] problem with excel
Hello Dwight, To change the format of a cell to a number without a decimal point you can use CTRL+Shift+Tilde. You might need to use the JAWS pass through command first, which is the JAWS key with the number 3. (Use the number three that is above the E and not the one on the number pad). Try it without the pass through first but my system must be using that keystroke for something else and I need to use the pass through command. To change the format of a cell to a number format that uses two decimal places, a thousand separator and a minus sign when applicable use CTRL+Shift+! (that is the control key with the shift key and the number 1) If you need to select a range to apply the formatting to then you can use CTRL+G and type in the first and last cell to be included in the range separated by a colon. For example, A7:g12 will select cells starting with a7 and ending with g12 once you press the enter key. You can then use the keystroke to apply the number format you want. If you want a different numbering format then use CTRL+1 and use the formatting dialog box to make your change. Take care. Brian Lee brianl...@charter.net -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Dwight Johnson Sent: Wednesday, February 11, 2015 6:38 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Using excel 2007, windows 8.1 and jaws 14 this began on Monday. I put a value such as 200 in a cell but jaws says 4 jan or some other date bbut the total at bottom of the column is correct. -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of John Justice Sent: Tuesday, February 10, 2015 9:51 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Jaws can be set to read the cells in many ways. There are specific settings in the Quick Settings section. 1. While focused on Excel, press INSERT+V to open the Quick Settings dialog. 2. Arrow down to the beginning of the texdt or use the Search window and type something like read cell contents. 3. The easiest way is to press the letter T twice. That takes you to a setting indicating that Jaws should read the cell contents. 4. Now use first letter navigation C, pressed twice. 5. You will be in the settings for cells. Here's the great part of Quick Settings. If you aren't sure, just highlight a setting, then tab over and there will be a text box explaining what each setting does. The text explanations change, depending on which parameter you have highlighted currently. Before doing anything, look through these. 6. You can try a change, make a note of it and then if you don't like the results, open up Quick Settings again and try another setting. Excel settings for Jaws are quite extensive. I suggest you figure out what you want to do and then try to find the setting that makes Jaws do that. Reading cell contents is one of those settings. You can also have Jaws read the column or row settings in Excel but that's for another message. JOHN AND LINDA JUSTICE PERSONAL E-MAIL: john_just...@verizon.net -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Mike Boyd Sent: Tuesday, February 10, 2015 1:41 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Could you please elaborate a little on Excel does not read the cells properly if at all? If JAWS does read something, what does it say? It could be that the excel window needs to be maximized is all. Mike blindb...@comcast.net -Original Message- From: Flor Lynch Sent: Monday, February 09, 2015 6:13 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Which version of Excel do you have installed? -Original Message- From: Eyþór Kamban Þrastarson Sent: Monday, February 09, 2015 11:53 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] problem with excel Hi I have a lenovo Yoga computer with office and Jaws 16installed. Excel does not read the cells correctly if at all. Anyone else have this problem and knows what‘s wrong? Best Eythor For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] problem with excel
Jaws can be set to read the cells in many ways. There are specific settings in the Quick Settings section. 1. While focused on Excel, press INSERT+V to open the Quick Settings dialog. 2. Arrow down to the beginning of the texdt or use the Search window and type something like read cell contents. 3. The easiest way is to press the letter T twice. That takes you to a setting indicating that Jaws should read the cell contents. 4. Now use first letter navigation C, pressed twice. 5. You will be in the settings for cells. Here's the great part of Quick Settings. If you aren't sure, just highlight a setting, then tab over and there will be a text box explaining what each setting does. The text explanations change, depending on which parameter you have highlighted currently. Before doing anything, look through these. 6. You can try a change, make a note of it and then if you don't like the results, open up Quick Settings again and try another setting. Excel settings for Jaws are quite extensive. I suggest you figure out what you want to do and then try to find the setting that makes Jaws do that. Reading cell contents is one of those settings. You can also have Jaws read the column or row settings in Excel but that's for another message. JOHN AND LINDA JUSTICE PERSONAL E-MAIL: john_just...@verizon.net -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Mike Boyd Sent: Tuesday, February 10, 2015 1:41 AM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Could you please elaborate a little on Excel does not read the cells properly if at all? If JAWS does read something, what does it say? It could be that the excel window needs to be maximized is all. Mike blindb...@comcast.net -Original Message- From: Flor Lynch Sent: Monday, February 09, 2015 6:13 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Which version of Excel do you have installed? -Original Message- From: Eyþór Kamban Þrastarson Sent: Monday, February 09, 2015 11:53 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] problem with excel Hi I have a lenovo Yoga computer with office and Jaws 16installed. Excel does not read the cells correctly if at all. Anyone else have this problem and knows what‘s wrong? Best Eythor For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] problem with excel
Using JAWS16 and Excel2010 when you have the Excel worksheet opened, use Insert+V to open the JAWS Quick Settings. Under the Level 2 Cell Appearance group use spacebar to put a check next to cell text visibility detection. HTH, Annette -Original Message- From: JAWS-Users-List [mailto:jaws-users-list-boun...@jaws-users.com] On Behalf Of Lynn White Sent: Monday, February 09, 2015 7:19 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel I was wondering how Jaws can tell if a cell is overlapping or not. window-Eyes will tell you how much overlapping there is or when material is wrapped or not. Not bashing at all because I use both screen readers. On 2/9/2015 5:53 PM, Eyþór Kamban Þrastarson wrote: Hi I have a lenovo Yoga computer with office and Jaws 16installed. Excel does not read the cells correctly if at all. Anyone else have this problem and knows whats wrong? Best Eythor For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] problem with excel
Could you please elaborate a little on Excel does not read the cells properly if at all? If JAWS does read something, what does it say? It could be that the excel window needs to be maximized is all. Mike blindb...@comcast.net -Original Message- From: Flor Lynch Sent: Monday, February 09, 2015 6:13 PM To: jaws-users-list@jaws-users.com Subject: Re: [JAWS-Users] problem with excel Which version of Excel do you have installed? -Original Message- From: Eyþór Kamban Þrastarson Sent: Monday, February 09, 2015 11:53 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] problem with excel Hi I have a lenovo Yoga computer with office and Jaws 16installed. Excel does not read the cells correctly if at all. Anyone else have this problem and knows what‘s wrong? Best Eythor For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
[JAWS-Users] problem with excel
Hi I have a lenovo Yoga computer with office and Jaws 16installed. Excel does not read the cells correctly if at all. Anyone else have this problem and knows whats wrong? Best Eythor For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] problem with excel
I was wondering how Jaws can tell if a cell is overlapping or not. window-Eyes will tell you how much overlapping there is or when material is wrapped or not. Not bashing at all because I use both screen readers. On 2/9/2015 5:53 PM, Eyþór Kamban Þrastarson wrote: Hi I have a lenovo Yoga computer with office and Jaws 16installed. Excel does not read the cells correctly if at all. Anyone else have this problem and knows what‘s wrong? Best Eythor For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
Re: [JAWS-Users] problem with excel
It could be that you need to maximize the window for Excel. Mike blindb...@comcast.net -Original Message- From: Eyþór Kamban Þrastarson Sent: Monday, February 09, 2015 3:53 PM To: jaws-users-list@jaws-users.com Subject: [JAWS-Users] problem with excel Hi I have a lenovo Yoga computer with office and Jaws 16installed. Excel does not read the cells correctly if at all. Anyone else have this problem and knows what‘s wrong? Best Eythor For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/ For answers to frequently asked questions about this list visit: http://www.jaws-users.com/help/
