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 >>>> 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 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 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 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.. > > > --- > 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_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.. > 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..
