Re: [AI] Excel query
Hi Krishna Step1 Press control +g and type cell range that you want to format for exam ple: a1:h29 Step2 go to the ribbon tab by pressing alt +h then use tab key until you hear styless grouping conditional formatting then press spacebar. Step3 use down arrow key and select format cells based on rules then use down arrow key and choose an appropreate option. On 1/4/23, Krishna Bodawala wrote: > Hi Minar, > > How can i do that? > > On 1/2/23, Minar Singh wrote: >> Hi Krishna, >> >> Apply conditional formatting based on text in a cell. This technique >> will 100 % work as per your expectation. >> >> On 1/2/23, Krishna Bodawala wrote: >>> Hello members, >>> >>> Happy New Year to all. >>> I have a small query regarding Excel. >>> I am working in sheet, where the column have red, green, orange >>> highlighted >>> cels. I need only the cells which are green highlighted, how can I >>> eliminate >>> the other cels row which are highlighted Red? >>> >>> Sincerely, >>> >>> Krishna Bodawala >>> +1(551)-263-5182 >>> >>> -- >>> 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.. >>> >>> >>> Search for old postings at: >>> http://www.mail-archive.com/accessindia@accessindia.org.in/ >>> --- >>> You received this message because you are subscribed to the Google >>> Groups >>> "AccessIndia" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an >>> email to accessindia+unsubscr...@accessindia.org.in. >>> To view this discussion on the web visit >>> https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/1DD07A13-2F89-45A8-A427-D7EBBFA0B84A%40gmail.com. >>> >> >> >> -- >> What’s most important is to put the person first, the disability >> second Because we all are people first. >> >> -- >> 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.. >> >> >> Search for old postings at: >> http://www.mail-archive.com/accessindia@accessindia.org.in/ >> --- >> You received this message because you are subscribed to the Google Groups >> "AccessIndia" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to accessindia+unsubscr...@accessindia.org.in. >> To view this discussion on the web visit >> https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CALLUjUZ_U1ZxWxDFtmdJL-zt%3DyDdUcE49gZD6sA8rq_Yf6zqgQ%40mail.gmail.com. >> > > > -- > KRISHNA BODAWALA > +(1)551-263-5182 > > -- > 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.. > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > --- > You received this message because you are subscribed to the Google Groups > "AccessIndia" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to accessindia+unsubscr...@accessindia.org.in. > To view this discussion on the web visit > https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CAGA0Pc5ApBJyo%3DEFaqwRXtChJJ3%2Bk7Z%2BJvbkLt%2BRNqcxeA-1Xg%40mail.gmail.com. > -- What’s most important is to put the person first, the disability second Because we all are people first. -- 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.. Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ --- You received this message because you are subscribed to the Google Groups "AccessIndia" group. To unsubscribe from this group and stop receiving emails from it, send an email to accessindia+unsubscr...@accessindia.org.in. To view this discussion on the web visit https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CALLUjUa0CbVCUs4T_MWE4zMEycQUkv3NF6D2Sv1uQxV83J3Odw%40mail.gmail.com.
Re: [AI] Excel query
Hi Minar, How can i do that? On 1/2/23, Minar Singh wrote: > Hi Krishna, > > Apply conditional formatting based on text in a cell. This technique > will 100 % work as per your expectation. > > On 1/2/23, Krishna Bodawala wrote: >> Hello members, >> >> Happy New Year to all. >> I have a small query regarding Excel. >> I am working in sheet, where the column have red, green, orange >> highlighted >> cels. I need only the cells which are green highlighted, how can I >> eliminate >> the other cels row which are highlighted Red? >> >> Sincerely, >> >> Krishna Bodawala >> +1(551)-263-5182 >> >> -- >> 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.. >> >> >> Search for old postings at: >> http://www.mail-archive.com/accessindia@accessindia.org.in/ >> --- >> You received this message because you are subscribed to the Google Groups >> "AccessIndia" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to accessindia+unsubscr...@accessindia.org.in. >> To view this discussion on the web visit >> https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/1DD07A13-2F89-45A8-A427-D7EBBFA0B84A%40gmail.com. >> > > > -- > What’s most important is to put the person first, the disability > second Because we all are people first. > > -- > 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.. > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > --- > You received this message because you are subscribed to the Google Groups > "AccessIndia" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to accessindia+unsubscr...@accessindia.org.in. > To view this discussion on the web visit > https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CALLUjUZ_U1ZxWxDFtmdJL-zt%3DyDdUcE49gZD6sA8rq_Yf6zqgQ%40mail.gmail.com. > -- KRISHNA BODAWALA +(1)551-263-5182 -- 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.. Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ --- You received this message because you are subscribed to the Google Groups "AccessIndia" group. To unsubscribe from this group and stop receiving emails from it, send an email to accessindia+unsubscr...@accessindia.org.in. To view this discussion on the web visit https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CAGA0Pc5ApBJyo%3DEFaqwRXtChJJ3%2Bk7Z%2BJvbkLt%2BRNqcxeA-1Xg%40mail.gmail.com.
Re: [AI] Excel query
Hi Krishna, Apply conditional formatting based on text in a cell. This technique will 100 % work as per your expectation. On 1/2/23, Krishna Bodawala wrote: > Hello members, > > Happy New Year to all. > I have a small query regarding Excel. > I am working in sheet, where the column have red, green, orange highlighted > cels. I need only the cells which are green highlighted, how can I eliminate > the other cels row which are highlighted Red? > > Sincerely, > > Krishna Bodawala > +1(551)-263-5182 > > -- > 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.. > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > --- > You received this message because you are subscribed to the Google Groups > "AccessIndia" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to accessindia+unsubscr...@accessindia.org.in. > To view this discussion on the web visit > https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/1DD07A13-2F89-45A8-A427-D7EBBFA0B84A%40gmail.com. > -- What’s most important is to put the person first, the disability second Because we all are people first. -- 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.. Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ --- You received this message because you are subscribed to the Google Groups "AccessIndia" group. To unsubscribe from this group and stop receiving emails from it, send an email to accessindia+unsubscr...@accessindia.org.in. To view this discussion on the web visit https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CALLUjUZ_U1ZxWxDFtmdJL-zt%3DyDdUcE49gZD6sA8rq_Yf6zqgQ%40mail.gmail.com.
Re: [AI] Excel query
Hello sir, I don’t want to apply filters. The sheet already contains cell highlighted in red, green, and orange colour. I need only those cells which are highlighted green, so how can I eliminate the other cells which are not used to me. I know the Keystroke insert plus F to check the font colour in a cell, but I was thinking of some other way, so I can directly eliminate the cel Rose which are not use to me. Thank you, Krishna Bodawala +1(551)-263-5182 > On Jan 2, 2023, at 19:00, Khandu Bhandare wrote: > > Hello sir, > You can apply the color filter for this. > To check the color you can keep the focus on the particular cell and > press insert alfa numeric 5 and accordingly you will be apply the > filter for the particular color. > > >> On 1/2/23, Krishna Bodawala wrote: >> Hello members, >> >> Happy New Year to all. >> I have a small query regarding Excel. >> I am working in sheet, where the column have red, green, orange highlighted >> cels. I need only the cells which are green highlighted, how can I eliminate >> the other cels row which are highlighted Red? >> >> Sincerely, >> >> Krishna Bodawala >> +1(551)-263-5182 >> >> -- >> 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.. >> >> >> Search for old postings at: >> http://www.mail-archive.com/accessindia@accessindia.org.in/ >> --- >> You received this message because you are subscribed to the Google Groups >> "AccessIndia" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to accessindia+unsubscr...@accessindia.org.in. >> To view this discussion on the web visit >> https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/1DD07A13-2F89-45A8-A427-D7EBBFA0B84A%40gmail.com. >> > > > -- > “challenge the challenges!” > > Regards, > Khandu Bhandare| > Assistant Manager/Special Trainer|Centre of Excellence for persons > with disabilities > M: +91 7666206653 > kha...@sbifoundation.co.in,khandu.bhand...@sbi.co.in,bhandarekhand...@gmail.com > www.sbifoundation.in > SBI Foundation | Service Beyond Banking... > > 35, Ground Floor, The Arcade, World Trade Centre, Cuffe Parade, Mumbai -45 > > -- > 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.. > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > --- > You received this message because you are subscribed to the Google Groups > "AccessIndia" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to accessindia+unsubscr...@accessindia.org.in. > To view this discussion on the web visit > https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CA%2BkFfrrdfEQ%3DnktGO1SSBOyAFndHNWw73OgFagt%2Bv1-gTYaLKw%40mail.gmail.com. -- 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.. Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ --- You received this message because you are subscribed to the Google Groups "AccessIndia" group. To unsubscribe from this group and stop receiving emails from it, send an email to accessindia+unsubscr...@accessindia.org.in. To view this discussion on the web visit https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/E6655DA6-0EC9-41FB-AD2F-E1E9D6121B3D%40gmail.com.
Re: [AI] Excel query
Hello sir, You can apply the color filter for this. To check the color you can keep the focus on the particular cell and press insert alfa numeric 5 and accordingly you will be apply the filter for the particular color. On 1/2/23, Krishna Bodawala wrote: > Hello members, > > Happy New Year to all. > I have a small query regarding Excel. > I am working in sheet, where the column have red, green, orange highlighted > cels. I need only the cells which are green highlighted, how can I eliminate > the other cels row which are highlighted Red? > > Sincerely, > > Krishna Bodawala > +1(551)-263-5182 > > -- > 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.. > > > Search for old postings at: > http://www.mail-archive.com/accessindia@accessindia.org.in/ > --- > You received this message because you are subscribed to the Google Groups > "AccessIndia" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to accessindia+unsubscr...@accessindia.org.in. > To view this discussion on the web visit > https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/1DD07A13-2F89-45A8-A427-D7EBBFA0B84A%40gmail.com. > -- “challenge the challenges!” Regards, Khandu Bhandare| Assistant Manager/Special Trainer|Centre of Excellence for persons with disabilities M: +91 7666206653 kha...@sbifoundation.co.in,khandu.bhand...@sbi.co.in,bhandarekhand...@gmail.com www.sbifoundation.in SBI Foundation | Service Beyond Banking... 35, Ground Floor, The Arcade, World Trade Centre, Cuffe Parade, Mumbai -45 -- 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.. Search for old postings at: http://www.mail-archive.com/accessindia@accessindia.org.in/ --- You received this message because you are subscribed to the Google Groups "AccessIndia" group. To unsubscribe from this group and stop receiving emails from it, send an email to accessindia+unsubscr...@accessindia.org.in. To view this discussion on the web visit https://groups.google.com/a/accessindia.org.in/d/msgid/accessindia/CA%2BkFfrrdfEQ%3DnktGO1SSBOyAFndHNWw73OgFagt%2Bv1-gTYaLKw%40mail.gmail.com.
Re: [AI] Excel Query
vlookup has four arguments. 1. first argument you have to give which column you have to use for searching similar value in other database. 2. second argument is the row and column range of the destination data sheet in excel. 3. third argument is after finding the exact match, what related record you have to display from that match. for example, himanshu is the name you have found a match in another database. then you have to display himanshu's mark in a particular subject which may be in third position from your name. 4. give false. On 3/12/16, Himanshu Sahu wrote: > 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 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 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 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 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: maheshde...@gmail.com > Skype: maheshdel88 > > > > > On 3/11/16, Himanshu Sahu 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/accessindia@accessindia.org.in/ >> >> To unsubscribe send a message to >> accessindia-requ...@accessindia.org.in >> with
Re: [AI] Excel Query
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 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 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 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 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: maheshde...@gmail.com Skype: maheshdel88 On 3/11/16, Himanshu Sahu 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/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 /
Re: [AI] Excel Query
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 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 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 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: maheshde...@gmail.com >>> Skype: maheshdel88 >>> >>> >>> >>> >>> On 3/11/16, Himanshu Sahu 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/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 m
Re: [AI] Excel Query
go to the headers columns where headings are available. press insert+shift+c and insert+shift+r On 3/12/16, Himanshu Sahu 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 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: maheshde...@gmail.com >> Skype: maheshdel88 >> >> >> >> >> On 3/11/16, Himanshu Sahu 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/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.. >> > > > -- > 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
Re: [AI] Excel Query
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 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 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: maheshde...@gmail.com >> Skype: maheshdel88 >> >> >> >> >> On 3/11/16, Himanshu Sahu 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/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.. >> > > > -- > Th
Re: [AI] Excel Query
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 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: maheshde...@gmail.com > Skype: maheshdel88 > > > > > On 3/11/16, Himanshu Sahu 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/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.. > -- 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/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_ac
Re: [AI] Excel Query
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: maheshde...@gmail.com Skype: maheshdel88 On 3/11/16, Himanshu Sahu 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/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..
Re: [AI] Excel Query
On 3/12/16, Him Prasad Gautam wrote: > For auto numbering, do > * type 1 in that cell from which you want to have auto numbering begin. > * move one cell down. > * type the equal sign. > * press up arrow. > * type plus sign and 1 > * press enter. > * Copy the cell (press control + c) > * paste the formula up to that range you want to have auto numbers be > written automatically. > Second method > * decide the row number from which you want auto numbers begin. > * type the formula in that cell. > = row() minus the row number just above the cell in which the formula > is being written. > * copy the formula and paste up to that range of your desire. > > > On 3/11/16, Surya Prakash wrote: >> Hi, >> perhaps the commands are: >> insert + shift + alt + c or r, respectively. >> >> Sent with AquaMail for Android >> http://www.aqua-mail.com >> >> >> On March 11, 2016 9:37:58 PM Aravind R >> wrote: >> >>> go to the column and row where headers are placed. >>> press insert+shift+c for setting them as column title and press >>> insert+shift+r for setting row title. >>> >>> On 3/11/16, Himanshu Sahu 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/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.. >>> >>> >>> -- >>> nothing is difficult unless you make it appear so. >>> >>> r. aravind, >>> >>> Assistant manager >>> Department of sales >>> bank of baroda retail loan factory, Chennai. >>> mobile no: +91 9940369593, 9710945613. >>> email id : aravind_...@yahoo.com, aravind.andhrab...@gmail.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.. >> > > > -- > Him Prasad Gautam > Kathmandu, Nepal > > > 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.i
Re: [AI] Excel Query
For auto numbering, do * type 1 in that cell from which you want to have auto numbering begin. * move one cell down. * type the equal sign. * press up arrow. * type plus sign and 1 * press enter. * Copy the cell (press control + c) * paste the formula up to that range you want to have auto numbers be written automatically. Second method * decide the row number from which you want auto numbers begin. * type the formula in that cell. = row() minus the row number just above the cell in which the formula is being written. * copy the formula and paste up to that range of your desire. On 3/11/16, Surya Prakash wrote: > Hi, > perhaps the commands are: > insert + shift + alt + c or r, respectively. > > Sent with AquaMail for Android > http://www.aqua-mail.com > > > On March 11, 2016 9:37:58 PM Aravind R > wrote: > >> go to the column and row where headers are placed. >> press insert+shift+c for setting them as column title and press >> insert+shift+r for setting row title. >> >> On 3/11/16, Himanshu Sahu 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/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.. >>> >> >> >> -- >> nothing is difficult unless you make it appear so. >> >> r. aravind, >> >> Assistant manager >> Department of sales >> bank of baroda retail loan factory, Chennai. >> mobile no: +91 9940369593, 9710945613. >> email id : aravind_...@yahoo.com, aravind.andhrab...@gmail.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.. > -- Him Prasad Gautam Kathmandu, Nepal 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
Re: [AI] Excel Query
Hi, perhaps the commands are: insert + shift + alt + c or r, respectively. Sent with AquaMail for Android http://www.aqua-mail.com On March 11, 2016 9:37:58 PM Aravind R wrote: go to the column and row where headers are placed. press insert+shift+c for setting them as column title and press insert+shift+r for setting row title. On 3/11/16, Himanshu Sahu 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/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.. -- nothing is difficult unless you make it appear so. r. aravind, Assistant manager Department of sales bank of baroda retail loan factory, Chennai. mobile no: +91 9940369593, 9710945613. email id : aravind_...@yahoo.com, aravind.andhrab...@gmail.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..
Re: [AI] Excel Query
go to the column and row where headers are placed. press insert+shift+c for setting them as column title and press insert+shift+r for setting row title. On 3/11/16, Himanshu Sahu 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/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.. > -- nothing is difficult unless you make it appear so. r. aravind, Assistant manager Department of sales bank of baroda retail loan factory, Chennai. mobile no: +91 9940369593, 9710945613. email id : aravind_...@yahoo.com, aravind.andhrab...@gmail.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] excel query.
Thank you. Got it. Sent with AquaMail for Android http://www.aqua-mail.com On February 21, 2016 7:32:15 PM Zujar Shabbir Kanchwala wrote: Hi, Probably, the cell is formatted to display 1 decimal place. You may check the format in the Format Cells dialog box under the Number tab. If the Category list box shows 'Number' and Decimal Places edit combo box displays 1 then you may want to change this to either of the following: 1. Increase the number of decimal places in the respective edit combo box. 2. Switch to General' format by selecting the same in Category list box. hth... On 2/21/16, Surya Prakash Sharma wrote: Hello Accessindians, greetings of the day. I am facing a strange issue with excel. excel automatically rounds off the figures in some cells. for example, 6.18 automatically becomes 6.2 or 13.39 becomes 13.4. i have not inserted any formula to round off the figures. i tried to edit the figure but found the original figures while editing i.e., 6.18 or 13.39. but the figure changed again after pressing "enter." so, please suggest the remedy. with best regards, -- S. P. Sharma Lecturer, Political Science Govt. College Kaladera Jaipur 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.. -- 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/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..
Re: [AI] excel query.
Hi, Probably, the cell is formatted to display 1 decimal place. You may check the format in the Format Cells dialog box under the Number tab. If the Category list box shows 'Number' and Decimal Places edit combo box displays 1 then you may want to change this to either of the following: 1. Increase the number of decimal places in the respective edit combo box. 2. Switch to General' format by selecting the same in Category list box. hth... On 2/21/16, Surya Prakash Sharma wrote: > Hello Accessindians, greetings of the day. > I am facing a strange issue with excel. excel automatically rounds off > the figures in some cells. for example, 6.18 automatically becomes 6.2 > or 13.39 becomes 13.4. i have not inserted any formula to round off > the figures. i tried to edit the figure but found the original figures > while editing i.e., 6.18 or 13.39. but the figure changed again after > pressing "enter." > so, please suggest the remedy. > > with best regards, > -- > S. P. Sharma > Lecturer, Political Science > Govt. College Kaladera > Jaipur > > > 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.. > -- 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/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] Excel query
=IF(R8="cl", O8, "other value if false") Best Regards, Zujar… An optimist laughs to forget and a pessimist forgets to laugh! -Original Message- From: AccessIndia [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Mukesh Sent: Saturday, April 06, 2013 10:24 PM To: Access India Subject: [AI] Excel query Hello friends, I have a problem in the following formula. Please suggest correction. If cell ‘r8’ equals “cl” the value of cell ‘o8’ should come in cell ‘i8’ automatically by formula. Thank you. Regards Mukesh Baviskar Mobile: 9403161157 Skype id: mukeshbaviskar Blog: http://mukeshbaviskar.blogspot.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 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
Re: [AI] Excel query
=IF(A2 >= D2, CONCATENATE("Sanctioned - days with pay(", A2, ")"),
CONCATENATE("Sanctioned - days without pay (", D2 - A2, ")"))
On 3/30/13, Mukesh wrote:
> Hello Friends,
> I have created a leave register and required a macro coding/formula to get
> the appropriate remark in remark column. My query is as follows:
> column ‘a2’ leave credited
> column ‘d’ days required
> column ‘f’ remark
>
> Result condition:
>
> If days required are > leave credited the remark should be: sanctioned –
> days with pay (leave credited) and – days without pay (days required – leave
> credited)
>
> Thank you.
>
> Regards
>
> Mukesh Baviskar
> Mobile: 9403161157
> Skype id: mukeshbaviskar
> Blog:
> http://mukeshbaviskar.blogspot.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
>
>
--
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/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
Re: [AI] Excel query, very urgent
Do a "Paste special" instead of "paste" and select "value only". You will get the "paste special" command in the right click context menu and under the edit menu in excel. -Manish -Original Message- From: accessindia-boun...@accessindia.org.in [mailto:accessindia-boun...@accessindia.org.in] On Behalf Of Vamshi. G Sent: Wednesday, February 09, 2011 8:32 PM To: accessindia Subject: [AI] Excel query, very urgent Hi friends, When I copy a cell which has a sum formula and paste it in another sheet, Jaws is saying "number ref" instead of the actual number. I want the actual number to be pasted. Guidance required very urgently. -- 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 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] Excel query, very urgent
Hello Vamshi, After coping the cell please use paste special command. Then select values--Press enter. Done! The actual value will appear in that particular cell instead of formula. Try it. Regards Mukesh Baviskar Mobile: 9403161157 -- From: "Vamshi. G" Sent: Wednesday, February 09, 2011 8:32 PM To: "accessindia" Subject: [AI] Excel query, very urgent Hi friends, When I copy a cell which has a sum formula and paste it in another sheet, Jaws is saying "number ref" instead of the actual number. I want the actual number to be pasted. Guidance required very urgently. -- 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 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] Excel query, very urgent
Ensure that the cell coordinates in the formula pasted at the new location do not overlap. This error normally occurs when you paste the formula into a cell which is also included in the formula's calculation. In other words, if you are adding up A 6 to A10 and paste the formula into A10, you are likely to get this error. Geetha - Original Message - From: "Vamshi. G" To: "accessindia" Sent: Wednesday, February 09, 2011 3:02 PM Subject: [AI] Excel query, very urgent Hi friends, When I copy a cell which has a sum formula and paste it in another sheet, Jaws is saying "number ref" instead of the actual number. I want the actual number to be pasted. Guidance required very urgently. -- 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 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] EXCEL QUERY
dear vikas when u write any formula u give reference of the cells. am i right, so there are three type of references in excel. 1. relative reference 2. absolute reference 3. mixed reference the reference which we use is relative reference. like if there is marks of english nd maths in column A and column B and in column C there is total of column A and Column B values. there is heading english in A1, maths in B1 and Total in C1. suppose there is data of 10 students. we write formula =sum(a2:b2) in c2 and press enter. total of a2 and b2 will appear in cell c2. so we copy the formula of c2 by pressing control plus C and press shift and down arrow and select upto c11 and press contro plus v and press enter. now if we navigate in c column. when our cursor reach on c2 it will say c2 has formula. press control plus F2 it will speak the foumula. it will say =sum(a2:b2). once press down arrow our cursor moves to c3. press here control plus F2, it will say =sum(a3:b3). vikas it is relative referencing. because the cell reference in the copied cells is automatically changed. we copied the formula one cell down so it also change the refence one cell down from a2:b2 to a3:b3 for c3 and a4:b4 for c4 and for other cells also. i think u know it already. now we will talk about absoulte referencing. give the heading as salary, increment, new salary, percent in A1, B1. C1 and D1. in A column employees salary is entered from a2 to a10. in D2 10 in entered, we assume that we want to know that how much will be the new salary if we increase there salary by 10 percent. when we enter the formula in b2 for calculating 10 percent of salary. we can do it in folowing ways. =a2*10/100 and press enter. it will calculate 10 percent of a2. copy this formula and paste it upto b10. it is relative referencing. we mentioned here 10, it is hard coded, but if we want to provide how much percent we want to calculate through cell reference we can do this as following: first try it: write =a2*d2/100 in b2 and press enter. copy it and paste it from b3 to b10. u see there is correct output in b2 but not in b3 to b10. because in b3 the formula chaged to =a3*d3/100. there is no value in d3 so the output is 0 from b3 to b10 cells. but if we want the correct output by using cell reference then we have to use absoulute referencing. write =a2*$d$2/100 in b2 and press enter. copy it and paste it from b2 to b10. now it will give u the correct result. Depending on the task you want to perform in Excel, you can use either relative cell references, which are references to cells relative to the position of the formula, or absolute references, which are cell references that always refer to cells in a specific location. If a dollar sign precedes the letter and/or number, such as $A$1, the column and/or row reference is absolute. Relative references automatically adjust when you copy them, and absolute references don't. so this is absoulte referencing. in mixed referencing if we preedes the letter with dollar and not precede the number with the dollar or we preceded the number with the dollar and not the letter then it is mixed referencing. like $a1 here a is fixed and a$1 here 1 is fixed. Regards Ajay Sharma On 7/8/06, Vikas Kapoor <[EMAIL PROTECTED]> wrote: > > Dear Members, > I know here on this list there are many excel specialists. Though I don't > have any mastery over excel, I use this application for a very limited > purposes like preparing the internal assessment for my college students and > I find it very useful for this purpose. I just wanted to know one very > minute clarification, that is, how do we restrict the formula results to > only two digits after dot. Suppose, after some calculations, if the result > displayed is, 75.318654, how can we restrict to only two digits, that is, > 75.32. My sighted friends do this just at a click of one mouse command, > but when I try to access the same with the jaws, or pc cursor, it is not > visible. > Regards, > Vikas Kapoor, > MSN ID: > [EMAIL PROTECTED] > Yahoo ID: > [EMAIL PROTECTED] > Skype ID: dl_vikas > Mobile: (+91) 9891098137. > To unsubscribe send a message to [EMAIL PROTECTED] 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 > -- Ajay Sharma Delhi 9899326670 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
Re: [AI] EXCEL QUERY
Dear Vikas, If you want to copy a formula from a cell to a range of cells, do the following: 1. Be in the cell, whose formula you want to copy and press control + c. 2. To select the range of cells, where you want to copy, be in the north west corner and pressing shift and right arrow or down arrow, go to the south east corner and release the keys. 3. do control + v and your job is done. 4. please note that when you copy a formula, the input cells will change. For example, if you copy a1+b1 ,which you had defined in c1, when you copy from c2 to c10, the input cells will also change as a2+b2 and a10+b10. If you want a particular cell address not to change, put $ in the formula. For example, if you say $a1 and copy from b1 to n1, the cell address will not change, If you put a$1, then, when you copy from c2 to c10, the cell address will not change. If you put $a$1, the cell address will never change, where ever you copy. I hope this will help you. regards - Original Message - From: "Vikas Kapoor" <[EMAIL PROTECTED]> To: Sent: Sunday, July 09, 2006 12:30 AM Subject: Re: [AI] EXCEL QUERY > Thanks Sameer once again but this didn't solve the problem this time. By > doing this, it is pasting only in the cell where I'm standing, it is not > dragging for all 60 students. That simply means each time I have to repeat > my action. If this be the case, then what is the difference between paste > and paste special? Another thing that I would like to ask is that when I > convert to 2 decibels, my result comes .1% less than the actual result. > However, when in the option, in the calculation tab, I check the box, > which > says "precision as displayed", then the accurate result comes but before I > press the ok button after clearing that box, it says, "all data will > permanently lose accuracy!". What does that mean? In my case, instead of > losing, it is giving me more precise accuracy, ha ha ha! > Regards, > Vikas Kapoor, > MSN ID: > [EMAIL PROTECTED] > Yahoo ID: > [EMAIL PROTECTED] > Skype ID: dl_vikas > Mobile: (+91) 9891098137. > - Original Message ----- > From: "sameer latey" <[EMAIL PROTECTED]> > To: > Sent: Saturday, July 08, 2006 10:31 PM > Subject: Re: [AI] EXCEL QUERY > > >> >> Try the following to copy and paste the same formula >> in multiple cells. >> >> 1. Place your focus on the cell from which you want to >> copy the formula and the number formats. >> 2. Press Ctrl+C to copy. >> 3. Select the cells in which you want to paste. >> 4. Go to Edit on the Menu Bar and arrow down to Paste >> Special. Press enter on the Paste Special option. >> 5. A dialog box will open containing a series of radio >> buttons. Arrow down through the radio buttons till you >> come to the button titled "Formulas and Number >> Formats". >> 6. Select the Formulas and Number Formats radio button >> and press OK. >> >> This should paste the formula and the number format of >> 2 decimal places in all the destination cells. >> >> Regards >> Sameer >> --- Vikas Kapoor <[EMAIL PROTECTED]> wrote: >> >>> Thanks a lot, Ajay and Sameer for such a prompt >>> response. My problem is now >>> completely solved. One more thing please, if we have >>> to copy the same >>> formula for every student, we generally do by copy >>> and paste command, while >>> the sighted people would do just at a click of a >>> mouse button for all the >>> students, no matter hundreds of them, is there any >>> way through jaws to drag >>> the same way as it is done by mouse? >>> Regards, >>> Vikas Kapoor, >>> MSN ID: >>> [EMAIL PROTECTED] >>> Yahoo ID: >>> [EMAIL PROTECTED] >>> Skype ID: dl_vikas >>> Mobile: (+91) 9891098137. >>> - Original Message - >>> From: "ajay sharma" <[EMAIL PROTECTED]> >>> To: >>> Sent: Saturday, July 08, 2006 5:38 PM >>> Subject: Re: [AI] EXCEL QUERY >>> >>> >>> > hi vikas myself ajay sharma from blind relief >>> association, delhi >>> > >>> > select the cells in which u have entered the >>> formula and then go to format >>> > menu. in format menu choose cells... then choose >>> number tab by pressing >>> > control plus tab. in number tab press tab once >>> then your cursor goes to >>> > category list. in category list select number by >>> pressing down arrow. >>> > after >>> > selecting number press tab it will jump to the &g
Re: [AI] EXCEL QUERY
Hi Vikas, The method explained will solve the problem in part only. E.g. if the number is 23.477, the format option will have it displayed as 23.48, but in all calculations it will be used as before. To round the number as 23.48 use the following method: Suppose the given number is in cell A1, and you want the rounded value in cell b1. Type the following in cell B1: =round(a1) and press enter. To round the marks of entire class displayed in cells a1 to a50, just copy the contents of cell B1 and paste in cells b2 to b50. Thanks, Anil - Original Message - From: "sameer latey" <[EMAIL PROTECTED]> To: Sent: 08 July, 2006 5:50 PM Subject: Re: [AI] EXCEL QUERY > > Try the following steps and see if they solve your > problem. > > 1. In Excel, place your focus on the cell for which > you want to restrict the result. > 2. Press Ctrl+1 to open the Cell Format dialog. This > same dialog can also be accessed from the Format menu. > 3. Tab to the list box containing the various choices > like General, Currency, time, date etc. Arrow down to > Number and tab to the sub options. > 4. You will find an Edit box where you can specify the > number of decimal places. Set this to 2 and tab over > to OK and press it. > > The result will now be restricted to 2 decimal places. > You can do this for an entire row/ column by selecting > the entire row/ column and repeating the above steps. > > Regards > Sameer > --- Vikas Kapoor <[EMAIL PROTECTED]> wrote: > > > Dear Members, > > I know here on this list there are many excel > > specialists. Though I don't have any mastery over > > excel, I use this application for a very limited > > purposes like preparing the internal assessment for > > my college students and I find it very useful for > > this purpose. I just wanted to know one very minute > > clarification, that is, how do we restrict the > > formula results to only two digits after dot. > > Suppose, after some calculations, if the result > > displayed is, 75.318654, how can we restrict to only > > two digits, that is, 75.32. My sighted friends do > > this just at a click of one mouse command, but when > > I try to access the same with the jaws, or pc > > cursor, it is not visible. > > Regards, > > Vikas Kapoor, > > MSN ID: > > [EMAIL PROTECTED] > > Yahoo ID: > > [EMAIL PROTECTED] > > Skype ID: dl_vikas > > Mobile: (+91) 9891098137. > > 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 > > > > > __ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > > 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 > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.394 / Virus Database: 268.9.10/383 - Release Date: 07-07-06 > > 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
Re: [AI] EXCEL QUERY
The Paste function will paste everything from the source cell to the destinationn cell including formulas and formats. Using the Paste Special function, you can choose only a certain characteristic from the source cell to the destination cell. For example, you can use the Paste Special command to paste only formats, or only formulas while retaining the original formatting of the destination cell. For the 60 students, select the entire range of cells where you want to paste and then do the Paste Special. As regards the Precision calculation, I will have to put on my thinking cap and do some investigation. Regards Sameer --- Vikas Kapoor <[EMAIL PROTECTED]> wrote: > Thanks Sameer once again but this didn't solve the > problem this time. By > doing this, it is pasting only in the cell where I'm > standing, it is not > dragging for all 60 students. That simply means each > time I have to repeat > my action. If this be the case, then what is the > difference between paste > and paste special? Another thing that I would like > to ask is that when I > convert to 2 decibels, my result comes .1% less than > the actual result. > However, when in the option, in the calculation tab, > I check the box, which > says "precision as displayed", then the accurate > result comes but before I > press the ok button after clearing that box, it > says, "all data will > permanently lose accuracy!". What does that mean? In > my case, instead of > losing, it is giving me more precise accuracy, ha ha > ha! > Regards, > Vikas Kapoor, > MSN ID: > [EMAIL PROTECTED] > Yahoo ID: > [EMAIL PROTECTED] > Skype ID: dl_vikas > Mobile: (+91) 9891098137. > ----- Original Message - > From: "sameer latey" <[EMAIL PROTECTED]> > To: > Sent: Saturday, July 08, 2006 10:31 PM > Subject: Re: [AI] EXCEL QUERY > > > > > > Try the following to copy and paste the same > formula > > in multiple cells. > > > > 1. Place your focus on the cell from which you > want to > > copy the formula and the number formats. > > 2. Press Ctrl+C to copy. > > 3. Select the cells in which you want to paste. > > 4. Go to Edit on the Menu Bar and arrow down to > Paste > > Special. Press enter on the Paste Special option. > > 5. A dialog box will open containing a series of > radio > > buttons. Arrow down through the radio buttons till > you > > come to the button titled "Formulas and Number > > Formats". > > 6. Select the Formulas and Number Formats radio > button > > and press OK. > > > > This should paste the formula and the number > format of > > 2 decimal places in all the destination cells. > > > > Regards > > Sameer > > --- Vikas Kapoor <[EMAIL PROTECTED]> wrote: > > > >> Thanks a lot, Ajay and Sameer for such a prompt > >> response. My problem is now > >> completely solved. One more thing please, if we > have > >> to copy the same > >> formula for every student, we generally do by > copy > >> and paste command, while > >> the sighted people would do just at a click of a > >> mouse button for all the > >> students, no matter hundreds of them, is there > any > >> way through jaws to drag > >> the same way as it is done by mouse? > >> Regards, > >> Vikas Kapoor, > >> MSN ID: > >> [EMAIL PROTECTED] > >> Yahoo ID: > >> [EMAIL PROTECTED] > >> Skype ID: dl_vikas > >> Mobile: (+91) 9891098137. > >> - Original Message - > >> From: "ajay sharma" <[EMAIL PROTECTED]> > >> To: > >> Sent: Saturday, July 08, 2006 5:38 PM > >> Subject: Re: [AI] EXCEL QUERY > >> > >> > >> > hi vikas myself ajay sharma from blind relief > >> association, delhi > >> > > >> > select the cells in which u have entered the > >> formula and then go to format > >> > menu. in format menu choose cells... then > choose > >> number tab by pressing > >> > control plus tab. in number tab press tab once > >> then your cursor goes to > >> > category list. in category list select number > by > >> pressing down arrow. > >> > after > >> > selecting number press tab it will jump to the > >> decimal places, choose 2 > >> > from > >> > that spin box and click on ok.your problem will > be > >> solved. > >> > > >> > Regards > >> > Ajay Sharma > >> > > >> >
Re: [AI] EXCEL QUERY
Thanks Sameer once again but this didn't solve the problem this time. By doing this, it is pasting only in the cell where I'm standing, it is not dragging for all 60 students. That simply means each time I have to repeat my action. If this be the case, then what is the difference between paste and paste special? Another thing that I would like to ask is that when I convert to 2 decibels, my result comes .1% less than the actual result. However, when in the option, in the calculation tab, I check the box, which says "precision as displayed", then the accurate result comes but before I press the ok button after clearing that box, it says, "all data will permanently lose accuracy!". What does that mean? In my case, instead of losing, it is giving me more precise accuracy, ha ha ha! Regards, Vikas Kapoor, MSN ID: [EMAIL PROTECTED] Yahoo ID: [EMAIL PROTECTED] Skype ID: dl_vikas Mobile: (+91) 9891098137. - Original Message - From: "sameer latey" <[EMAIL PROTECTED]> To: Sent: Saturday, July 08, 2006 10:31 PM Subject: Re: [AI] EXCEL QUERY > > Try the following to copy and paste the same formula > in multiple cells. > > 1. Place your focus on the cell from which you want to > copy the formula and the number formats. > 2. Press Ctrl+C to copy. > 3. Select the cells in which you want to paste. > 4. Go to Edit on the Menu Bar and arrow down to Paste > Special. Press enter on the Paste Special option. > 5. A dialog box will open containing a series of radio > buttons. Arrow down through the radio buttons till you > come to the button titled "Formulas and Number > Formats". > 6. Select the Formulas and Number Formats radio button > and press OK. > > This should paste the formula and the number format of > 2 decimal places in all the destination cells. > > Regards > Sameer > --- Vikas Kapoor <[EMAIL PROTECTED]> wrote: > >> Thanks a lot, Ajay and Sameer for such a prompt >> response. My problem is now >> completely solved. One more thing please, if we have >> to copy the same >> formula for every student, we generally do by copy >> and paste command, while >> the sighted people would do just at a click of a >> mouse button for all the >> students, no matter hundreds of them, is there any >> way through jaws to drag >> the same way as it is done by mouse? >> Regards, >> Vikas Kapoor, >> MSN ID: >> [EMAIL PROTECTED] >> Yahoo ID: >> [EMAIL PROTECTED] >> Skype ID: dl_vikas >> Mobile: (+91) 9891098137. >> - Original Message - >> From: "ajay sharma" <[EMAIL PROTECTED]> >> To: >> Sent: Saturday, July 08, 2006 5:38 PM >> Subject: Re: [AI] EXCEL QUERY >> >> >> > hi vikas myself ajay sharma from blind relief >> association, delhi >> > >> > select the cells in which u have entered the >> formula and then go to format >> > menu. in format menu choose cells... then choose >> number tab by pressing >> > control plus tab. in number tab press tab once >> then your cursor goes to >> > category list. in category list select number by >> pressing down arrow. >> > after >> > selecting number press tab it will jump to the >> decimal places, choose 2 >> > from >> > that spin box and click on ok.your problem will be >> solved. >> > >> > Regards >> > Ajay Sharma >> > >> > >> > >> > On 7/8/06, Vikas Kapoor <[EMAIL PROTECTED]> >> wrote: >> >> >> >> Dear Members, >> >> I know here on this list there are many excel >> specialists. Though I don't >> >> have any mastery over excel, I use this >> application for a very limited >> >> purposes like preparing the internal assessment >> for my college students >> >> and >> >> I find it very useful for this purpose. I just >> wanted to know one very >> >> minute clarification, that is, how do we restrict >> the formula results to >> >> only two digits after dot. Suppose, after some >> calculations, if the >> >> result >> >> displayed is, 75.318654, how can we restrict to >> only two digits, that is, >> >> 75.32. My sighted friends do this just at a click >> of one mouse command, >> >> but when I try to access the same with the jaws, >> or pc cursor, it is not >> >> visible. >> >> Regards, >> >> Vikas Kapoor, >> >> MSN ID: >> >> [EMAIL PROTECTED] >> >> Yahoo ID: >> >> [EMAIL PRO
Re: [AI] EXCEL QUERY
Try the following to copy and paste the same formula in multiple cells. 1. Place your focus on the cell from which you want to copy the formula and the number formats. 2. Press Ctrl+C to copy. 3. Select the cells in which you want to paste. 4. Go to Edit on the Menu Bar and arrow down to Paste Special. Press enter on the Paste Special option. 5. A dialog box will open containing a series of radio buttons. Arrow down through the radio buttons till you come to the button titled "Formulas and Number Formats". 6. Select the Formulas and Number Formats radio button and press OK. This should paste the formula and the number format of 2 decimal places in all the destination cells. Regards Sameer --- Vikas Kapoor <[EMAIL PROTECTED]> wrote: > Thanks a lot, Ajay and Sameer for such a prompt > response. My problem is now > completely solved. One more thing please, if we have > to copy the same > formula for every student, we generally do by copy > and paste command, while > the sighted people would do just at a click of a > mouse button for all the > students, no matter hundreds of them, is there any > way through jaws to drag > the same way as it is done by mouse? > Regards, > Vikas Kapoor, > MSN ID: > [EMAIL PROTECTED] > Yahoo ID: > [EMAIL PROTECTED] > Skype ID: dl_vikas > Mobile: (+91) 9891098137. > - Original Message - > From: "ajay sharma" <[EMAIL PROTECTED]> > To: > Sent: Saturday, July 08, 2006 5:38 PM > Subject: Re: [AI] EXCEL QUERY > > > > hi vikas myself ajay sharma from blind relief > association, delhi > > > > select the cells in which u have entered the > formula and then go to format > > menu. in format menu choose cells... then choose > number tab by pressing > > control plus tab. in number tab press tab once > then your cursor goes to > > category list. in category list select number by > pressing down arrow. > > after > > selecting number press tab it will jump to the > decimal places, choose 2 > > from > > that spin box and click on ok.your problem will be > solved. > > > > Regards > > Ajay Sharma > > > > > > > > On 7/8/06, Vikas Kapoor <[EMAIL PROTECTED]> > wrote: > >> > >> Dear Members, > >> I know here on this list there are many excel > specialists. Though I don't > >> have any mastery over excel, I use this > application for a very limited > >> purposes like preparing the internal assessment > for my college students > >> and > >> I find it very useful for this purpose. I just > wanted to know one very > >> minute clarification, that is, how do we restrict > the formula results to > >> only two digits after dot. Suppose, after some > calculations, if the > >> result > >> displayed is, 75.318654, how can we restrict to > only two digits, that is, > >> 75.32. My sighted friends do this just at a click > of one mouse command, > >> but when I try to access the same with the jaws, > or pc cursor, it is not > >> visible. > >> Regards, > >> Vikas Kapoor, > >> MSN ID: > >> [EMAIL PROTECTED] > >> Yahoo ID: > >> [EMAIL PROTECTED] > >> Skype ID: dl_vikas > >> Mobile: (+91) 9891098137. > >> To unsubscribe send a message to > >> [EMAIL PROTECTED] 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 > >> > > > > > > > > -- > > Ajay Sharma > > Delhi > > 9899326670 > > 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 > > > > 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 > __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com 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
Re: [AI] EXCEL QUERY
Thanks a lot, Ajay and Sameer for such a prompt response. My problem is now completely solved. One more thing please, if we have to copy the same formula for every student, we generally do by copy and paste command, while the sighted people would do just at a click of a mouse button for all the students, no matter hundreds of them, is there any way through jaws to drag the same way as it is done by mouse? Regards, Vikas Kapoor, MSN ID: [EMAIL PROTECTED] Yahoo ID: [EMAIL PROTECTED] Skype ID: dl_vikas Mobile: (+91) 9891098137. - Original Message - From: "ajay sharma" <[EMAIL PROTECTED]> To: Sent: Saturday, July 08, 2006 5:38 PM Subject: Re: [AI] EXCEL QUERY > hi vikas myself ajay sharma from blind relief association, delhi > > select the cells in which u have entered the formula and then go to format > menu. in format menu choose cells... then choose number tab by pressing > control plus tab. in number tab press tab once then your cursor goes to > category list. in category list select number by pressing down arrow. > after > selecting number press tab it will jump to the decimal places, choose 2 > from > that spin box and click on ok.your problem will be solved. > > Regards > Ajay Sharma > > > > On 7/8/06, Vikas Kapoor <[EMAIL PROTECTED]> wrote: >> >> Dear Members, >> I know here on this list there are many excel specialists. Though I don't >> have any mastery over excel, I use this application for a very limited >> purposes like preparing the internal assessment for my college students >> and >> I find it very useful for this purpose. I just wanted to know one very >> minute clarification, that is, how do we restrict the formula results to >> only two digits after dot. Suppose, after some calculations, if the >> result >> displayed is, 75.318654, how can we restrict to only two digits, that is, >> 75.32. My sighted friends do this just at a click of one mouse command, >> but when I try to access the same with the jaws, or pc cursor, it is not >> visible. >> Regards, >> Vikas Kapoor, >> MSN ID: >> [EMAIL PROTECTED] >> Yahoo ID: >> [EMAIL PROTECTED] >> Skype ID: dl_vikas >> Mobile: (+91) 9891098137. >> To unsubscribe send a message to >> [EMAIL PROTECTED] 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 >> > > > > -- > Ajay Sharma > Delhi > 9899326670 > 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 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
Re: [AI] EXCEL QUERY
Try the following steps and see if they solve your problem. 1. In Excel, place your focus on the cell for which you want to restrict the result. 2. Press Ctrl+1 to open the Cell Format dialog. This same dialog can also be accessed from the Format menu. 3. Tab to the list box containing the various choices like General, Currency, time, date etc. Arrow down to Number and tab to the sub options. 4. You will find an Edit box where you can specify the number of decimal places. Set this to 2 and tab over to OK and press it. The result will now be restricted to 2 decimal places. You can do this for an entire row/ column by selecting the entire row/ column and repeating the above steps. Regards Sameer --- Vikas Kapoor <[EMAIL PROTECTED]> wrote: > Dear Members, > I know here on this list there are many excel > specialists. Though I don't have any mastery over > excel, I use this application for a very limited > purposes like preparing the internal assessment for > my college students and I find it very useful for > this purpose. I just wanted to know one very minute > clarification, that is, how do we restrict the > formula results to only two digits after dot. > Suppose, after some calculations, if the result > displayed is, 75.318654, how can we restrict to only > two digits, that is, 75.32. My sighted friends do > this just at a click of one mouse command, but when > I try to access the same with the jaws, or pc > cursor, it is not visible. > Regards, > Vikas Kapoor, > MSN ID: > [EMAIL PROTECTED] > Yahoo ID: > [EMAIL PROTECTED] > Skype ID: dl_vikas > Mobile: (+91) 9891098137. > 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 > __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com 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
Re: [AI] EXCEL QUERY
hi vikas myself ajay sharma from blind relief association, delhi select the cells in which u have entered the formula and then go to format menu. in format menu choose cells... then choose number tab by pressing control plus tab. in number tab press tab once then your cursor goes to category list. in category list select number by pressing down arrow. after selecting number press tab it will jump to the decimal places, choose 2 from that spin box and click on ok.your problem will be solved. Regards Ajay Sharma On 7/8/06, Vikas Kapoor <[EMAIL PROTECTED]> wrote: > > Dear Members, > I know here on this list there are many excel specialists. Though I don't > have any mastery over excel, I use this application for a very limited > purposes like preparing the internal assessment for my college students and > I find it very useful for this purpose. I just wanted to know one very > minute clarification, that is, how do we restrict the formula results to > only two digits after dot. Suppose, after some calculations, if the result > displayed is, 75.318654, how can we restrict to only two digits, that is, > 75.32. My sighted friends do this just at a click of one mouse command, > but when I try to access the same with the jaws, or pc cursor, it is not > visible. > Regards, > Vikas Kapoor, > MSN ID: > [EMAIL PROTECTED] > Yahoo ID: > [EMAIL PROTECTED] > Skype ID: dl_vikas > Mobile: (+91) 9891098137. > To unsubscribe send a message to [EMAIL PROTECTED] 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 > -- Ajay Sharma Delhi 9899326670 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
