Re: [AI] An Excel question - would appreciate a quick response
In that case, go to Format menu, Style submenu, and make sure, Normal style is selected. Also activate the Modify option and check all the options inside the Modify dialogue box. When I do the accounts, I select number with two decimal places in the Modify style dialogue box and it renders all numbers into proper formats inside the entire workbook. Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Himanshu Sahu sahu.himanshu2...@gmail.com To: accessindia@accessindia.org.in Sent: Monday, February 14, 2011 10:45 AM Subject: Re: [AI] An Excel question - would appreciate a quick response Sorry for the delayed response Dada. I unchecked all the check boxes in Option/Edit Tab Page sequentially , but the problem is still persisted. On 2/12/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: What's not working, the shortcuts or the options? Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Himanshu Sahu sahu.himanshu2...@gmail.com To: accessindia@accessindia.org.in Sent: Friday, February 11, 2011 4:45 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Sorry, its not working... On 2/11/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: Hello, You can explore options under Tools menu. Perhaps some feature has been turned on on the edit tab. It is converting the value automatically into date format. In my case, the number 10/1 remains unaffected. You can always use the shortcut keys for cell format: Ctrl+shift+1: for two decimal places Ctrl+shift+2: for time in format h:mm AM/PM Ctrl+shift+3: for date in format d-mmm-yy Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Himanshu Sahu sahu.himanshu2...@gmail.com To: accessindia@accessindia.org.in Sent: Thursday, February 10, 2011 10:44 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I too have one problem and that is whenever I type any number/another number or number . another number like, 10/1, or 10.1, it appears in the form of date/month/year. Any suggestion that where from I need to disable this format? On 2/10/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: Very interesting, never faced a problem like this. Can you send me a sample file with such data for an idea? Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: bharatvaya bharatv...@gmail.com To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 8:18 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I have 1 problem is that when I type any value for example 55 it appears 0.55 any solution? - Original Message - From: Amiyo Biswas amiyo.bis...@gmail.com To: Geetha Shamanna gee...@millernorbert.de; accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 6:09 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I normally select the entire column using ctrl+spacebar and then activate the autofit o;submenu under, column under format menu. It fits the column according to the largest cell in the column. Normally, I use ctrl+a to select all and then use the text wrap checkbox on alignment tab of the vormat cell dialogue box under format menu. overlapping data is very likely to escape our notice when thousands of cells are there. It is not possible to check so many cells using the jaws verbosity feature. Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Geetha Shamanna gee...@millernorbert.de To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 1:17 AM Subject: Re: [AI] An Excel question - would appreciate a quick response Thank you, this tip is very helpful. - Original Message - From: Arvind Bhartiya arvind.bhart...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 08, 2011 5:00 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Hi! Vamshi: Data sometimes spills out of the cell and jaws will not normally alert you if that has happened. But there is a way that you are alerted in such a case once you move to that particular cell. Activate jaws verbosity by pressing insert v. Then hit c couple of times till you hear cell text visibility . By default this is off. press space to turn it on and hit enter. Now if you come over a cell with data spilling out jaws will alert you by saying for example cell a1 overlapps to cell b1. This is an indication that data in cell a1 is overflowing to cell b1 and you can do the needful. Hope this answers your query. regards Arvind On 2/8/11, Vamshi. G gvamsh...@gmail.com wrote: Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text
Re: [AI] An Excel question - would appreciate a quick response
Sorry for the delayed response Dada. I unchecked all the check boxes in Option/Edit Tab Page sequentially , but the problem is still persisted. On 2/12/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: What's not working, the shortcuts or the options? Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Himanshu Sahu sahu.himanshu2...@gmail.com To: accessindia@accessindia.org.in Sent: Friday, February 11, 2011 4:45 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Sorry, its not working... On 2/11/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: Hello, You can explore options under Tools menu. Perhaps some feature has been turned on on the edit tab. It is converting the value automatically into date format. In my case, the number 10/1 remains unaffected. You can always use the shortcut keys for cell format: Ctrl+shift+1: for two decimal places Ctrl+shift+2: for time in format h:mm AM/PM Ctrl+shift+3: for date in format d-mmm-yy Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Himanshu Sahu sahu.himanshu2...@gmail.com To: accessindia@accessindia.org.in Sent: Thursday, February 10, 2011 10:44 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I too have one problem and that is whenever I type any number/another number or number . another number like, 10/1, or 10.1, it appears in the form of date/month/year. Any suggestion that where from I need to disable this format? On 2/10/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: Very interesting, never faced a problem like this. Can you send me a sample file with such data for an idea? Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: bharatvaya bharatv...@gmail.com To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 8:18 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I have 1 problem is that when I type any value for example 55 it appears 0.55 any solution? - Original Message - From: Amiyo Biswas amiyo.bis...@gmail.com To: Geetha Shamanna gee...@millernorbert.de; accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 6:09 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I normally select the entire column using ctrl+spacebar and then activate the autofit o;submenu under, column under format menu. It fits the column according to the largest cell in the column. Normally, I use ctrl+a to select all and then use the text wrap checkbox on alignment tab of the vormat cell dialogue box under format menu. overlapping data is very likely to escape our notice when thousands of cells are there. It is not possible to check so many cells using the jaws verbosity feature. Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Geetha Shamanna gee...@millernorbert.de To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 1:17 AM Subject: Re: [AI] An Excel question - would appreciate a quick response Thank you, this tip is very helpful. - Original Message - From: Arvind Bhartiya arvind.bhart...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 08, 2011 5:00 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Hi! Vamshi: Data sometimes spills out of the cell and jaws will not normally alert you if that has happened. But there is a way that you are alerted in such a case once you move to that particular cell. Activate jaws verbosity by pressing insert v. Then hit c couple of times till you hear cell text visibility . By default this is off. press space to turn it on and hit enter. Now if you come over a cell with data spilling out jaws will alert you by saying for example cell a1 overlapps to cell b1. This is an indication that data in cell a1 is overflowing to cell b1 and you can do the needful. Hope this answers your query. regards Arvind On 2/8/11, Vamshi. G gvamsh...@gmail.com wrote: Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text of that particular cell so that the content in the cell gets adjusted in more than one line without increasing the width of the cell. But I don't know how to know which are the columns that need to be adjusted. Jaws reads all the columns identically. Can someone explain this? -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/8/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, I am working on an Excel file
Re: [AI] An Excel question - would appreciate a quick response
Sorry, its not working... On 2/11/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: Hello, You can explore options under Tools menu. Perhaps some feature has been turned on on the edit tab. It is converting the value automatically into date format. In my case, the number 10/1 remains unaffected. You can always use the shortcut keys for cell format: Ctrl+shift+1: for two decimal places Ctrl+shift+2: for time in format h:mm AM/PM Ctrl+shift+3: for date in format d-mmm-yy Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Himanshu Sahu sahu.himanshu2...@gmail.com To: accessindia@accessindia.org.in Sent: Thursday, February 10, 2011 10:44 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I too have one problem and that is whenever I type any number/another number or number . another number like, 10/1, or 10.1, it appears in the form of date/month/year. Any suggestion that where from I need to disable this format? On 2/10/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: Very interesting, never faced a problem like this. Can you send me a sample file with such data for an idea? Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: bharatvaya bharatv...@gmail.com To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 8:18 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I have 1 problem is that when I type any value for example 55 it appears 0.55 any solution? - Original Message - From: Amiyo Biswas amiyo.bis...@gmail.com To: Geetha Shamanna gee...@millernorbert.de; accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 6:09 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I normally select the entire column using ctrl+spacebar and then activate the autofit o;submenu under, column under format menu. It fits the column according to the largest cell in the column. Normally, I use ctrl+a to select all and then use the text wrap checkbox on alignment tab of the vormat cell dialogue box under format menu. overlapping data is very likely to escape our notice when thousands of cells are there. It is not possible to check so many cells using the jaws verbosity feature. Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Geetha Shamanna gee...@millernorbert.de To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 1:17 AM Subject: Re: [AI] An Excel question - would appreciate a quick response Thank you, this tip is very helpful. - Original Message - From: Arvind Bhartiya arvind.bhart...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 08, 2011 5:00 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Hi! Vamshi: Data sometimes spills out of the cell and jaws will not normally alert you if that has happened. But there is a way that you are alerted in such a case once you move to that particular cell. Activate jaws verbosity by pressing insert v. Then hit c couple of times till you hear cell text visibility . By default this is off. press space to turn it on and hit enter. Now if you come over a cell with data spilling out jaws will alert you by saying for example cell a1 overlapps to cell b1. This is an indication that data in cell a1 is overflowing to cell b1 and you can do the needful. Hope this answers your query. regards Arvind On 2/8/11, Vamshi. G gvamsh...@gmail.com wrote: Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text of that particular cell so that the content in the cell gets adjusted in more than one line without increasing the width of the cell. But I don't know how to know which are the columns that need to be adjusted. Jaws reads all the columns identically. Can someone explain this? -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/8/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, I am working on an Excel file in which several cells have lot of data. Jaws always reads everything out; however, I am not sure whether everything that is in a cell is being displayed on the screen. How do I reformat the cell so that everything appears on the screen? Do I need to use the auto-fit option? Where exactly is it located? Many thanks. Geetha Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census
Re: [AI] An Excel question - would appreciate a quick response
Hi, The short cut keys for date and time are ctrl+; and ctrl +shift+; respectively. -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/11/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: Hello, You can explore options under Tools menu. Perhaps some feature has been turned on on the edit tab. It is converting the value automatically into date format. In my case, the number 10/1 remains unaffected. You can always use the shortcut keys for cell format: Ctrl+shift+1: for two decimal places Ctrl+shift+2: for time in format h:mm AM/PM Ctrl+shift+3: for date in format d-mmm-yy Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Himanshu Sahu sahu.himanshu2...@gmail.com To: accessindia@accessindia.org.in Sent: Thursday, February 10, 2011 10:44 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I too have one problem and that is whenever I type any number/another number or number . another number like, 10/1, or 10.1, it appears in the form of date/month/year. Any suggestion that where from I need to disable this format? On 2/10/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: Very interesting, never faced a problem like this. Can you send me a sample file with such data for an idea? Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: bharatvaya bharatv...@gmail.com To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 8:18 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I have 1 problem is that when I type any value for example 55 it appears 0.55 any solution? - Original Message - From: Amiyo Biswas amiyo.bis...@gmail.com To: Geetha Shamanna gee...@millernorbert.de; accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 6:09 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I normally select the entire column using ctrl+spacebar and then activate the autofit o;submenu under, column under format menu. It fits the column according to the largest cell in the column. Normally, I use ctrl+a to select all and then use the text wrap checkbox on alignment tab of the vormat cell dialogue box under format menu. overlapping data is very likely to escape our notice when thousands of cells are there. It is not possible to check so many cells using the jaws verbosity feature. Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Geetha Shamanna gee...@millernorbert.de To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 1:17 AM Subject: Re: [AI] An Excel question - would appreciate a quick response Thank you, this tip is very helpful. - Original Message - From: Arvind Bhartiya arvind.bhart...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 08, 2011 5:00 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Hi! Vamshi: Data sometimes spills out of the cell and jaws will not normally alert you if that has happened. But there is a way that you are alerted in such a case once you move to that particular cell. Activate jaws verbosity by pressing insert v. Then hit c couple of times till you hear cell text visibility . By default this is off. press space to turn it on and hit enter. Now if you come over a cell with data spilling out jaws will alert you by saying for example cell a1 overlapps to cell b1. This is an indication that data in cell a1 is overflowing to cell b1 and you can do the needful. Hope this answers your query. regards Arvind On 2/8/11, Vamshi. G gvamsh...@gmail.com wrote: Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text of that particular cell so that the content in the cell gets adjusted in more than one line without increasing the width of the cell. But I don't know how to know which are the columns that need to be adjusted. Jaws reads all the columns identically. Can someone explain this? -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/8/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, I am working on an Excel file in which several cells have lot of data. Jaws always reads everything out; however, I am not sure whether everything that is in a cell is being displayed on the screen. How do I reformat the cell so that everything appears on the screen? Do I need to use the auto-fit option? Where exactly is it located? Many
Re: [AI] An Excel question - would appreciate a quick response
What's not working, the shortcuts or the options? Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Himanshu Sahu sahu.himanshu2...@gmail.com To: accessindia@accessindia.org.in Sent: Friday, February 11, 2011 4:45 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Sorry, its not working... On 2/11/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: Hello, You can explore options under Tools menu. Perhaps some feature has been turned on on the edit tab. It is converting the value automatically into date format. In my case, the number 10/1 remains unaffected. You can always use the shortcut keys for cell format: Ctrl+shift+1: for two decimal places Ctrl+shift+2: for time in format h:mm AM/PM Ctrl+shift+3: for date in format d-mmm-yy Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Himanshu Sahu sahu.himanshu2...@gmail.com To: accessindia@accessindia.org.in Sent: Thursday, February 10, 2011 10:44 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I too have one problem and that is whenever I type any number/another number or number . another number like, 10/1, or 10.1, it appears in the form of date/month/year. Any suggestion that where from I need to disable this format? On 2/10/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: Very interesting, never faced a problem like this. Can you send me a sample file with such data for an idea? Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: bharatvaya bharatv...@gmail.com To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 8:18 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I have 1 problem is that when I type any value for example 55 it appears 0.55 any solution? - Original Message - From: Amiyo Biswas amiyo.bis...@gmail.com To: Geetha Shamanna gee...@millernorbert.de; accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 6:09 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I normally select the entire column using ctrl+spacebar and then activate the autofit o;submenu under, column under format menu. It fits the column according to the largest cell in the column. Normally, I use ctrl+a to select all and then use the text wrap checkbox on alignment tab of the vormat cell dialogue box under format menu. overlapping data is very likely to escape our notice when thousands of cells are there. It is not possible to check so many cells using the jaws verbosity feature. Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Geetha Shamanna gee...@millernorbert.de To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 1:17 AM Subject: Re: [AI] An Excel question - would appreciate a quick response Thank you, this tip is very helpful. - Original Message - From: Arvind Bhartiya arvind.bhart...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 08, 2011 5:00 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Hi! Vamshi: Data sometimes spills out of the cell and jaws will not normally alert you if that has happened. But there is a way that you are alerted in such a case once you move to that particular cell. Activate jaws verbosity by pressing insert v. Then hit c couple of times till you hear cell text visibility . By default this is off. press space to turn it on and hit enter. Now if you come over a cell with data spilling out jaws will alert you by saying for example cell a1 overlapps to cell b1. This is an indication that data in cell a1 is overflowing to cell b1 and you can do the needful. Hope this answers your query. regards Arvind On 2/8/11, Vamshi. G gvamsh...@gmail.com wrote: Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text of that particular cell so that the content in the cell gets adjusted in more than one line without increasing the width of the cell. But I don't know how to know which are the columns that need to be adjusted. Jaws reads all the columns identically. Can someone explain this? -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/8/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, I am working on an Excel file in which several cells have lot of data. Jaws always reads everything out; however, I am not sure whether everything that is in a cell is being displayed on the screen. How do I reformat the cell so that everything appears on the screen? Do I need to use the auto-fit option? Where
Re: [AI] An Excel question - would appreciate a quick response
Hello, You can explore options under Tools menu. Perhaps some feature has been turned on on the edit tab. It is converting the value automatically into date format. In my case, the number 10/1 remains unaffected. You can always use the shortcut keys for cell format: Ctrl+shift+1: for two decimal places Ctrl+shift+2: for time in format h:mm AM/PM Ctrl+shift+3: for date in format d-mmm-yy Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Himanshu Sahu sahu.himanshu2...@gmail.com To: accessindia@accessindia.org.in Sent: Thursday, February 10, 2011 10:44 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I too have one problem and that is whenever I type any number/another number or number . another number like, 10/1, or 10.1, it appears in the form of date/month/year. Any suggestion that where from I need to disable this format? On 2/10/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: Very interesting, never faced a problem like this. Can you send me a sample file with such data for an idea? Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: bharatvaya bharatv...@gmail.com To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 8:18 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I have 1 problem is that when I type any value for example 55 it appears 0.55 any solution? - Original Message - From: Amiyo Biswas amiyo.bis...@gmail.com To: Geetha Shamanna gee...@millernorbert.de; accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 6:09 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I normally select the entire column using ctrl+spacebar and then activate the autofit o;submenu under, column under format menu. It fits the column according to the largest cell in the column. Normally, I use ctrl+a to select all and then use the text wrap checkbox on alignment tab of the vormat cell dialogue box under format menu. overlapping data is very likely to escape our notice when thousands of cells are there. It is not possible to check so many cells using the jaws verbosity feature. Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Geetha Shamanna gee...@millernorbert.de To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 1:17 AM Subject: Re: [AI] An Excel question - would appreciate a quick response Thank you, this tip is very helpful. - Original Message - From: Arvind Bhartiya arvind.bhart...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 08, 2011 5:00 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Hi! Vamshi: Data sometimes spills out of the cell and jaws will not normally alert you if that has happened. But there is a way that you are alerted in such a case once you move to that particular cell. Activate jaws verbosity by pressing insert v. Then hit c couple of times till you hear cell text visibility . By default this is off. press space to turn it on and hit enter. Now if you come over a cell with data spilling out jaws will alert you by saying for example cell a1 overlapps to cell b1. This is an indication that data in cell a1 is overflowing to cell b1 and you can do the needful. Hope this answers your query. regards Arvind On 2/8/11, Vamshi. G gvamsh...@gmail.com wrote: Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text of that particular cell so that the content in the cell gets adjusted in more than one line without increasing the width of the cell. But I don't know how to know which are the columns that need to be adjusted. Jaws reads all the columns identically. Can someone explain this? -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/8/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, I am working on an Excel file in which several cells have lot of data. Jaws always reads everything out; however, I am not sure whether everything that is in a cell is being displayed on the screen. How do I reformat the cell so that everything appears on the screen? Do I need to use the auto-fit option? Where exactly is it located? Many thanks. Geetha Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct
Re: [AI] An Excel question - would appreciate a quick response
Very interesting, never faced a problem like this. Can you send me a sample file with such data for an idea? Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: bharatvaya bharatv...@gmail.com To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 8:18 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I have 1 problem is that when I type any value for example 55 it appears 0.55 any solution? - Original Message - From: Amiyo Biswas amiyo.bis...@gmail.com To: Geetha Shamanna gee...@millernorbert.de; accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 6:09 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I normally select the entire column using ctrl+spacebar and then activate the autofit o;submenu under, column under format menu. It fits the column according to the largest cell in the column. Normally, I use ctrl+a to select all and then use the text wrap checkbox on alignment tab of the vormat cell dialogue box under format menu. overlapping data is very likely to escape our notice when thousands of cells are there. It is not possible to check so many cells using the jaws verbosity feature. Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Geetha Shamanna gee...@millernorbert.de To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 1:17 AM Subject: Re: [AI] An Excel question - would appreciate a quick response Thank you, this tip is very helpful. - Original Message - From: Arvind Bhartiya arvind.bhart...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 08, 2011 5:00 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Hi! Vamshi: Data sometimes spills out of the cell and jaws will not normally alert you if that has happened. But there is a way that you are alerted in such a case once you move to that particular cell. Activate jaws verbosity by pressing insert v. Then hit c couple of times till you hear cell text visibility . By default this is off. press space to turn it on and hit enter. Now if you come over a cell with data spilling out jaws will alert you by saying for example cell a1 overlapps to cell b1. This is an indication that data in cell a1 is overflowing to cell b1 and you can do the needful. Hope this answers your query. regards Arvind On 2/8/11, Vamshi. G gvamsh...@gmail.com wrote: Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text of that particular cell so that the content in the cell gets adjusted in more than one line without increasing the width of the cell. But I don't know how to know which are the columns that need to be adjusted. Jaws reads all the columns identically. Can someone explain this? -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/8/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, I am working on an Excel file in which several cells have lot of data. Jaws always reads everything out; however, I am not sure whether everything that is in a cell is being displayed on the screen. How do I reformat the cell so that everything appears on the screen? Do I need to use the auto-fit option? Where exactly is it located? Many thanks. Geetha Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info!
Re: [AI] An Excel question - would appreciate a quick response
I too have one problem and that is whenever I type any number/another number or number . another number like, 10/1, or 10.1, it appears in the form of date/month/year. Any suggestion that where from I need to disable this format? On 2/10/11, Amiyo Biswas amiyo.bis...@gmail.com wrote: Very interesting, never faced a problem like this. Can you send me a sample file with such data for an idea? Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: bharatvaya bharatv...@gmail.com To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 8:18 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I have 1 problem is that when I type any value for example 55 it appears 0.55 any solution? - Original Message - From: Amiyo Biswas amiyo.bis...@gmail.com To: Geetha Shamanna gee...@millernorbert.de; accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 6:09 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I normally select the entire column using ctrl+spacebar and then activate the autofit o;submenu under, column under format menu. It fits the column according to the largest cell in the column. Normally, I use ctrl+a to select all and then use the text wrap checkbox on alignment tab of the vormat cell dialogue box under format menu. overlapping data is very likely to escape our notice when thousands of cells are there. It is not possible to check so many cells using the jaws verbosity feature. Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Geetha Shamanna gee...@millernorbert.de To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 1:17 AM Subject: Re: [AI] An Excel question - would appreciate a quick response Thank you, this tip is very helpful. - Original Message - From: Arvind Bhartiya arvind.bhart...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 08, 2011 5:00 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Hi! Vamshi: Data sometimes spills out of the cell and jaws will not normally alert you if that has happened. But there is a way that you are alerted in such a case once you move to that particular cell. Activate jaws verbosity by pressing insert v. Then hit c couple of times till you hear cell text visibility . By default this is off. press space to turn it on and hit enter. Now if you come over a cell with data spilling out jaws will alert you by saying for example cell a1 overlapps to cell b1. This is an indication that data in cell a1 is overflowing to cell b1 and you can do the needful. Hope this answers your query. regards Arvind On 2/8/11, Vamshi. G gvamsh...@gmail.com wrote: Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text of that particular cell so that the content in the cell gets adjusted in more than one line without increasing the width of the cell. But I don't know how to know which are the columns that need to be adjusted. Jaws reads all the columns identically. Can someone explain this? -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/8/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, I am working on an Excel file in which several cells have lot of data. Jaws always reads everything out; however, I am not sure whether everything that is in a cell is being displayed on the screen. How do I reformat the cell so that everything appears on the screen? Do I need to use the auto-fit option? Where exactly is it located? Many thanks. Geetha Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! -- Thanks and regards Himanshu Sahu Reach: 09051055000 Get numbers right this time, help the census with correct disability info!
[AI] An Excel question - would appreciate a quick response
Hello all, I am working on an Excel file in which several cells have lot of data. Jaws always reads everything out; however, I am not sure whether everything that is in a cell is being displayed on the screen. How do I reformat the cell so that everything appears on the screen? Do I need to use the auto-fit option? Where exactly is it located? Many thanks. Geetha Get numbers right this time, help the census with correct disability info!
Re: [AI] An Excel question - would appreciate a quick response
Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text of that particular cell so that the content in the cell gets adjusted in more than one line without increasing the width of the cell. But I don't know how to know which are the columns that need to be adjusted. Jaws reads all the columns identically. Can someone explain this? -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/8/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, I am working on an Excel file in which several cells have lot of data. Jaws always reads everything out; however, I am not sure whether everything that is in a cell is being displayed on the screen. How do I reformat the cell so that everything appears on the screen? Do I need to use the auto-fit option? Where exactly is it located? Many thanks. Geetha Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info!
Re: [AI] An Excel question - would appreciate a quick response
Hi! Vamshi: Data sometimes spills out of the cell and jaws will not normally alert you if that has happened. But there is a way that you are alerted in such a case once you move to that particular cell. Activate jaws verbosity by pressing insert v. Then hit c couple of times till you hear cell text visibility . By default this is off. press space to turn it on and hit enter. Now if you come over a cell with data spilling out jaws will alert you by saying for example cell a1 overlapps to cell b1. This is an indication that data in cell a1 is overflowing to cell b1 and you can do the needful. Hope this answers your query. regards Arvind On 2/8/11, Vamshi. G gvamsh...@gmail.com wrote: Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text of that particular cell so that the content in the cell gets adjusted in more than one line without increasing the width of the cell. But I don't know how to know which are the columns that need to be adjusted. Jaws reads all the columns identically. Can someone explain this? -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/8/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, I am working on an Excel file in which several cells have lot of data. Jaws always reads everything out; however, I am not sure whether everything that is in a cell is being displayed on the screen. How do I reformat the cell so that everything appears on the screen? Do I need to use the auto-fit option? Where exactly is it located? Many thanks. Geetha Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info!
Re: [AI] An Excel question - would appreciate a quick response
Thank you, this tip is very helpful. - Original Message - From: Arvind Bhartiya arvind.bhart...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 08, 2011 5:00 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Hi! Vamshi: Data sometimes spills out of the cell and jaws will not normally alert you if that has happened. But there is a way that you are alerted in such a case once you move to that particular cell. Activate jaws verbosity by pressing insert v. Then hit c couple of times till you hear cell text visibility . By default this is off. press space to turn it on and hit enter. Now if you come over a cell with data spilling out jaws will alert you by saying for example cell a1 overlapps to cell b1. This is an indication that data in cell a1 is overflowing to cell b1 and you can do the needful. Hope this answers your query. regards Arvind On 2/8/11, Vamshi. G gvamsh...@gmail.com wrote: Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text of that particular cell so that the content in the cell gets adjusted in more than one line without increasing the width of the cell. But I don't know how to know which are the columns that need to be adjusted. Jaws reads all the columns identically. Can someone explain this? -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/8/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, I am working on an Excel file in which several cells have lot of data. Jaws always reads everything out; however, I am not sure whether everything that is in a cell is being displayed on the screen. How do I reformat the cell so that everything appears on the screen? Do I need to use the auto-fit option? Where exactly is it located? Many thanks. Geetha Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info!
Re: [AI] An Excel question - would appreciate a quick response
I normally select the entire column using ctrl+spacebar and then activate the autofit o;submenu under, column under format menu. It fits the column according to the largest cell in the column. Normally, I use ctrl+a to select all and then use the text wrap checkbox on alignment tab of the vormat cell dialogue box under format menu. overlapping data is very likely to escape our notice when thousands of cells are there. It is not possible to check so many cells using the jaws verbosity feature. Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Geetha Shamanna gee...@millernorbert.de To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 1:17 AM Subject: Re: [AI] An Excel question - would appreciate a quick response Thank you, this tip is very helpful. - Original Message - From: Arvind Bhartiya arvind.bhart...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 08, 2011 5:00 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Hi! Vamshi: Data sometimes spills out of the cell and jaws will not normally alert you if that has happened. But there is a way that you are alerted in such a case once you move to that particular cell. Activate jaws verbosity by pressing insert v. Then hit c couple of times till you hear cell text visibility . By default this is off. press space to turn it on and hit enter. Now if you come over a cell with data spilling out jaws will alert you by saying for example cell a1 overlapps to cell b1. This is an indication that data in cell a1 is overflowing to cell b1 and you can do the needful. Hope this answers your query. regards Arvind On 2/8/11, Vamshi. G gvamsh...@gmail.com wrote: Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text of that particular cell so that the content in the cell gets adjusted in more than one line without increasing the width of the cell. But I don't know how to know which are the columns that need to be adjusted. Jaws reads all the columns identically. Can someone explain this? -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/8/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, I am working on an Excel file in which several cells have lot of data. Jaws always reads everything out; however, I am not sure whether everything that is in a cell is being displayed on the screen. How do I reformat the cell so that everything appears on the screen? Do I need to use the auto-fit option? Where exactly is it located? Many thanks. Geetha Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info!
Re: [AI] An Excel question - would appreciate a quick response
I have 1 problem is that when I type any value for example 55 it appears 0.55 any solution? - Original Message - From: Amiyo Biswas amiyo.bis...@gmail.com To: Geetha Shamanna gee...@millernorbert.de; accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 6:09 AM Subject: Re: [AI] An Excel question - would appreciate a quick response I normally select the entire column using ctrl+spacebar and then activate the autofit o;submenu under, column under format menu. It fits the column according to the largest cell in the column. Normally, I use ctrl+a to select all and then use the text wrap checkbox on alignment tab of the vormat cell dialogue box under format menu. overlapping data is very likely to escape our notice when thousands of cells are there. It is not possible to check so many cells using the jaws verbosity feature. Best regards, Amiyo Biswas Cell: 91-9433464329 - Original Message - From: Geetha Shamanna gee...@millernorbert.de To: accessindia@accessindia.org.in Sent: Wednesday, February 09, 2011 1:17 AM Subject: Re: [AI] An Excel question - would appreciate a quick response Thank you, this tip is very helpful. - Original Message - From: Arvind Bhartiya arvind.bhart...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 08, 2011 5:00 PM Subject: Re: [AI] An Excel question - would appreciate a quick response Hi! Vamshi: Data sometimes spills out of the cell and jaws will not normally alert you if that has happened. But there is a way that you are alerted in such a case once you move to that particular cell. Activate jaws verbosity by pressing insert v. Then hit c couple of times till you hear cell text visibility . By default this is off. press space to turn it on and hit enter. Now if you come over a cell with data spilling out jaws will alert you by saying for example cell a1 overlapps to cell b1. This is an indication that data in cell a1 is overflowing to cell b1 and you can do the needful. Hope this answers your query. regards Arvind On 2/8/11, Vamshi. G gvamsh...@gmail.com wrote: Hi Geetha, If you are using Office 2003, you can autofit the columns by going to format menu, and selecting the option column. This increases the width of the column to the cell which has the highest width. Alternatively, you can go to format menu, cells, alignment tab, and wrap the text of that particular cell so that the content in the cell gets adjusted in more than one line without increasing the width of the cell. But I don't know how to know which are the columns that need to be adjusted. Jaws reads all the columns identically. Can someone explain this? -- G. Vamshi PH Res : +91 877-2243861 Mobile: +91 9949349497 E-mail ID: gvamsh...@gmail.com Skype: gvamshi81 www.retinaindia.org From darkness unto light On 2/8/11, Geetha Shamanna gee...@millernorbert.de wrote: Hello all, I am working on an Excel file in which several cells have lot of data. Jaws always reads everything out; however, I am not sure whether everything that is in a cell is being displayed on the screen. How do I reformat the cell so that everything appears on the screen? Do I need to use the auto-fit option? Where exactly is it located? Many thanks. Geetha Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info! Get numbers right this time, help the census with correct disability info!
