Re: [AI] MS Excel doubts
Hello Jayachandran, Please try with following steps 1. Type Jan-2015 in cell A1 2. Select the cell range from A1-A12 by pressing shift down arrow 3. Invoke the series dialogue box by pressing alt + E + I +S 4. Once the dialogue box is displayed your cursor will be positioned in “Step Value” edit field with value “1”, keep the value intact. 5. Press shift tab once and change the value to month by selecting “Month radio button”. 6. Press tab to Navigate to the OK button and press enter. Please explore this dialogue box to accomplish varied results of similar nature. Hope this helps. Best Rahul Gambhir On 2/25/15, Jayachandran1977 optimist@gmail.com wrote: Dear Zujar, Thanks again. I got the list of sheets. Could anybody throw some light on my query no. 3. Thanks. Jayachandran. T 9677294410 - Original Message - From: Zujar Shabbir Kanchwala zujarbri...@gmail.com To: 'AccessIndia: a list for discussing accessibility and issues concerningthe disabled.' accessindia@accessindia.org.in Sent: Wednesday, February 25, 2015 6:05 AM Subject: Re: [AI] MS Excel doubts Sorry Dear! It's CTRL+SHIFT+S that opens the Move to Worksheet dialog box. If you wanna switch to another sheet then select the desired sheet from the list and press ENTER. You can also make use of CTRL+ALT+PageUp or CTRL+ALT+PageDown to switch between sheets chronologically. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 09:47 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: Re: [AI] MS Excel doubts Dear Zujar, Thanks for your mail. Query no. 2 was solved. I got the desired result. Thanks again. Query No. : 1 i.e., getting the list of sheets. I am not getting by pressing ctrl+alt+s. Pls throw some light on this. Iam using office 2007 with JAWS 14. I have one more query. Let it be query no. 3. 3. In a worksheet I want to type Jan 2015, Feb 2015, March 2015 to Dec 2015 in A1 to A12, how to achieve this easily. In this issue also sighted will use mouse dragging. I too used this technic when I was having good sight. Pls reply. Thanks in advance. Jayachandran. T 9677294410 - Original Message - From: Zujar Shabbir Kanchwala zujarbri...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 24, 2015 9:11 PM Subject: Re: [AI] MS Excel doubts Hi Jayachandran, 1. Get list of worksheets in current workbook - CTRL+ALT+S 2. For copying formula: 2.1. Place cursor in source cell (cell containing formula) 2.2. Press CTRL+C to copy 2.3. Press CTRL+G to open GoTo dialog box 2.4. Specify target cell range (cells where formula needs be copied) and hit ENTER 2.5. Press CTRL+V to paste the copied content Believe that's clear! Feel free to revert in case of queries/concerns/suggestions. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 08:03 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: [AI] MS Excel doubts Hello, 01. What is the command to get sheets list in a workbook? 02. Suppose I give a formula in a cell, how to copy the same formula to the successive cells. The sighted person will perform this action by getting a plus symbol at the right end of the cell and drag the mouse to the successive cells. How we can perform this action using keyboard. Apologise me if my questions seems to be silly. Jayachandran. T - Original Message - From: Navin Kumar Gohil navingohil19...@gmail.com To: 'AccessIndia: a list for discussing accessibility and issues concerningthe disabled.' accessindia@accessindia.org.in Sent: Monday, February 23, 2015 8:31 PM Subject: Re: [AI] how to name different worksheets in an excel workbook? Hello, Use Alt,H,O,R command and an edit box will appear. Type the name of the sheet in the edit box you want to rename as and press Enter and then Save file. Trust above helps. Regards Navin Kumar gohil -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Surya Prakash Sharma Sent: 23 February, 2015 8:15 PM To: accessindia Subject: [AI] how to name different worksheets in an excel workbook? Hello all, greetings of the day. please answer the above query. thanks in advance. -- S. P. Sharma Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essind ia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in
Re: [AI] MS Excel doubts
All, Thanks all for clearing me this excel doubt. Let me try the steps which you told and if there is any problem in getting the desired result, let me write again. Thanks a lot for all who replied for my query. Jayachandran. T 9677294410 - Original Message - From: Rahul Gambhir rahul.gambhi...@gmail.com To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Sent: Thursday, February 26, 2015 12:48 AM Subject: Re: [AI] MS Excel doubts Hello Jayachandran, Please try with following steps 1. Type Jan-2015 in cell A1 2. Select the cell range from A1-A12 by pressing shift down arrow 3. Invoke the series dialogue box by pressing alt + E + I +S 4. Once the dialogue box is displayed your cursor will be positioned in “Step Value” edit field with value “1”, keep the value intact. 5. Press shift tab once and change the value to month by selecting “Month radio button”. 6. Press tab to Navigate to the OK button and press enter. Please explore this dialogue box to accomplish varied results of similar nature. Hope this helps. Best Rahul Gambhir On 2/25/15, Jayachandran1977 optimist@gmail.com wrote: Dear Zujar, Thanks again. I got the list of sheets. Could anybody throw some light on my query no. 3. Thanks. Jayachandran. T 9677294410 - Original Message - From: Zujar Shabbir Kanchwala zujarbri...@gmail.com To: 'AccessIndia: a list for discussing accessibility and issues concerningthe disabled.' accessindia@accessindia.org.in Sent: Wednesday, February 25, 2015 6:05 AM Subject: Re: [AI] MS Excel doubts Sorry Dear! It's CTRL+SHIFT+S that opens the Move to Worksheet dialog box. If you wanna switch to another sheet then select the desired sheet from the list and press ENTER. You can also make use of CTRL+ALT+PageUp or CTRL+ALT+PageDown to switch between sheets chronologically. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 09:47 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: Re: [AI] MS Excel doubts Dear Zujar, Thanks for your mail. Query no. 2 was solved. I got the desired result. Thanks again. Query No. : 1 i.e., getting the list of sheets. I am not getting by pressing ctrl+alt+s. Pls throw some light on this. Iam using office 2007 with JAWS 14. I have one more query. Let it be query no. 3. 3. In a worksheet I want to type Jan 2015, Feb 2015, March 2015 to Dec 2015 in A1 to A12, how to achieve this easily. In this issue also sighted will use mouse dragging. I too used this technic when I was having good sight. Pls reply. Thanks in advance. Jayachandran. T 9677294410 - Original Message - From: Zujar Shabbir Kanchwala zujarbri...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 24, 2015 9:11 PM Subject: Re: [AI] MS Excel doubts Hi Jayachandran, 1. Get list of worksheets in current workbook - CTRL+ALT+S 2. For copying formula: 2.1. Place cursor in source cell (cell containing formula) 2.2. Press CTRL+C to copy 2.3. Press CTRL+G to open GoTo dialog box 2.4. Specify target cell range (cells where formula needs be copied) and hit ENTER 2.5. Press CTRL+V to paste the copied content Believe that's clear! Feel free to revert in case of queries/concerns/suggestions. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 08:03 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: [AI] MS Excel doubts Hello, 01. What is the command to get sheets list in a workbook? 02. Suppose I give a formula in a cell, how to copy the same formula to the successive cells. The sighted person will perform this action by getting a plus symbol at the right end of the cell and drag the mouse to the successive cells. How we can perform this action using keyboard. Apologise me if my questions seems to be silly. Jayachandran. T - Original Message - From: Navin Kumar Gohil navingohil19...@gmail.com To: 'AccessIndia: a list for discussing accessibility and issues concerningthe disabled.' accessindia@accessindia.org.in Sent: Monday, February 23, 2015 8:31 PM Subject: Re: [AI] how to name different worksheets in an excel workbook? Hello, Use Alt,H,O,R command and an edit box will appear. Type the name of the sheet in the edit box you want to rename as and press Enter and then Save file. Trust above helps. Regards Navin Kumar gohil -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Surya Prakash Sharma Sent: 23 February, 2015 8:15 PM To: accessindia Subject: [AI] how to name different worksheets in an excel workbook? Hello all, greetings of the day. please answer the above query. thanks
Re: [AI] MS Excel doubts
Query no. 1, minor correction being control shift S as against alt.. Query no. 3, are you talking about normal typing? In that case, it will be F2 for editing current cell, then press enter and edit the next cell likewise. I don't remember, but I had used autofill to get this done once. -- Amar Jain. Website: www.amarjain.com Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] MS Excel doubts
this solution for folloing date is not working . please specify in detail ,how it works? gajendra vyas - Original Message - From: Ekinath Khedekar ekin...@gmail.com To: AccessIndia: a list for discussing accessibility and issues concerningthe disabled. accessindia@accessindia.org.in Sent: Wednesday, February 25, 2015 11:46 AM Subject: Re: [AI] MS Excel doubts Dear Jayachandran, Excel fascinates me and Zujar is an expert on it. Have learnt many things from him. Answer for query 3: You type any date in any format you want and then to get following dates in the following cells just press Control+C at the original date and then by pressing shift+down arrow select range of cells where you want subsequent dates to come up and then just press control+v. Job done. Please note, even for your query no. 2, you can use shift+down or any arrow keys to select and paste the formula. Basically, by pasting any automated formula or format, your selected cells acquire the sequence of the copied formula or format. So, instead of cursor drag use copy and select and paste... Good luck On 2/24/15, Jayachandran1977 optimist@gmail.com wrote: Dear Zujar, Thanks for your mail. Query no. 2 was solved. I got the desired result. Thanks again. Query No. : 1 i.e., getting the list of sheets. I am not getting by pressing ctrl+alt+s. Pls throw some light on this. Iam using office 2007 with JAWS 14. I have one more query. Let it be query no. 3. 3. In a worksheet I want to type Jan 2015, Feb 2015, March 2015 to Dec 2015 in A1 to A12, how to achieve this easily. In this issue also sighted will use mouse dragging. I too used this technic when I was having good sight. Pls reply. Thanks in advance. Jayachandran. T 9677294410 - Original Message - From: Zujar Shabbir Kanchwala zujarbri...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 24, 2015 9:11 PM Subject: Re: [AI] MS Excel doubts Hi Jayachandran, 1. Get list of worksheets in current workbook - CTRL+ALT+S 2. For copying formula: 2.1. Place cursor in source cell (cell containing formula) 2.2. Press CTRL+C to copy 2.3. Press CTRL+G to open GoTo dialog box 2.4. Specify target cell range (cells where formula needs be copied) and hit ENTER 2.5. Press CTRL+V to paste the copied content Believe that's clear! Feel free to revert in case of queries/concerns/suggestions. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 08:03 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: [AI] MS Excel doubts Hello, 01. What is the command to get sheets list in a workbook? 02. Suppose I give a formula in a cell, how to copy the same formula to the successive cells. The sighted person will perform this action by getting a plus symbol at the right end of the cell and drag the mouse to the successive cells. How we can perform this action using keyboard. Apologise me if my questions seems to be silly. Jayachandran. T - Original Message - From: Navin Kumar Gohil navingohil19...@gmail.com To: 'AccessIndia: a list for discussing accessibility and issues concerningthe disabled.' accessindia@accessindia.org.in Sent: Monday, February 23, 2015 8:31 PM Subject: Re: [AI] how to name different worksheets in an excel workbook? Hello, Use Alt,H,O,R command and an edit box will appear. Type the name of the sheet in the edit box you want to rename as and press Enter and then Save file. Trust above helps. Regards Navin Kumar gohil -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Surya Prakash Sharma Sent: 23 February, 2015 8:15 PM To: accessindia Subject: [AI] how to name different worksheets in an excel workbook? Hello all, greetings of the day. please answer the above query. thanks in advance. -- S. P. Sharma Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essind ia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org .in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo
Re: [AI] MS Excel doubts
Hi Jayachandra, Small correction for your first question. Short cut combination is Control plus shift plus S. With Regards K Gopalakrishna Rao Bangalore Mobile: 09945895663 On 2/24/15, Jayachandran1977 optimist@gmail.com wrote: Dear Zujar, Thanks for your mail. Query no. 2 was solved. I got the desired result. Thanks again. Query No. : 1 i.e., getting the list of sheets. I am not getting by pressing ctrl+alt+s. Pls throw some light on this. Iam using office 2007 with JAWS 14. I have one more query. Let it be query no. 3. 3. In a worksheet I want to type Jan 2015, Feb 2015, March 2015 to Dec 2015 in A1 to A12, how to achieve this easily. In this issue also sighted will use mouse dragging. I too used this technic when I was having good sight. Pls reply. Thanks in advance. Jayachandran. T 9677294410 - Original Message - From: Zujar Shabbir Kanchwala zujarbri...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 24, 2015 9:11 PM Subject: Re: [AI] MS Excel doubts Hi Jayachandran, 1. Get list of worksheets in current workbook - CTRL+ALT+S 2. For copying formula: 2.1. Place cursor in source cell (cell containing formula) 2.2. Press CTRL+C to copy 2.3. Press CTRL+G to open GoTo dialog box 2.4. Specify target cell range (cells where formula needs be copied) and hit ENTER 2.5. Press CTRL+V to paste the copied content Believe that's clear! Feel free to revert in case of queries/concerns/suggestions. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 08:03 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: [AI] MS Excel doubts Hello, 01. What is the command to get sheets list in a workbook? 02. Suppose I give a formula in a cell, how to copy the same formula to the successive cells. The sighted person will perform this action by getting a plus symbol at the right end of the cell and drag the mouse to the successive cells. How we can perform this action using keyboard. Apologise me if my questions seems to be silly. Jayachandran. T - Original Message - From: Navin Kumar Gohil navingohil19...@gmail.com To: 'AccessIndia: a list for discussing accessibility and issues concerningthe disabled.' accessindia@accessindia.org.in Sent: Monday, February 23, 2015 8:31 PM Subject: Re: [AI] how to name different worksheets in an excel workbook? Hello, Use Alt,H,O,R command and an edit box will appear. Type the name of the sheet in the edit box you want to rename as and press Enter and then Save file. Trust above helps. Regards Navin Kumar gohil -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Surya Prakash Sharma Sent: 23 February, 2015 8:15 PM To: accessindia Subject: [AI] how to name different worksheets in an excel workbook? Hello all, greetings of the day. please answer the above query. thanks in advance. -- S. P. Sharma Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essind ia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org .in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org .in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com Register at the dedicated
Re: [AI] MS Excel doubts
Ignore my email, both of them have given better options! On 2/25/15, Amar Jain amarjain2...@gmail.com wrote: Query no. 1, minor correction being control shift S as against alt.. Query no. 3, are you talking about normal typing? In that case, it will be F2 for editing current cell, then press enter and edit the next cell likewise. I don't remember, but I had used autofill to get this done once. -- Amar Jain. Website: www.amarjain.com -- Amar Jain. Website: www.amarjain.com Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
Re: [AI] MS Excel doubts
Hi Jayachandran, 1. Get list of worksheets in current workbook - CTRL+ALT+S 2. For copying formula: 2.1. Place cursor in source cell (cell containing formula) 2.2. Press CTRL+C to copy 2.3. Press CTRL+G to open GoTo dialog box 2.4. Specify target cell range (cells where formula needs be copied) and hit ENTER 2.5. Press CTRL+V to paste the copied content Believe that's clear! Feel free to revert in case of queries/concerns/suggestions. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 08:03 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: [AI] MS Excel doubts Hello, 01. What is the command to get sheets list in a workbook? 02. Suppose I give a formula in a cell, how to copy the same formula to the successive cells. The sighted person will perform this action by getting a plus symbol at the right end of the cell and drag the mouse to the successive cells. How we can perform this action using keyboard. Apologise me if my questions seems to be silly. Jayachandran. T - Original Message - From: Navin Kumar Gohil navingohil19...@gmail.com To: 'AccessIndia: a list for discussing accessibility and issues concerningthe disabled.' accessindia@accessindia.org.in Sent: Monday, February 23, 2015 8:31 PM Subject: Re: [AI] how to name different worksheets in an excel workbook? Hello, Use Alt,H,O,R command and an edit box will appear. Type the name of the sheet in the edit box you want to rename as and press Enter and then Save file. Trust above helps. Regards Navin Kumar gohil -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Surya Prakash Sharma Sent: 23 February, 2015 8:15 PM To: accessindia Subject: [AI] how to name different worksheets in an excel workbook? Hello all, greetings of the day. please answer the above query. thanks in advance. -- S. P. Sharma Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essind ia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org .in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org .in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessind ia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com Register at the dedicated
Re: [AI] MS Excel doubts
Dear Zujar, Thanks for your mail. Query no. 2 was solved. I got the desired result. Thanks again. Query No. : 1 i.e., getting the list of sheets. I am not getting by pressing ctrl+alt+s. Pls throw some light on this. Iam using office 2007 with JAWS 14. I have one more query. Let it be query no. 3. 3. In a worksheet I want to type Jan 2015, Feb 2015, March 2015 to Dec 2015 in A1 to A12, how to achieve this easily. In this issue also sighted will use mouse dragging. I too used this technic when I was having good sight. Pls reply. Thanks in advance. Jayachandran. T 9677294410 - Original Message - From: Zujar Shabbir Kanchwala zujarbri...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 24, 2015 9:11 PM Subject: Re: [AI] MS Excel doubts Hi Jayachandran, 1. Get list of worksheets in current workbook - CTRL+ALT+S 2. For copying formula: 2.1. Place cursor in source cell (cell containing formula) 2.2. Press CTRL+C to copy 2.3. Press CTRL+G to open GoTo dialog box 2.4. Specify target cell range (cells where formula needs be copied) and hit ENTER 2.5. Press CTRL+V to paste the copied content Believe that's clear! Feel free to revert in case of queries/concerns/suggestions. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 08:03 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: [AI] MS Excel doubts Hello, 01. What is the command to get sheets list in a workbook? 02. Suppose I give a formula in a cell, how to copy the same formula to the successive cells. The sighted person will perform this action by getting a plus symbol at the right end of the cell and drag the mouse to the successive cells. How we can perform this action using keyboard. Apologise me if my questions seems to be silly. Jayachandran. T - Original Message - From: Navin Kumar Gohil navingohil19...@gmail.com To: 'AccessIndia: a list for discussing accessibility and issues concerningthe disabled.' accessindia@accessindia.org.in Sent: Monday, February 23, 2015 8:31 PM Subject: Re: [AI] how to name different worksheets in an excel workbook? Hello, Use Alt,H,O,R command and an edit box will appear. Type the name of the sheet in the edit box you want to rename as and press Enter and then Save file. Trust above helps. Regards Navin Kumar gohil -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Surya Prakash Sharma Sent: 23 February, 2015 8:15 PM To: accessindia Subject: [AI] how to name different worksheets in an excel workbook? Hello all, greetings of the day. please answer the above query. thanks in advance. -- S. P. Sharma Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essind ia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org .in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org .in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessind ia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject
Re: [AI] MS Excel doubts
Dear Jayachandran, Excel fascinates me and Zujar is an expert on it. Have learnt many things from him. Answer for query 3: You type any date in any format you want and then to get following dates in the following cells just press Control+C at the original date and then by pressing shift+down arrow select range of cells where you want subsequent dates to come up and then just press control+v. Job done. Please note, even for your query no. 2, you can use shift+down or any arrow keys to select and paste the formula. Basically, by pasting any automated formula or format, your selected cells acquire the sequence of the copied formula or format. So, instead of cursor drag use copy and select and paste... Good luck On 2/24/15, Jayachandran1977 optimist@gmail.com wrote: Dear Zujar, Thanks for your mail. Query no. 2 was solved. I got the desired result. Thanks again. Query No. : 1 i.e., getting the list of sheets. I am not getting by pressing ctrl+alt+s. Pls throw some light on this. Iam using office 2007 with JAWS 14. I have one more query. Let it be query no. 3. 3. In a worksheet I want to type Jan 2015, Feb 2015, March 2015 to Dec 2015 in A1 to A12, how to achieve this easily. In this issue also sighted will use mouse dragging. I too used this technic when I was having good sight. Pls reply. Thanks in advance. Jayachandran. T 9677294410 - Original Message - From: Zujar Shabbir Kanchwala zujarbri...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 24, 2015 9:11 PM Subject: Re: [AI] MS Excel doubts Hi Jayachandran, 1. Get list of worksheets in current workbook - CTRL+ALT+S 2. For copying formula: 2.1. Place cursor in source cell (cell containing formula) 2.2. Press CTRL+C to copy 2.3. Press CTRL+G to open GoTo dialog box 2.4. Specify target cell range (cells where formula needs be copied) and hit ENTER 2.5. Press CTRL+V to paste the copied content Believe that's clear! Feel free to revert in case of queries/concerns/suggestions. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 08:03 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: [AI] MS Excel doubts Hello, 01. What is the command to get sheets list in a workbook? 02. Suppose I give a formula in a cell, how to copy the same formula to the successive cells. The sighted person will perform this action by getting a plus symbol at the right end of the cell and drag the mouse to the successive cells. How we can perform this action using keyboard. Apologise me if my questions seems to be silly. Jayachandran. T - Original Message - From: Navin Kumar Gohil navingohil19...@gmail.com To: 'AccessIndia: a list for discussing accessibility and issues concerningthe disabled.' accessindia@accessindia.org.in Sent: Monday, February 23, 2015 8:31 PM Subject: Re: [AI] how to name different worksheets in an excel workbook? Hello, Use Alt,H,O,R command and an edit box will appear. Type the name of the sheet in the edit box you want to rename as and press Enter and then Save file. Trust above helps. Regards Navin Kumar gohil -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Surya Prakash Sharma Sent: 23 February, 2015 8:15 PM To: accessindia Subject: [AI] how to name different worksheets in an excel workbook? Hello all, greetings of the day. please answer the above query. thanks in advance. -- S. P. Sharma Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essind ia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org .in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes
Re: [AI] MS Excel doubts
Dear Zujar, Thanks again. I got the list of sheets. Could anybody throw some light on my query no. 3. Thanks. Jayachandran. T 9677294410 - Original Message - From: Zujar Shabbir Kanchwala zujarbri...@gmail.com To: 'AccessIndia: a list for discussing accessibility and issues concerningthe disabled.' accessindia@accessindia.org.in Sent: Wednesday, February 25, 2015 6:05 AM Subject: Re: [AI] MS Excel doubts Sorry Dear! It's CTRL+SHIFT+S that opens the Move to Worksheet dialog box. If you wanna switch to another sheet then select the desired sheet from the list and press ENTER. You can also make use of CTRL+ALT+PageUp or CTRL+ALT+PageDown to switch between sheets chronologically. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 09:47 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: Re: [AI] MS Excel doubts Dear Zujar, Thanks for your mail. Query no. 2 was solved. I got the desired result. Thanks again. Query No. : 1 i.e., getting the list of sheets. I am not getting by pressing ctrl+alt+s. Pls throw some light on this. Iam using office 2007 with JAWS 14. I have one more query. Let it be query no. 3. 3. In a worksheet I want to type Jan 2015, Feb 2015, March 2015 to Dec 2015 in A1 to A12, how to achieve this easily. In this issue also sighted will use mouse dragging. I too used this technic when I was having good sight. Pls reply. Thanks in advance. Jayachandran. T 9677294410 - Original Message - From: Zujar Shabbir Kanchwala zujarbri...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 24, 2015 9:11 PM Subject: Re: [AI] MS Excel doubts Hi Jayachandran, 1. Get list of worksheets in current workbook - CTRL+ALT+S 2. For copying formula: 2.1. Place cursor in source cell (cell containing formula) 2.2. Press CTRL+C to copy 2.3. Press CTRL+G to open GoTo dialog box 2.4. Specify target cell range (cells where formula needs be copied) and hit ENTER 2.5. Press CTRL+V to paste the copied content Believe that's clear! Feel free to revert in case of queries/concerns/suggestions. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 08:03 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: [AI] MS Excel doubts Hello, 01. What is the command to get sheets list in a workbook? 02. Suppose I give a formula in a cell, how to copy the same formula to the successive cells. The sighted person will perform this action by getting a plus symbol at the right end of the cell and drag the mouse to the successive cells. How we can perform this action using keyboard. Apologise me if my questions seems to be silly. Jayachandran. T - Original Message - From: Navin Kumar Gohil navingohil19...@gmail.com To: 'AccessIndia: a list for discussing accessibility and issues concerningthe disabled.' accessindia@accessindia.org.in Sent: Monday, February 23, 2015 8:31 PM Subject: Re: [AI] how to name different worksheets in an excel workbook? Hello, Use Alt,H,O,R command and an edit box will appear. Type the name of the sheet in the edit box you want to rename as and press Enter and then Save file. Trust above helps. Regards Navin Kumar gohil -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Surya Prakash Sharma Sent: 23 February, 2015 8:15 PM To: accessindia Subject: [AI] how to name different worksheets in an excel workbook? Hello all, greetings of the day. please answer the above query. thanks in advance. -- S. P. Sharma Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essind ia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org .in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ
Re: [AI] MS Excel doubts
Sorry Dear! It's CTRL+SHIFT+S that opens the Move to Worksheet dialog box. If you wanna switch to another sheet then select the desired sheet from the list and press ENTER. You can also make use of CTRL+ALT+PageUp or CTRL+ALT+PageDown to switch between sheets chronologically. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 09:47 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: Re: [AI] MS Excel doubts Dear Zujar, Thanks for your mail. Query no. 2 was solved. I got the desired result. Thanks again. Query No. : 1 i.e., getting the list of sheets. I am not getting by pressing ctrl+alt+s. Pls throw some light on this. Iam using office 2007 with JAWS 14. I have one more query. Let it be query no. 3. 3. In a worksheet I want to type Jan 2015, Feb 2015, March 2015 to Dec 2015 in A1 to A12, how to achieve this easily. In this issue also sighted will use mouse dragging. I too used this technic when I was having good sight. Pls reply. Thanks in advance. Jayachandran. T 9677294410 - Original Message - From: Zujar Shabbir Kanchwala zujarbri...@gmail.com To: accessindia@accessindia.org.in Sent: Tuesday, February 24, 2015 9:11 PM Subject: Re: [AI] MS Excel doubts Hi Jayachandran, 1. Get list of worksheets in current workbook - CTRL+ALT+S 2. For copying formula: 2.1. Place cursor in source cell (cell containing formula) 2.2. Press CTRL+C to copy 2.3. Press CTRL+G to open GoTo dialog box 2.4. Specify target cell range (cells where formula needs be copied) and hit ENTER 2.5. Press CTRL+V to paste the copied content Believe that's clear! Feel free to revert in case of queries/concerns/suggestions. Best Regards, Zujar. -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Jayachandran1977 Sent: 24 February 2015 08:03 PM To: AccessIndia: a list for discussing accessibility and issuesconcerning the disabled. Subject: [AI] MS Excel doubts Hello, 01. What is the command to get sheets list in a workbook? 02. Suppose I give a formula in a cell, how to copy the same formula to the successive cells. The sighted person will perform this action by getting a plus symbol at the right end of the cell and drag the mouse to the successive cells. How we can perform this action using keyboard. Apologise me if my questions seems to be silly. Jayachandran. T - Original Message - From: Navin Kumar Gohil navingohil19...@gmail.com To: 'AccessIndia: a list for discussing accessibility and issues concerningthe disabled.' accessindia@accessindia.org.in Sent: Monday, February 23, 2015 8:31 PM Subject: Re: [AI] how to name different worksheets in an excel workbook? Hello, Use Alt,H,O,R command and an edit box will appear. Type the name of the sheet in the edit box you want to rename as and press Enter and then Save file. Trust above helps. Regards Navin Kumar gohil -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Surya Prakash Sharma Sent: 23 February, 2015 8:15 PM To: accessindia Subject: [AI] how to name different worksheets in an excel workbook? Hello all, greetings of the day. please answer the above query. thanks in advance. -- S. P. Sharma Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essind ia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org .in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list.. Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_acc essindia.org.in Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ To unsubscribe send a message to accessindia-requ...@accessindia.org.in with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org .in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending
