I would be thankful if you along with other list members can help me in learning v. look-up feature through which one can make various comparison in data base...
On 3/12/16, Himanshu Sahu <[email protected]> wrote: > Dear Zujar, > Again you hit bulls eye, as usual!!! > It works perfectly... > > Now, please tell me how to remove this setting from the workbook/sheet? > > And is their any permanent solution so that all excel documents I work > upon, should have this reading option by default? > > > On 3/12/16, Zujar Shabbir Kanchwala <[email protected]> wrote: >> I believe you're looking for column headings and row titles. Open the >> workbook and perform the following: >> >> 1. Place the cursor on the row that contains column headings. For >> example, row #1, row #5, etc. You may select multiple rows too. >> 2. Press CTRL+ALT+INSERT+C. >> 3. Place the cursor in the column that contains row titles. For >> example, column A, column D, etc. You may select multiple columns too. >> 4. Press CTRL+ALT+INSERT+R. >> >> hth... >> >> On 3/12/16, Himanshu Sahu <[email protected]> wrote: >>> Dear All, >>> Many thanks for your valuable guidance. >>> I've been able to perform series function now but my other query is >>> still unresolved. >>> I had asked: >>> "How to instruct JAWS to read row and column heading while moving >>> through all row and columns respectively in a sheet?" >>> >>> I meant to say that if I am browsing a sheet containing data in >>> multiple rows and columns, what JAWS setting I need to activate so >>> that while browsing through any cell in the sheet, it automatically >>> reads column and row heading along with the value of the particular >>> cell where the focus is? >>> >>> E.G., I've a sheet with the value "uncharged interest" in h column, >>> and in row 55 the heading is "XYZ Pvt. Ltd." >>> my cursor is in G55, and I moved to H55, it should announce the >>> heading of that particular column and row , alongwith the cell value, >>> like: >>> H55 + "column heading "uncharged interest" +row heading "XYZ Pvt. >>> Ltd." +cell value say, 3.1 Lac >>> >>> >>> >>> >>> >>> On 3/12/16, Mahesh Narasimhan <[email protected]> wrote: >>>> Hi friend, >>>> >>>> Just to share in continuation in what Nidhi has just shared. >>>> >>>> In a cell type 1 and select the cells by holding the shift key and >>>> down or right arrow. Then press Alt + e i s and then a dialogue box >>>> would come and in that step value 1 would appear; if you want the >>>> common difference as 1, then press the enter key there itself. If you >>>> want the common difference as 2 or 3 or 4 or 5........ just type the >>>> desired common difference in step value and press the enter key. If >>>> you have kept the common difference as 3, then the series that you >>>> would get as 1, 4, 7...... This is an arithmetic series with initial >>>> value as 1 and with common difference 3. If you wish, you can change >>>> the initial value as per your desire as well. >>>> >>>> Hope I could answer to your query. Enjoy learning! >>>> >>>> -- >>>> "Good friendship is like the relationship between eye & hand! If the >>>> hand is hurt, the eye will cry! & when the eye cries, the hand will >>>> wipe the tears" >>>> >>>> With best regards, >>>> Mahesh Narasimhan >>>> Mobile: +91-9899353960 >>>> E-mail: [email protected] >>>> Skype: maheshdel88 >>>> >>>> >>>> >>>> >>>> On 3/11/16, Himanshu Sahu <[email protected]> wrote: >>>>> Friends, >>>>> Please guide me step by step for execution of following tasks in >>>>> excel: >>>>> >>>>> 1. How to instruct JAWS to read row and column heading while moving >>>>> through all row and columns respectively in a sheet? >>>>> 2. How to insert auto serial Numbers in cells? >>>>> >>>>> I am using JAWS 13 and office 7. >>>>> >>>>> Thanks in anticipation! >>>>> >>>>> >>>>> -- >>>>> Thanks and regards >>>>> Himanshu Sahu >>>>> Reach: 09051055000 >>>>> Skype: himanshu.cute4u >>>>> >>>>> >>>>> 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/[email protected]/ >>>>> >>>>> To unsubscribe send a message to >>>>> [email protected] >>>>> 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/[email protected]/ >>>> >>>> To unsubscribe send a message to >>>> [email protected] >>>> 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.. >>>> >>> >>> >>> -- >>> Thanks and regards >>> Himanshu Sahu >>> Reach: 09051055000 >>> Skype: himanshu.cute4u >>> >>> >>> 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/[email protected]/ >>> >>> To unsubscribe send a message to >>> [email protected] >>> 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.. >>> >> >> >> -- >> Best Regards, >> Zujar... >> >> An optimist laughs to forget, whereas a pessimist forgets to laugh! >> >> >> 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/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> 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.. >> > > > -- > Thanks and regards > Himanshu Sahu > Reach: 09051055000 > Skype: himanshu.cute4u > -- Thanks and regards Himanshu Sahu Reach: 09051055000 Skype: himanshu.cute4u 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/[email protected]/ To unsubscribe send a message to [email protected] 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..
