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, >>> 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.. > -- *************** "I am only one, but I am one. I cannot do everything, but I can do something. And because I cannot do everything, I will not refuse to do the something I can do. What I can do, I should do. And what I should do, by the grace of God, I will do." EDWARD EVERETT HALE. 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..
